Microsoft Excel 2000 Advanced

Course Aims
This training course is designed to give users an understanding of some of the more advanced features and functions within Microsoft Excel 2000. It is entirely 'hands on', so those attending will get practice in using advanced features of Microsoft Excel to manage, automate and customise workbooks.
Who Should Attend?
Existing users of Microsoft Excel who want to gain further practical and in-depth knowledge of the software. Note : A good working knowledge of Microsoft Excel in a Windows environment is required.
Course Outline: Microsoft Excel 2000 Advanced
Custom Formatting
· Formatting Numbers · Using Custom Formats · Custom Number Format Sections · Custom Number Format Codes · Custom Date Format Codes · Formatting SpeedKeys · Using Conditional Formats
Working with Named Ranges
· Creating Range Names · Using the Go To Command · Range Names in Calculations
Importing and Exporting Data
· Using Paste Special · Object Linking and Embedding · Sharing Workbooks with Other Applications · Importing a Text File into Excel · Importing Data from Web Pages
Templates and Add-Ins
· Creating Workbook Templates · Custom Templates · Storing Templates · The Default Template · Loading Add-In Programs
Working with Multiple Workbooks
· Creating Custom Views · Creating a Workspace File · Using Workspace Files · Linking Workbooks · Creating Formulae to Link Data
Printing Workbooks and Reports
· Printing Multiple Worksheets · Printing Multiple Workbooks · Using the Report Manager
Lookup and Reference Functions
· Using the LOOKUP Function · Using the VLOOKUP Function · Using the HLOOKUP Function · Preventing LOOKUP Errors · Conditional Statistical Formulas
Working with Toolbars
· Displaying Hidden Toolbars · Floating and Docking Toolbars · Customising Toolbars · Creating a Toolbar · The Menu Bar
Using Macros
· Understanding Macros · Recording a Basic Macro · Relative References · Running a Macro · Editing and Deleting Macros · Assigning a Macro to a Toolbar or Menu · Button Image Editor · Macro Virus Protection
Creating Map Charts
· Creating Data Map Charts · Editing a Map Chart · Adding Features to a Map