Completed
Start
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Excel 2019 - Intro to Data Analysis Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Preparing Data for Tables
- 4 Removing Blank Rows and Duplicates
- 5 Using Flash Fill to Apply Table Styles
- 6 Applying Table Styles
- 7 Auto Sorting and Filtering in Tables
- 8 Applying a Custom AutoFilter in Excel Tables
- 9 Adjusting Table Style Formats and Options
- 10 Applying Total Rows
- 11 Adding New Data and Turning Off Table Styles
- 12 Applying Conditional Formats
- 13 Editing and Turning Off Conditional Formats
- 14 IF Functions
- 15 SUMIF Functions
- 16 COUNTIF Functions
- 17 AVERAGEIF Functions
- 18 Creating Charts
- 19 Editing and Reformatting Charts
- 20 Creating Sparklines
- 21 Creating Win-Loss Sparklines
- 22 Creating Pivot Tables Using the Recommended Pivot Tables Button
- 23 Creating Pivot Tables from Scratch
- 24 Editing Summary Function and Format of Pivot Table Value Fields
- 25 Filtering, Sorting, and Editing Pivot Table Fields
- 26 Grouping Column Labels in Pivot Tables
- 27 Creating Slicers
- 28 Refreshing Pivot Table Data
- 29 Creating and Updating Pivot Charts
- 30 Conclusion
