Lesson 1:
Lookup Functions

Understanding Data Lookup Functions, Using CHOOSE, Using VLOOKUP, Using VLOOKUP For Exact Matches, Using HLOOKUP, Using INDEX, Using MATCH, Understanding Reference Functions, Using ROW And ROWS, Using COLUMN And COLUMNS, Using ADDRESS, Using INDIRECT, Using OFFSET

Lesson 2:
Setting Excel Options

Understanding Excel Options, Personalising Excel, Setting The Default Font, Setting Formula Options, Understanding Save Options, Setting Save Options, Setting The Default File Location, Setting Advanced Options

Lesson 3:
Chart Object Formatting

Understanding Chart Object, Formatting, Selecting Chart Elements, Using Shape Styles To Format Objects, Changing Column Colour, Changing Pie Slice Colour, Changing Bar Colours, Changing Chart Line Colours, Using Shape Effects, Filling The Chart Area And The Plot Area, Filling The Background, The Format Dialog Box, Using The Format Dialog Box, Using Themes

Lesson 4:
Labels and Names

Understanding Labels And Names, Creating Names Using Text Labels, Using Names In New Formulas, Applying Names To Existing Formulas, Creating Names Using The Names Box, Using Names To Select Ranges, Pasting Names Into Formulas, Creating Names For Constants, Creating Names From a Selection, Scoping Names To The Worksheet, Using The Name Manager, Documenting Range Names

Lesson 5:
Protecting Data

Understanding Data Protection, Providing Total Access To Cells, Protecting a Worksheet, Working With a Protected Worksheet, Disabling Worksheet Protection, Providing Restricted Access To Cells, Password Protecting a Workbook, Opening a Password Protected Workbook, Removing a Password From a Workbook

Lesson 6:
Summarising and Subtotalling

Creating Subtotals, Using a Subtotalled Worksheet, Creating Nested Subtotals, Copying Subtotals, Using Subtotals With AutoFilter, Installing The Conditional Sum Wizard, Using The Conditional Sum Wizard, Creating Relative Names For Subtotals, Using Relative Names For Subtotals

Lesson 7:
Data Linking

Understanding Data Linking, Linking Between Worksheets, Linking Between Workbooks, Updating Links Between Workbooks

Lesson 8:
Data Consolidation

Understanding Data Consolidation, Consolidating With Identical Layouts, Creating An Outlined Consolidation, Consolidating With Different Layouts

Lesson 9:
Pivot Tables

Understanding Pivot Tables, Creating a PivotTable Shell, Dropping Fields Into a PivotTable, Filtering a PivotTable, Clearing a Report Filter, Switching PivotTable Labels, Formatting a PivotTable

Lesson 10:
Pivot Table Techniques

Using Compound Fields, Counting In a PivotTable, Formatting PivotTable Values, Working With PivotTable Grand Totals, Working With PivotTable SubTotals, Finding The Percentage Of Total, Finding The Difference From, Grouping In PivotTables, Creating Running Totals, Creating Calculated Fields, Providing Custom Names, Creating Calculated Items, PivotTable Options, Sorting In a PivotTable

Lesson 11:
Pivot Charts

Creating a PivotChart Shell, Dragging Fields For The PivotChart, Changing The PivotChart Type, Using The PivotChart Filter Pane, Moving PivotCharts To Chart Sheets

Lesson 12:
Goal Seeking

Goal Seek Components, Using Goal Seek

Lesson 13:
Grouping and Outlining

Understanding Grouping And Outlining, Creating An Automatic Outline, Working With An Outline, Creating a Manual Group, Grouping By Columns

Lesson 14:
Solver

Understanding How Solver Works, Setting Solver Parameters, Adding Solver Constraints, Performing The Solver Operation, Running Solver Reports, Refining Solver Answers

Lesson 15:
Recorded Macros

Understanding Excel Macros, Setting Macro Security, Saving a Document As Macro Enabled, Recording a Simple Macro, Running a Recorded Macro, Relative Cell References, Running a Macro With Relative References, Viewing a Macro, Editing a Macro, Assigning a Macro To The Toolbar, Running a Macro From The Toolbar, Assigning a Keyboard Shortcut To a Macro, Deleting a Macro, Copying a Macro, Tips For Developing Macros

Lesson 16:
Recorder Workshop

Preparing Data For An Application, Recording a Summation Macro, Recording Consolidations, Recording Divisional Macros, Testing Macros, Creating Objects To Run Macros, Assigning a Macro To An Object