Normal Course Fee: £220 + VAT (before discount) With Discount: £176 + VAT (JustAccountancyJobs Members)
Objective:
To give users an extended knowledge of Excel’s advanced features and functions. Delegates will learn how to manage, automate and customise workbooks.
Suitability:
This course is suitable for existing users of Excel who want to gain further in-depth knowledge in a short space of time. Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Intermediate” course or from a user environment. Excel Advanced Content
Custom Formatting Working with Multiple Workbooks Importing and Exporting Data Lookup and Reference Functions Templates and Add-Ins Working with Named Ranges Working with Toolbars Using Macros
Duration: 1 Day
Course Dates: 08&23 Sep, 07&20 Oct, 04&17 Nov, 09&22 Dec 2010
- Formatting Numbers; Using Custom Formats
- Custom Number Format Sections
- Custom Number Format Codes
- Custom Date Format Codes
- Formatting SpeedKeys; Using Conditional Formats
- Creating Custom Views
- Creating a Workspace File
- Using Workspace Files
- Linking Workbooks
- Creating Formulae to Link Data
- Printing Workbooks
- Printing Multiple Worksheets
- Printing Multiple Workbooks
- Using Paste Special
- Object Linking and Embedding
- Opening Text Files in Excel
- Importing a Text File into Excel
- Importing Data from Web Pages
- Using the LOOKUP Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Preventing LOOKUP Errors
- Creating Workbook Templates
- Custom Templates; Storing Templates
- The Default Template
- Loading Add-In Programs
- Creating Range Names
- Using the Go To Command
- Range Names in Calculations
- Displaying Different Toolbars
- Creating a New Toolbar
- Understanding MacrosRecording a Basic Macro
- Relative References
- Running a Macro
- Assigning a Macro to a Toolbar
- Button Image Editor
- Editing a Macro
Just Accountancy Jobs has negotiated a special discount of 20%, for candidates if you apply via our website link below:-
