Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel 2013: Managing Multiple Worksheets and Workbooks

via LinkedIn Learning

Overview

Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Mastering the Utility Tasks Associated with Multiple Worksheets
  • Navigating multiple worksheets
  • Inserting and deleting sheets
  • Copying and moving sheets within a workbook
  • Changing tab colors and renaming sheets
  • Hiding, unhiding, and protecting sheets
2. Working with Different Worksheets Together
  • Displaying multiple worksheets of the same workbook
  • Copying, moving, and/or inserting data on different sheets
  • Selecting adjacent or nonadjacent sheets
3. Linking Worksheets with Formulas
  • Creating linkage formulas
  • Creating 3D formulas for worksheets with identical layouts
  • Summarizing multiple worksheets with PivotTables or consolidation
4. Working with Multiple Workbooks
  • Navigating multiple workbooks
  • Displaying multiple worksheets of different workbooks
  • Moving and copying data and entire worksheets across different workbooks
5. Linking Formulas across Multiple Workbooks
  • Creating formulas that link worksheets in different workbooks
  • Locating and managing links between multiple workbooks
  • Summarizing data from multiple workbooks with PivotTables or consolidation
Conclusion
  • Goodbye

Taught by

Dennis Taylor

Reviews

4.6 rating at LinkedIn Learning based on 41 ratings

Start your review of Excel 2013: Managing Multiple Worksheets and Workbooks

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.