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.

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

Follow us on

Facebook  Twitter  You Tube