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
