Upon successful completion of this course, students will be able to:
* Nest functions to create complex formulas
* Use advanced filters to analyse data in a list
* Use a variety of data validation techniques
* Use goal seeking to determine the values required    to reach a desired result
* Create, use and modify data tables
* Create and work with scenarios and the Scenario    Manager
* Create, modify and work with PivotTables
* Use linking to create more efficient workbooks
* Combine data in separate worksheets or workbooks    using consolidation
* Publish workbooks and worksheets for the web
* Summarise data using subtotals and relative range    naming
* Confidently open workbooks that contain macros
* Create recorded macros in Excel
* Use the macro recorder to create a variety of    macros.

Unit 1: Nesting Functions Workshop

* Scoping A Formula
* Developing A Nested Function
* Creating A Nested Function
* Editing A Formula With Nested Functions
* Copying A Formula With Nested Functions
* Concatenation

Unit 2: Advanced Filters

* Advanced Filter Concepts
* Using An Advanced Filter
* Extracting Records With Advanced Filter
* Using Formulas In Criteria
* Using Database Functions

Unit 3: Validations

* Validation Techniques
* Data Validation By Number Range
* Testing Data Validation
* Input Messages
* Creating Error Alerts
* Creating Drop-Down Lists
* Using Formulas As Validation Criteria
* Creating Custom Validation Criteria
* Number Formats With Built-in Logic
* Conditional Formatting
* Copying Data Validation Settings

Unit 4: Goal Seeking

* Goal Seek Components
* Using Goal Seeking

Unit 5: Scenarios

* Creating A Default Scenario
* Creating Scenarios
* Using Names in Scenarios
* Displaying Scenarios
* Creating A Scenario Summary Report
* Merging Scenarios

Unit 6: Summarising Data

* Creating Subtotals
* Using A Subtotaled 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

Unit 7: PivotTables

* PivotTable Theory
* Creating A Simple PivotTable
* Adding A Row Field To A PivotTable
* Using The Page Field In A PivotTable
* Filtering Row And Column Values
* Formatting A PivotTable
* Counting With PivotTables
* PivotTable Summary And Display Options
* Show Data As Percentages In PivotTables
* Calculated Fields In PivotTables
* Calculated Items In PivotTables
* Creating A PivotChart
* Modifying A PivotChart Via The PivotTable

Unit 8: Linking Workbooks

* Linking Data In Excel
* Linking Within A Workbook
* Linking Between Workbooks
* Updating Links Between Workbooks

Unit 9: Consolidation

* Consolidating Data With Identical Layouts
* Consolidating Data With Different Layouts
* Consolidating Data Using A PivotTable

Unit 10: Macro Virus Control

* Opening Workbooks With Macros
* Setting Macro Security Levels
* Trusting Publishers
* Creating A Digital Signature
* Removing A Trusted Publisher

Unit 11: Recorded Macros

* Setting Macro Security Levels
* Recording A Simple Macro
* Running A Recorded Macro
* Relative Cell References
* Running A Macro With Relative References
* Viewing A Macro Module
* Modifying A Recorded Macro

Appendix 1: Data Tables

* Using A Simple What-If Model
* Creating A One-Variable Table
* Using One-Variable Data Tables
* Creating A Two-Variable Data Table

Appendix 2: Excel On The Web

* Previewing Workbooks As Web Pages
* Publishing A Static Worksheet
* Adding To An Existing Web Page
* Publishing An Interactive Web Page

Appendix 3: Recorder Workshop

* Preparing Data
* Recording Summation Macros
* Recording Consolidations
* Recording Divisional Macros
* Testing Macros
* Creating Objects To Run Macros
* Assigning A Macro To An Object'