Filename | Size |
| 00 Introduction/0001 Welcome.mov | 12.3 MB |
| 00 Introduction/0002 Using the exercise files.mov | 1.4 MB |
| 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0101 Learning basic navigation tips.mov | 18.3 MB |
| 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov | 8.3 MB |
| 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0103 Copying and moving sheets within a workbook.mov | 7.6 MB |
| 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0104 Changing tab colors and renaming sheets.mov | 5.4 MB |
| 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov | 11.1 MB |
| 02 Working with Multiple Worksheets/0201 Displaying multiple worksheets from the same workbook.mov | 17.5 MB |
| 02 Working with Multiple Worksheets/0202 Copying, moving, and inserting data on different sheets.mov | 5.6 MB |
| 02 Working with Multiple Worksheets/0203 Applying global changes to worksheets.mov | 7.4 MB |
| 03 Linking Worksheets with Formulas/0301 Creating linkage formulas.mov | 6.8 MB |
| 03 Linking Worksheets with Formulas/0302 Creating 3D formulas for worksheets with identical layouts.mov | 10.3 MB |
| 03 Linking Worksheets with Formulas/0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov | 19.5 MB |
| 04 Working with Multiple Workbooks/0401 Navigating between open workbooks.mov | 7 MB |
| 04 Working with Multiple Workbooks/0402 Displaying multiple worksheets from different workbooks.mov | 10 MB |
| 04 Working with Multiple Workbooks/0403 Copying and moving data and entire worksheets across different workbooks.mov | 12 MB |
| 05 Linking Formulas Across Multiple Workbooks/0501 Creating formulas that link worksheets in different workbooks.mov | 7.7 MB |
| 05 Linking Formulas Across Multiple Workbooks/0502 Locating and managing links between multiple workbooks.mov | 11 MB |
| 05 Linking Formulas Across Multiple Workbooks/0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov | 19.2 MB |
| 06 Conclusion/0601 Final thoughts.mov | 2.7 MB |
| Exercise Files/Ex_Files_Ex10_Worksheets.zip | 3.6 MB |