About this courseMicrosoft 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
This course includes:
schedule4.5 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Apr 11, 2020
workspace_premiumCertificate of completion
calendar_todayUpdated At Jan 21, 2025