Conditional Formatting
Introduction to Conditional Formatting
Highlighting Specific Values
Data Bars
Color Scales
Icon Sets
Fine-Tuning Conditional Formatting
Using Multiple Rules

Organizing Data Using Tables
Create Tables
Modify Tables
Format Tables

Sorting and Filtering
Sorting Data
Mutlilevel Sorting
Filtering a List with Autofilter
Filtering a List with Advanced Filter

Working With Tables
Highlighting Duplicates
Combining Data from Multiple Tables
Auto Outline
Automatic Subtotaling

Advanced Charting
Exploding Slices in a Pie
Grouping Slices in a Pie
Creating Combination Charts

Working with Graphics
Inserting Pictures
Inserting ClipArt
Creating AutoShapes
Formatting Graphic Objects

Advanced Formulas and Functions
Inserting Functions
Formula Building Recommendations
Naming Cells and Ranges
Logical Statements
Conditional Formulas (AND, OR, NOT)
IF Functions
Nested IF Functions
Combining IF with AND, OR, and NOT
IS Functions
Using IS with IF to Change Error Messages

Database Formulas and Functions
The LOOKUP Function
Array Lookup
Vector Lookup
The VLOOKUP Function
The HLOOKUP Function

Detailed Functions
Date and Time Calculations
Text and Data Functions
Mathematical Functions
Statistical functions

Importing and Exporting
Exporting Data From Excel
Importing Data From Other Applications
CSV files