Pluralsight - Managing Excel Workbooks for Analytics by George Mount

1. 0. Course Overview/0. Course Overview.mp43.27MB
2. 1. Creating a Workbook/0. Introduction.mp43.65MB
3. 1. Creating a Workbook/1. Demo Files.mp4925.63KB
4. 1. Creating a Workbook/2. Demo- Input, Process, Output.mp45.71MB
5. 1. Creating a Workbook/3. Excel Tables and Workbook Management.mp42.38MB
6. 1. Creating a Workbook/4. Demo- Excel Tables.mp412.74MB
7. 1. Creating a Workbook/5. Demo- Named References.mp414.6MB
8. 1. Creating a Workbook/6. Summary.mp41.34MB
9. 2. Managing Workbooks/0. Introduction.mp43.24MB
10. 2. Managing Workbooks/1. Demo- Organizing Worksheets in a Workbook.mp412.85MB
11. 2. Managing Workbooks/2. Demo- Viewing Worksheets in a Workbook.mp416.62MB
12. 2. Managing Workbooks/3. Demo- Grouping Worksheets in a Workbook.mp411.43MB
13. 2. Managing Workbooks/4. Demo- Summarizing with 3-D References.mp47.8MB
14. 2. Managing Workbooks/5. Demo- Returning References with INDIRECT().mp49.47MB
15. 2. Managing Workbooks/6. Demo- Referencing Worksheets from a Different Workbook.mp412.98MB
16. 2. Managing Workbooks/7. Summary.mp41.62MB
17. 3. Forcing Workbooks to Recalculate/0. Introduction.mp43.05MB
18. 3. Forcing Workbooks to Recalculate/1. Demo- Workbook Calculation Options.mp410.93MB
19. 3. Forcing Workbooks to Recalculate/2. Demo- Tracking Values with the Watch Window.mp48.3MB
20. 3. Forcing Workbooks to Recalculate/3. Demo- Debugging with Formula Audit.mp420.32MB
21. 3. Forcing Workbooks to Recalculate/4. Summary.mp41.03MB
22. 4. Securing and Restricting Workbooks/0. Introduction.mp41.52MB
23. 4. Securing and Restricting Workbooks/1. Demo- Data Validation.mp419.35MB
24. 4. Securing and Restricting Workbooks/2. Demo- Protecting Ranges and Worksheets.mp412.73MB
25. 4. Securing and Restricting Workbooks/3. Demo- Protecting Workbooks.mp415.61MB
26. 4. Securing and Restricting Workbooks/4. Demo- Removing Workbook Metadata.mp412.05MB
27. 4. Securing and Restricting Workbooks/5. Summary.mp42.32MB
28. 5. Recovering Workbooks and Comparing Workbook Versions/0. Introduction.mp42.03MB
29. 5. Recovering Workbooks and Comparing Workbook Versions/1. Demo- Recovering Workbooks.mp413.04MB
30. 5. Recovering Workbooks and Comparing Workbook Versions/2. Demo- AutoSaving Workbooks.mp410.28MB
31. 5. Recovering Workbooks and Comparing Workbook Versions/3. Demo- Tracking Workbook Changes.mp423.01MB
32. 5. Recovering Workbooks and Comparing Workbook Versions/4. Demo- Workbook Co-authoring.mp417.16MB
33. 5. Recovering Workbooks and Comparing Workbook Versions/5. Demo- Spreadsheet Compare.mp426.88MB
34. 5. Recovering Workbooks and Comparing Workbook Versions/6. Conclusion.mp42.58MB
35. 5. Recovering Workbooks and Comparing Workbook Versions/7. Course Wrap-up and Further Learning.mp43.94MB