Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.
Overview
Syllabus
Introduction
- Welcome
- Using the exercise files
- 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
- Displaying multiple worksheets of the same workbook
- Copying, moving, and/or inserting data on different sheets
- Selecting adjacent or nonadjacent sheets
- Creating linkage formulas
- Creating 3D formulas for worksheets with identical layouts
- Summarizing multiple worksheets with PivotTables or consolidation
- Navigating multiple workbooks
- Displaying multiple worksheets of different workbooks
- Moving and copying data and entire worksheets across different 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
- Goodbye
Taught by
Dennis Taylor