Microsoft Excel Intermediate

Creating and Working with Multiple-Sheet Excel Files

Creating a Multi-sheet Workbook

Copying Sheets

Inserting and Deleting Worksheets

Writing a 3-D Reference

Formatting Multiple Sheets Simultaneously

Writing Formulas that Link Multiple Excel Files

Opening Multiple Workbooks

Copying a Worksheet to a New Workbook

Creating Links Between Workbooks

Viewing Link Information

Watching a Formula

Editing Linked Source Files

Inserting Rows and Columns in the Source File

Saving Multiple Files as a Workspace

Opening a Workspace

Writing More Advanced Excel Formulas

Absolute vs. Relative Cell References

Using IF Functions

Using Text Functions and Features

Using the Text to Columns Feature

Using the Concatenate Function

Using the TRIM Function

Using the Upper, Lower, and Proper Text Functions

Using Text Functions and Features (Cont.)

Using the Left, Mid, and Right Text Functions

Using the Paste Values Feature

Formula Auditing

Using the Formula Auditing Toolbar

Tracing Precedents and Dependents

Removing Arrows

Tracing Errors

Working with Shared Excel Workbooks

Creating Shared Workbooks

Tracking Changes in a Shared Workbook

Highlighting Changes

Reviewing and Accepting / Rejecting Changes

Charting Data in Excel

Creating Pie Charts

Moving and Resizing Charts

Formatting Objects

Previewing and Printing Charts

Changing Chart Print Options

Creating Column or Bar Charts

Changing the Numbering Scale

Changing the Chart Series to Rows or Columns

Working with Trendlines

Adding More Data to a Chart