Completed
) Boss Ask you to add All Sales for Each Employee!?!? Easy with a PivotTable! See how to create a Sales Report with a PivotTable, including how to Format and Pivot the PivotTable.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More
Automatically move to the next video in the Classroom when playback concludes
- 1 ) What is Excel?
- 2 ) What does Excel do? 1) Calculations, 2) Storing & Formatting Data, 3) Data Analysis
- 3 ) Formatting to make our Data Look Good. Build a Template that you can use over and over.
- 4 ) See how to create a List of Days of the Week Quickly using the "Angry Rabbit".
- 5 ) Formulas & Cell References to make our Job Easier! Learn about the Excel Functions: SUM, AVERAGE, MAX and MIN.
- 6 ) Keyboard Shortcuts are Amazing. Learn how to highlight 5000 rows of data quickly.
- 7 ) Payroll Tax Calculations Hard? Not With Excel : )
- 8 ) Relative Cell References in Formulas
- 9 ) Absolute Cell References in Formulas
- 10 ) Excel Table Feature makes everything Dynamic!!! Learn about how to Sort, Filter and create Dynamic Ranges (Update Automatically) using the Excel Table Features.
- 11 ) Chart Your Results Dynamically!! Learn how to create a Column Chart for visualizing the difference across Categories.
- 12 ) Boss Ask you to add All Sales for Each Employee!?!? Easy with a PivotTable! See how to create a Sales Report with a PivotTable, including how to Format and Pivot the PivotTable.
- 13 ) Flash Fill to "Clean Your Data" in Seconds!
- 14 ) Summary of all topics.
