Microsoft Excel Intermediate

Advanced Worksheet Features

Creating a Multi-sheet Workbook

Copying Worksheets

Writing 3-D References

Formatting Multiple Sheets
Simultaneously

Writing Formulas that Link Multiple
Excel Workbooks

Opening Multiple Workbooks Simultaneously

Copying Worksheets to New
Workbooks

Creating Links Between Workbooks

Viewing Linked Information

Watching Formulas

Editing Source Files

Inserting Rows and Columns in the Source Files

Saving Multiple Workbooks as a Workspace

Opening Workspaces

Working with Statistical and Logical Functions

Understanding Absolute vs. Relative Cell References

Using the IF Function to Calculate Based on a Condition

Using the COUNT Function to Count a List of Numbers

Using the COUNTA Function to Count Non-Empty Cells

Using the COUNTBLANK Function to Count Blank Cells

Using the COUNTIF Function to Count Based on a Condition

Using the COUNTIFS Function to Count Based on Multiple Conditions

Using Text Functions and Features

Using the Text to Columns Feature

Using Text Functions

Auditing Formulas

Tracing Precedents

Removing Tracer Arrows

Tracing Dependents

Tracing Errors

Working with Shared Workbooks

Creating Shared Workbooks

Highlighting Changes

Accepting and Rejecting Changes

Charting Data

Creating Pie Charts

Modifying and Resizing Charts

Adding Chart Titles and Labels

Formatting Chart Objects

Previewing and Printing Charts

Creating Column or Bar Charts

Changing the Numbering Scale

Changing the Chart Series to Rows
or Columns

Working with Trendlines

Updating the Source Data