Excel Training - Advanced v2003
Microsoft Excel Advanced Course Content Naming Ranges Define named ranges Use named ranges in formulas VLookUp and HLookUp Functions Using VLookUp Using HLookUp Linking Multiple Workbooks Use formulas to link workbooks Create a workspace Importing Data Import from external sources Using Microsoft Excel Query Pivot Tables and Charts Creating a PivotTable Changing field settings Creating a chart Templates and Styles Working with templates Working with styles Macros Creating macros Adding custom controls Analysing Data Using GoalSeek Using Solver Using Data Tables Scenario Manager Security and Proofing Protecting Excel files Worksheet protection Using data validation Using text to speech Customising Excel 2003 Customising toolbars Customising the environment Collaboration and Consolidation Sharing workbooks Sending workbooks Consolidating data