Excel Advanced

Microsoft Excel Advanced Course Overview
(Versions 2000, XP, 2003, 2007)

The Excel Advanced course will allow you to develop existing Excel skills and focuses on more useful functions of Excel. The course focuses more on advanced functions and data management tools, including lookup tables, pivot tables, nested IF statements, as well as helping automate work with the use of Macros.

The course is suitable for users who have had experience in creating their own spreadsheets, worked with formulas or have attended the Excel Introduction or Intermediate course.

By the end of the course you will be able to : Create and use Logical and Lookup functions Analyse, organise and summarise large data sets with the use of Pivot tables Automate Excel activities with the use of Macros
Using names	Defining names Creating names Applying names
Working with Advanced Formulas	Using decision-making functions Logical functions Creating nested functions Using financial functions
Lookups and Data Tables	Working with lookup functions Creating data tables
Advanced List Management	Creating subtotals Validating cell entries Database functions
Working with PivotTables and PivotCharts	Working with PivotTables Rearranging PivotTables Formatting PivotTables Working with PivotCharts
Exporting and Importing	Exporting and importing text files Querying external databases
Using Analytical Options	Working with scenarios Working with Goal Seek and Solver
Working with Macros	Running and recording macros Utilising the macro recorder Assigning macros to the toolbar and keyboard
Interactive Web Pages	Saving workbooks as Web pages Hyperlinks Sending workbooks via email Creating interactive Web spreadsheets Publishing PivotTables on the Web

Excel Introduction, Excel Intermediate

Back to Courses