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
