Excel Basics
Spreadsheet terminology.
Exploring the Excel window.
Opening and navigating a workbook.
Closing a workbook.

Entering and Editing Data
Creating a new Excel workbook.
Entering and editing labels and values.
Entering and editing formulas.
Saving and updating a workbook.

Printing
Preparing to print.
Page set up options.

Modifying a Worksheet
Moving and copying data.
Moving and copying formulas.
Using absolute references.
Inserting and deleting ranges.

Using Functions
Entering Functions.
Using Autosum.
Using AVERAGE, MIN, MAX, and COUNT.

Formatting Worksheets
Formatting text.
Formatting rows and columns.
Number formatting.
Other formatting features.

Web Features
Saving a worksheet as a web page.
Adding hyperlinks.
Sending a workbook via email.

Working with Large Worksheets
Viewing options.
Hiding/displaying data.
Printing large worksheets.

Working With Multiple Worksheets
Using multiple worksheets.
Linking worksheets by using 3-D formulas.
Managing workbooks.

Documenting and Auditing
Comments and Text Boxes.
Auditing features.
Protecting cells.

List Management
Creating lists.
Sorting and filtering.
Lists.
Advanced filtering.

Advanced Formatting
Borders and shading.
Special number formats.
Dates.
Styles.
Conditional formatting.

Customizing Excel
Changing options.
Customizing toolbars and menus.

Creating Charts
Creating a chart.
Printing charts
Formatting chart options.
Adding graphic elements.

Databases
Database terms.
Advanced filter.
Database functions.

Pivot Tables
Creating a pivot table.
Modifying a pivot table.
Formatting data.
Refreshing data.
Using the drill down facility.
Sorting & filtering data.
Adding calculated fields.
Grouping data.

Conditional Statements
Excel’s logical functions.
Creating conditional tests.
Using formulae within Conditional tests.
Nesting conditional statements.

Multiple Files
Working with multiple files.
Displaying multiple files.
Moving & copying Worksheets.
Creating formulas between multiple files.
Editing linked formulae.
Consolidating data
Setting up a consolidation
Consolidation by position
Consolidation by category.

Scenario Manager
Creating a scenario.
Displaying scenarios.
Editing scenarios.
Creating scenario reports.

Macros
Recording simple macros.
Macro storage.
Running macros.
Absolute & relative references.
Assigning shortcuts to macros.
Creating a macro button
Viewing VBA code.