Excel Level 4

Auditing, Database, Pivot Tables, Analysis

Excel Expert 
* Review Exercise

Auditing a Worksheet
* Using Worksheet Auditing Tools
* Data Entry Validation
* Validating the Whole Worksheet
* Auditing Data Dependency
* Finding and Replacing Data

Working with Data Lists
* Setting Up Lists
* Sorting Lists
* Filtering Lists
* Using Forms

Data Management
* Searching for Data with Advanced Filters
* Compiling Consolidations
* Summarising Data with Outlines
* Querying a Database
* Data Sources
* Controlling Formatting and Layout
* Refreshing External Data

PivotTables 
* Creating a PivotTable
* Modifying a PivotTable
* Creating a PivotTable Chart
* Creating Interactive PivotTables for the Web

Using Analysis Tools
* Goal Seeking
* Using Solver
* The Scenario Manager
* Scenario Summaries
* Merging Scenarios

Collaborating with Workgroups
* Applying Worksheet Protection
* Password Protecting a File
* Changing Workbook Properties
* Adding Comments to the Worksheet
* Shared Workbooks
* Tracking Changes
* Resolving Conflicts
* Merging Workbooks
* E-mailing Workbooks for Review

[Home]