Excel Level 3

This course covers advanced aspects of Microsoft Excel focusing on advanced functions, productivity features and data analysis tools. Delegates should already be able to create and understand spreadsheets incorporating standard functions, charts and basic analysis tools.

At the end of the course delegates will be able to summarise data using subtotals, create and modify PivotTables, nest functions to create complex formula and use What If Analysis to predict the values required to reach a desired result. This course is available for Microsoft Office 2003, 2007 and 2010.

Understanding the Version Interface
Conditional Functions including If Functions
Variations of IF Functions including SumIf() and CountIf()
Nested IF Functions
Lookup Functions including VLookup and HLookup
Creating and Editing a PivotTable
Modifying The Layout Of A PivotTable Or Chart
Using The PivotTable Field List
Refreshing the Data within a PivotTable
Creating and Editing PivotCharts
Creating a Template
Creating a File Based on a Template
Protecting a Template
Password Protecting a File
Understanding and Creating Subtotals
Preparing Data for Subtotals
Editing a Subtotal
Modifying the Subtotal Formula
Using Subtotals to calculate averages
Database Functions including DMAX() and DCOUNT()
What If Aanalysis – Data Tables
What If Analysis – Goal Seek
What If Analysis – Scenarios
An introdcuction to Macros