Working With Larger Workbooks

Using Microsoft Excel

3 Hours
Versions 2003 or 2007

Working with Larger Workbooks

Keeping Headings on the Screen as You Work

Hiding Columns

Sorting Rows of Information

Creating and Working with Multiple-Sheet Files

Creating a Multi-sheet Workbook

Copying Sheets

Writing a 3D Sum

Formatting Multiple Sheets Simultaneously

Grouping Multiple Sheets

Formatting Cells on Multiple Sheets

Ungrouping Sheets

Writing Formulas that Link Multiple Excel Files

Opening Multiple Workbooks

Creating Links Between Workbooks

Viewing Link Information

Watching a Formula

Editing Linked Source Files

Inserting Rows and Columns in the Source Files

Saving Multiple Files as a Workspace

Opening a Workspace

Working With Shared Workbooks

Creating Shared Workbooks

Tracking Changes in a Shared Workbook

Reviewing and Accepting/Rejecting Changes