Naming Ranges
Creating and Defining Named Ranges
Moving to a Named Range
The Name Manager

Further Functions
Using Built-in Functions
The IF Function
LOOKUP Functions
Using Dates in Calculations
Using Nested Functions
Formula Auditing
The Formula Evaluator
The Watch Window

Styles & Advanced Formatting
Inserting Comments
Showing, and Hiding Comments
Editing and Deleting a Comment
Applying a Style
Modifying Existing Styles
Using Format Painter
Applying an AutoFormat (Table Format)
Conditional Formatting

Working With Tables
Understanding Tables
Creating a Table
The Data Form
Searching For Records
Sorting Data

Filtering
Using AutoFilter
Setting AutoFilter Criteria
Using Custom Criteria
Removing AutoFilter

Sub Totals and Outlining
Creating Subtotals
Nesting Subtotals
Removing Subtotals
Automatic Outlining

Pivot Tables
Creating a Pivot Table Report
Modifying an Existing Pivot Table
Formatting a Pivot Table
Pivot Charts

Working with Large Worksheets
Freeze Panes
Split Screen
Multiple Windows
Cut, Copy and Paste between Workbooks

Multiple Sheets and Workbooks
Linking Using Paste Link
Linking Using Formulae
Grouping/Ungrouping Worksheets
Creating and Opening a Workspace