Excel 2016: Managing Multiple Worksheets and Workbooks
Offered By: LinkedIn Learning
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
- 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
- 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
- Navigating workbooks
- Displaying multiple worksheets of different workbooks
- Copying and moving data and entire worksheets across different workbooks
- Creating formulas that link worksheets in different books
- Locating and managing links between multiple workbooks
- Next steps
Taught by
Dennis Taylor
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity 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