Workbooks and Worksheet Templates

Presenting Scenarios (What if... analysis)

Functions

Text Functions

Date and Time functions

Spreadsheet Databases

Sorting Database

Autofilter

Advanced Filter

Database functions

Data Exchange

CSV Files

Importing Data

Exporting Data

Outline

Subtotals

Pivot Tables

Creating pivot tables from different sources

Calculated field and calculated item

Consolidating data in a pivot table

Macros

Recording Macros

Reading and modyfing VBA macro code

Assigning macro to an icon or a button

Creating and utilizing forms