YoVDO

Excel 2016: Managing Multiple Worksheets and Workbooks

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Manipulation Courses Data Management Courses

Course Description

Overview

Learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks.

Syllabus

Introduction
  • Introduction
  • Using the exercise files
1. Utility Tasks Associated with Multiple Worksheets
  • Navigation and display tips
  • Inserting and deleting worksheets
  • Copying and moving worksheets within a workbook
  • Changing tab colors and renaming sheets
  • Hiding/unhiding worksheet tabs; protecting hidden worksheets
2. Working with Different Worksheets Together
  • Displaying multiple worksheets of the same workbook
  • Copying, moving, and inserting data on different sheets
  • Selecting adjacent or non-adjacent worksheets; applying global changes
  • Getting data from other sheets using formulas and the INDIRECT function
3. Working with Multiple Workbooks
  • Navigating workbooks
  • Displaying multiple worksheets of different workbooks
  • Copying and moving data and entire worksheets across different workbooks
4. Linking Formulas across Multiple Workbooks
  • Creating formulas that link worksheets in different books
  • Locating and managing links between multiple workbooks
Conclusion
  • Next steps

Taught by

Dennis Taylor

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard