Excel 2013: Managing Multiple Worksheets and Workbooks

Learn how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013.

Introduction

• Welcome
• Using the exercise files

1. Mastering the Utility Tasks Associated with Multiple Worksheets

• 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

2. Working with Different Worksheets Together

• Displaying multiple worksheets of the same workbook
• Copying, moving, and/or inserting data on different sheets
• Selecting adjacent or nonadjacent sheets

3. Linking Worksheets with Formulas

• Creating linkage formulas
• Creating 3D formulas for worksheets with identical layouts
• Summarizing multiple worksheets with PivotTables or consolidation

4. Working with Multiple Workbooks

• Navigating multiple workbooks
• Displaying multiple worksheets of different workbooks
• Moving and copying data and entire worksheets across different workbooks

5. Linking Formulas across Multiple 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

Conclusion

• Goodbye