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

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.