Excel 365: Managing Multiple Worksheets and Workbooks

Time: 1.5 Hours

Course Description:

Learn how to share data between multiple worksheets and workbooks.  Tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks.

Course Material:

A customized step-by-step Quick Reference Card with screenshots is included in this class which covers each topic you will learn.

Course Outline:

  • Utilities for Multiple Worksheets

  • Navigation Tips

  • Navigating Between Open Workbooks

  • Quickly Adding New Sheet(s)

  • Selecting Worksheets

  • Deleting Worksheet(s)

  • Navigating within a Worksheet

  • Copying a Worksheet

  • Moving a Worksheet

  • Coordinating Using Tab Colors on Worksheets

  • Hiding and Unhiding Worksheets

  • Creating a Table of Contents

  • Protecting Workbooks and Worksheets

  • Password Protecting Entire Excel File

  • Protecting Formulas and Cells

  • Utilities for Multiple Worksheets

  • Navigation Tips

  • Navigating Between Open Workbooks

  • Quickly Adding New Sheet(s)

  • Selecting Worksheets

  • Deleting Worksheet(s)

  • Navigating within a Worksheet

  • Copying a Worksheet

  • Moving a Worksheet

  • Coordinating Using Tab Colors on Worksheets

  • Hiding and Unhiding Worksheets

  • Creating a Table of Contents

  • Protecting Workbooks and Worksheets

  • Password Protecting Entire Excel File

  • Protecting Formulas and Cells