MS 365 Excel Basics: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips - Part 8

Overview

Coursera Plus Monthly Sale: All Certificates & Courses 40% Off!

Grab it

This 36-minute tutorial from ExcelIsFun provides a comprehensive introduction to data analysis in Microsoft 365 Excel, covering essential features like PivotTables, Slicers, Charts, and Conditional Formatting. Learn the fundamentals of data analysis, including definitions of data and information, raw data concepts, and table structures. Master the Excel Table feature, create and customize PivotTable reports with various calculations and formatting options, implement conditional formatting for visual data analysis, and discover how Excel Tables automatically update when new data is added. Explore Excel Charts for data visualization and use Slicers for interactive filtering. The tutorial includes downloadable practice files, PDF notes, and homework exercises to reinforce learning. Available with subtitles in multiple languages including Afrikaans, Arabic, Bangla, Dutch, Filipino, Hindi, Indonesian, Khmer, Malay, Spanish, Swahili, Tamil, Thai, Urdu, and Vietnamese.

Syllabus

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