Working With Larger Workbooks in Microsoft Excel

3 Hours

Course Overview

This instructor-led 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.

Course Objectives

• Work with features like freezing headings, hiding columns, and sorting rows
• Create formulas to summarize data across worksheets and multiple files
• Save multiple files as a workspace to create a shortcut for easy access
• Create a shared workbook to allow multiple people to work at the same time
• Track changes made and decide whether to accept/reject the changes

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

• Creating Shared Workbooks
• Highlighting Changes
• Accepting and Rejecting Changes