Microsoft Excel 2007 Advanced Guide

By the end of this course you will be able to use PivotTables to summarise and analyse data; use a collection of data management tools and functions to extract data from large data lists; import and export data to and from Excel and record and execute macros.

Don't forget the quiz at the end of Excel 2007 advanced guide to test what you have learnt

Auditing Worksheets

Data Validation

Validate a Worksheet

Tracing Formulas

Formula Errors

Data Management

Subtotal

Advanced Filter

Database Functions

Excel 2007 Tables

Remove Duplicates

Converting Text to Columns

Joining Cell Data

PivotTables and PivotCharts

Creating a PivotTable

Specifying PivotTable Data

Changing a PivotTables Calculation

Updating a PivotTable

Sorting and Filtering a PivotTable

Grouping PivotTable data

Formatting a PivotTable

PivotTable Options

Creating a PivotChart

What If Analysis

Goal Seek

Data Tables

Using Scenarios

Solver

Excel 2007 Macros

Record a Macro

Assign a Macro to a Button

Relative References in Macros

Email Stumble

Guides