Toolbars and Views
Creating a Custom Toolbar
Resetting a Default Toolbar
Changing the View
Using Zoom
Viewing Multiple Workbooks
Comparing Two Workbooks
Saving a Custom View

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

Working with Graphics
Inserting Graphics
Creating AutoShapes
Formatting Graphic Objects

Multiple Worksheets and WorkBooks
Referencing Cells in Other WorkSheets
Referencing Cells in Other Workbooks
Opening Workbooks with External References

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
Conditional Formatting

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

Shared Workbooks
Sharing WorkBooks
Sharing a WorkBook
Opening a Shared WorkBook
Saving Changes to a Shared WorkBook
Resolving Conflicts

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