Microsoft Excel 1

Setup & Printing Issues
Nested Functions.
Consolidating Data using a 3-D Reference Sum Function.
Mixed References within Formulas.
Time & Date Functions
Mathematical Functions

Logical Functions
Statistical Functions
Financial Functions
Lookup Functions
Database Functions
Named Ranges

Cell Formatting
Applying Styles to a Range.
Conditional Formatting.
Custom Number Formats.
Manipulating Worksheets
Templates
Paste Special Options.
Click here to download full outline.

Pivot Tables
Input Tables
Charts
Hyperlinks
Linking & Embedding

Importing Text Files
Sorting and Filtering Data
Tracking and Reviewing Changes
Scenarios
Validating

Auditing
Recording Macros (for writing macros, see VBA course link below)
Passwords & Security Issues

Click here to download full outline.
Click here for Excel VBA outline.

The Excel Cell Referencing System
Entering Numbers and Text
Worksheets and Workbooks
Selecting a Cell, cell range, row & column.
Manipulating Rows and Columns
Manipulating Cells and Cell Content

Formatting Worksheets
Freezing Row and Column Titles
Formulas
Creating Formulas
Operators
Relative Cell Referencing

Absolute Cell Referencing
Functions including Sum, Average, Max, Min, Count, Counta , Countblank , If
Charts

Click here to download full outline