Microsoft Excel Advanced

Using Excel as a Database

What is an Excel Database?

Setting up an Excel Database

Filtering Lists

Working with Advanced Filters

Using Database Functions

Using PivotTable Reports to
Summarize Data

Creating PivotTables to Summarize Data

Changing the PivotTable Field List
View

Adding Fields

Grouping Data

Changing the PivotTable Layout

Using Report Filters

Removing Fields

Changing Value Field Settings

Updating PivotTables

Using Data Analysis Tools

Creating Scenarios

Using the Subtotal Feature

Outlining Worksheets

Creating Manual Outlines

Using Data Analysis Tools

Working with Custom Views

Creating Macros

Using Conditional Formatting

Creating Macros Using the Macro Recorder

Creating VLOOKUP Formulas

Examining the VLOOKUP Function Syntax

Creating Lookup Tables

Creating Named Ranges

Writing VLOOKUP Formulas

Understanding Common Formula Error

Using the ISERROR Function to Hide Errors

Creating Templates

Validating Data Entry

Understanding Worksheet Protection

Creating Templates