Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks

1. 03 Linking Worksheets with Formulas/0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov 19.51 MB
2. 05 Linking Formulas Across Multiple Workbooks/0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov 19.17 MB
3. 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0101 Learning basic navigation tips.mov 18.34 MB
4. 02 Working with Multiple Worksheets/0201 Displaying multiple worksheets from the same workbook.mov 17.55 MB
5. 00 Introduction/0001 Welcome.mov 12.33 MB
6. 04 Working with Multiple Workbooks/0403 Copying and moving data and entire worksheets across different workbooks.mov 11.98 MB
7. 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov 11.09 MB
8. 05 Linking Formulas Across Multiple Workbooks/0502 Locating and managing links between multiple workbooks.mov 11.02 MB
9. 03 Linking Worksheets with Formulas/0302 Creating 3D formulas for worksheets with identical layouts.mov 10.32 MB
10. 04 Working with Multiple Workbooks/0402 Displaying multiple worksheets from different workbooks.mov 9.97 MB
11. 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov 8.33 MB
12. 05 Linking Formulas Across Multiple Workbooks/0501 Creating formulas that link worksheets in different workbooks.mov 7.71 MB
13. 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0103 Copying and moving sheets within a workbook.mov 7.55 MB
14. 02 Working with Multiple Worksheets/0203 Applying global changes to worksheets.mov 7.37 MB
15. 04 Working with Multiple Workbooks/0401 Navigating between open workbooks.mov 7.00 MB
16. 03 Linking Worksheets with Formulas/0301 Creating linkage formulas.mov 6.84 MB
17. 02 Working with Multiple Worksheets/0202 Copying, moving, and inserting data on different sheets.mov 5.61 MB
18. 01 Mastering the Utility Tasks Associated with Multiple Worksheets/0104 Changing tab colors and renaming sheets.mov 5.39 MB
19. 06 Conclusion/0601 Final thoughts.mov 2.71 MB
20. 00 Introduction/0002 Using the exercise files.mov 1.36 MB
21. Exercise Files/Chapter 04/Chartdata2011.xlsx 939 KB
22. Exercise Files/Chapter 01/Sample.xlsx 371 KB
23. Exercise Files/Chapter 05/CorporateData.xlsx 370 KB
24. Exercise Files/Chapter 01/HiddenSheets.xlsx 370 KB
25. Exercise Files/Chapter 02/DepartmentData.xlsx 368 KB
26. Exercise Files/Chapter 04/DivisionFiles.xlsx 368 KB
27. Exercise Files/Chapter 02/Sample.xlsx 368 KB
28. Exercise Files/Chapter 01/Hyperlink State File.xlsx 119 KB
29. Exercise Files/Chapter 03/3D Formulas.xlsx 112 KB
30. Exercise Files/Chapter 04/QuarterlyBudget.xlsx 74 KB
31. Exercise Files/Chapter 04/StateSalesData.xlsx 51 KB
32. Exercise Files/Chapter 05/California.xlsx 29 KB
33. Exercise Files/Chapter 05/Washington.xlsx 29 KB
34. Exercise Files/Chapter 05/Oregon.xlsx 29 KB
35. Exercise Files/Chapter 05/Arizona.xlsx 29 KB
36. Exercise Files/Chapter 04/Olive-California.xlsx 23 KB
37. Exercise Files/Chapter 05/Olive-California.xlsx 23 KB
38. Exercise Files/Chapter 03/LinkageFormulas.xlsx 22 KB
39. Exercise Files/Chapter 05/Olive-Arizona.xlsx 22 KB
40. Exercise Files/Chapter 04/Olive-Arizona.xlsx 22 KB
41. Exercise Files/Chapter 01/RegionalFile.xlsx 22 KB
42. Exercise Files/Chapter 02/SalesData.xlsx 22 KB
43. Exercise Files/Chapter 03/Sample.xlsx 22 KB
44. Exercise Files/Chapter 02/RegionalData.xlsx 22 KB
45. Exercise Files/Chapter 01/SalesData.xlsx 22 KB
46. Exercise Files/Chapter 01/RegionalFile2.xlsx 22 KB
47. Exercise Files/Chapter 04/Olive-Oregon.xlsx 21 KB
48. Exercise Files/Chapter 05/Olive-Oregon.xlsx 21 KB
49. Exercise Files/Chapter 03/PivotTableSummary.xlsx 21 KB
50. Exercise Files/Chapter 04/Olive-Nevada.xlsx 21 KB