Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.xlsx
Pdf notes (free book): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.pdf
Link to full Excel Basics Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=9
Link to full Data Analysis Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0kCv2ulsHk4uitL9meshr_k&index=1
In this video get an introduction to data analysis, data, information, and the Excel features: Excel Tables, PivotTables, Slicers, Excel Charts and Conditional Formatting.
Video has subtitles in these languages: Afrikaans, Arabic, Bangla, Bangla (India), Dutch, Filipino, Hindi, Indonesian, Khmer, Malay, Swahili, Thai, Urdu, Vietnamese
Topics:
1. (00:00) Introduction
2. (00:29) Topics in Video
3. (01:13) Define Data Analysis, data and information
4. (03:38) What is Raw Data?
5. (04:13) What is a table?
6. (06:12) List of Excel Data Analysis Tools
7. (06:57) Excel Table feature
8. (09:07) What is a PivotTable and what does it do?
9. (10:31) Create a PivotTable report
10. (12:47) Grouping Dates & the PivotTable Cache
11. (14:20) Report Layout – and how to change DEFAULT
12. (15:44) Types of calculations in a PivotTable
13. (19:05) NEW Automatic PivotTable Number Formatting
14. (22:11) Conditional Formatting
15. (24:15) Add Data To Excel Table and Watch the Update.
16. (27:31) Excel Charts
17. (32:48) Slicers
18. (34:58) Summary
19. (35:28) Homework – Practice Problems for you!
20. (35:40) Closing
Video has subtitles in these languages: Afrikaans, Arabic, Bangla, Bangla (India), Dutch, Filipino, Hindi, Indonesian, Khmer, Malay, Swahili, Thai, Urdu, Vietnamese
#dataanalysis #pivottable #reporting #excelchart #slicer #slicers #conditionalformatting #visual #visualization #excel #excel365 #office365 #office365training