Course Outline

Excel 2003/2007/2010: Advanced

Days: 1

Prerequisites: Excel Intermediate or equivalent experience

Unit 1 : Advanced formulas

· Using names

· Defining names

· Decision-making (IF)

· Nesting with IF

· Financial functions

Unit 2 : Lookups and data tables

· Lookup functions (VLOOKUP)

· MATCH and INDEX

· Data tables

Unit 3 : Advanced list management

· Subtotals

· Data validation

· Database functions

· Data forms

Unit 4 : PivotTables

· Creating a PivotTable

· Rearranging PivotTables

· Formatting PivotTables

· PivotCharts

Unit 5 : Exporting and Importing

· Exporting data

· Importing data

· Querying external databases

Unit 6 : Analytical options

· Goal Seek and Solver

· Scenarios

· Views

· Reports

Unit 7 : Macros

· Recording and running a macro

· Editing VBA code

· Function procedures

Unit 8 : Advanced web topics

· Creating interactive web spreadsheets

· PivotTables on the web