Working With Larger Workbooks

Using Microsoft Excel

3 Hours
Versions 2007 and 2010

This course covers topics such as linking multiple worksheets and workbooks; working with larger workbooks; and sharing workbooks. It is geared for users who have experience with Microsoft Excel and need to learn these more intermediate/advanced features.

Freezing, Hiding, and Sorting Data

Keeping Headings on the Screen as You Work

Previewing Before Printing

Printing Row and Column Headings

Hiding and Unhiding Columns

Sorting Lists of Information

Creating Custom Sorts

Printing Worksheets

Creating and Working with Multiple-Sheet Files

Creating Multiple-Sheet Workbooks

Copying Worksheets

Inserting Worksheets

Deleting Worksheets

Writing 3-D References

Formatting Multiple Worksheets Simultaneously

Grouping Multiple Worksheets

Ungrouping Worksheets

Writing Formulas that Link Multiple Excel Files

Opening Multiple Workbooks Simultaneously

Copying Worksheets to New Workbook

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 Shared Workbooks

Creating Shared Workbooks

Highlighting Changes

Accepting and Rejecting Changes

Find us

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page