Completed
1. 00:00 Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
MS 365 Excel Basics: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips - Part 8
Automatically move to the next video in the Classroom when playback concludes
- 1 1. 00:00 Introduction
- 2 2. 00:29 Topics in Video
- 3 3. 01:13 Define Data Analysis, data and information
- 4 4. 03:38 What is Raw Data?
- 5 5. 04:13 What is a table?
- 6 6. 06:12 List of Excel Data Analysis Tools
- 7 7. 06:57 Excel Table feature
- 8 8. 09:07 What is a PivotTable and what does it do?
- 9 9. 10:31 Create a PivotTable report
- 10 10. 12:47 Grouping Dates & the PivotTable Cache
- 11 11. 14:20 Report Layout – and how to change DEFAULT
- 12 12. 15:44 Types of calculations in a PivotTable
- 13 13. 19:05 NEW Automatic PivotTable Number Formatting
- 14 14. 22:11 Conditional Formatting
- 15 15. 24:15 Add Data To Excel Table and Watch the Update.
- 16 16. 27:31 Excel Charts
- 17 17. 32:48 Slicers
- 18 18. 34:58 Summary
- 19 19. 35:28 Homework – Practice Problems for you!
- 20 20. 35:40 Closing
