MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips! скачать в хорошем качестве

MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!

Download Excel File: https://excelisfun.net/files/ExcelBas... Link to full Excel Basics Class:    • Excel 365 Basics Free Course: Learn to Eff...   Pdf notes (free book): https://people.highline.edu/mgirvin/A... Link to full Basics Data Analysis Class:    • Excel & Power BI Basics Data Analysis Free...   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, Spanish, Swahili, Tamil, 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