- Course Introduction
- Quick Reference Guide
- Excel Sample Files
- Autofill
- Autofilter
- Data Validation
- Transpose
- Vlookup
- CHECKPOINT
- If Statements
- Pivot Tables
- Conditional Formatting
- Charts
- Data Cleaning
- Macros
- Adding Value
Don't waste your time on long, boring course that you may never finish. Learn essential Microsoft Excel skills in 1 hour that will help you to:
Save time
Boost earning potential
Impress your boss
This course will help those with a basic understanding of Excel to turbocharge their skills (and become the office superhero). It covers critical features which provide the most immediate value. Each is clearly explained in video tutorials, which you can follow along with using the sample file. A quick reference guide is also included that can be taken to the office so you will know what feature to use and when to use them.
This course will work with Excel 2010, 2013, 2016, and 2019.
I am a professor, data analyst, and IT manager that has led global IT programs across 3 continents and 6 countries for a Fortune 100 company. I am passionate about data and teaching, but combining these two disciplines is even better.