Completed
Creating Pivot Tables from Scratch
Class Central Classrooms beta
YouTube videos 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 Preparing Data for Tables
- 3 Removing Blank Rows and Duplicates
- 4 Using Flash Fill to Apply Table Styles
- 5 Applying Table Styles
- 6 Auto Sorting and Filtering in Tables
- 7 Applying a Custom AutoFilter in Excel Tables
- 8 Adjusting Table Style Formats and Options
- 9 Applying Total Rows
- 10 Adding New Data and Turning Off Table Styles
- 11 Applying Conditional Formats
- 12 Editing and Turning Off Conditional Formats
- 13 IF Functions
- 14 SUMIF Functions
- 15 COUNTIF Functions
- 16 AVERAGEIF Functions
- 17 Creating Charts
- 18 Editing and Reformatting Charts
- 19 Creating Sparklines
- 20 Creating Win-Loss Sparklines
- 21 Creating Pivot Tables Using the Recommended Pivot Tables Button
- 22 Creating Pivot Tables from Scratch
- 23 Editing Summary Function and Format of Pivot Table Value Fields
- 24 Filtering, Sorting, and Editing Pivot Table Fields
- 25 Grouping Column Labels in Pivot Tables
- 26 Creating Slicers
- 27 Refreshing Pivot Table Data
- 28 Creating and Updating Pivot Charts
- 29 Conclusion
