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
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera