Completed
) Excel Table Feature makes everything Dynamic!!! Learn about how to Sort, Filter and create Dynamic Ranges (Update Automatically) using the Excel Table Features.
Class Central Classrooms beta
YouTube playlists 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.
