Register Now      202-747-5000
Road Map To Learning

Choose Your Learning Adventure:

Select from our standard “off-the-shelf” classes or build a course to target your learning goals. Ready to learn new skills? Contact Softek today!

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

Course Outline

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


Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats. Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Private Group Class: Live Virtual
1-4 students $850
5-8 students $1000
9-12 students* $1100
*$35 per additional student
Private Group Class: At Your Location
1-4 students $1100
5-8 students $1250
9-12 students* $1350
*$35 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).


Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.

Why Choose Softek?

  • Live, virtual or in-person training
  • Instructors with 15+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee