Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
CPA Ontario
CPA Prince Edward Island
CPA Saskatchewan
CPA Newfoundland & Labrador
CPA Quebec Order
Microsoft Excel has become the main program to handle large amounts of data, charts, financial models, math formulas, reports, and just about everything else pertaining to business.
But using it can still be a mystery.
This video will show you everything you need to know about using Excel and getting more productive and efficient with it.
The topics include:
- Sorts
- Filters
- Advanced Filters
- Formatted Tables
- The Total Row in Formatted Tables
- Using Slicers in Formatted Tables
- The Sumif, Countif, and Averageif Formulas
- The Vlookup Formulas
- Subtotals
- Charts
- Pivot Tables
- Dashboards in Pivot Tables
- Power Pivot and PowerQuery
- Automating tasks with Macros