Microsoft Excel Advanced

Using Excel as a Database

Understanding the Concept of Excel Databases

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

Rearranging Fields within the Field List

Using Report Filters

Removing Fields

Changing Value Field Settings

Updating PivotTables with New Source Data

Using Data Analysis Tools

Creating Scenarios

Using the Subtotal Feature

Using Data Analysis Tools (cont.)

Outlining Worksheets

Working with Custom Views

Conditional Formatting and Creating Macros

Applying 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