Upon successful completion of this course, students will be able to:

* use a range of lookup and reference functions
* modify Excel options
* create and use labels and names in a workbook
* protect data in worksheets and workbooks
* summarise data using subtotals and relative range    naming
* use data linking to create more efficient workbooks
* use the Data Consolidation feature to combine data    from several workbooks into one
* understand and create simple PivotTables
* construct and operate PivotTables using some of the    more advanced techniques
* use goal seeking to determine the values required to    reach a desired result
* group cells and use outlines to manipulate the    worksheet
* use Solver to solve more complex and intricate    problems
* create recorded macros in Excel
* use the macro recorder to create a variety of macros

Unit 1: Looking up 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

Unit 2: Setting Excel Options

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

Unit 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

Unit 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

Unit 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

Unit 6: Summarising And Subtotalling

* Creating Subtotals
* Using A Subtotalled Worksheet
* Creating Nested Subtotals
* Copying Subtotals
* Using Subtotals With An AutoFilter
* Installing The Conditional Sum Wizard
* Using The Conditional Sum Wizard
* Creating Relative Names For Subtotals
* Using Relative Names For Subtotals

Unit 7: Data Linking

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

Unit 8: Data Consolidation

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

Unit 9: PivotTables

* Understanding PivotTables
* Creating A PivotTable Shell
* Dropping Fields Into A PivotTable
* Filtering A PivotTable
* Clearing A Report Filter
* Switching PivotTable Labels
* Formatting A PivotTable

Unit 10: PivotTable 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 Names
* PivotTable Options
* Sorting In A PivotTable

Unit 11:

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

Unit 12: Goal Seeking

* Goal Seeking Components
* Using Goal Seek

Unit 13: Grouping And Outlining

* Understanding Grouping And Outlining
* Creating An Automatic Outline
* Working With An Outline
* Creating A Manual Group
* Grouping By Columns

Unit 14: Solver

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

Unit 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

Unit 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