Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Working With Larger Workbooks
in Microsoft Excel

Version 2010 • 2013 • 2016

3 Hours

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

 

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

Investment

Public Class

This class is only offered for private groups.

Private Group Classes

Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9 to 12pm and 1 to 4pm).

Conducted at Your Office

$500 flat fee for up to 8 students
$550 flat fee for up to 12 students
$35 per additional student

Conducted at Softek’s Facility

$575 flat fee for up to 8 students
$625 flat fee for up to 12 students
$35 per additional student

Have more or less students? Or, need to schedule more than one training day? Click here for a price quote based on your training needs. 

Why choose Softek?

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