Excel 2019 - Intro to Data Analysis Tutorial

Excel 2019 - Intro to Data Analysis Tutorial

Learnit Training via YouTube Direct link

Start

1 of 29

1 of 29

Start

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.