If you can build a basic spreadsheet but your reports still take hours and you are doing a lot of work manually, this course is the answer. The skills taught here are what accountants, analysts, and operations teams use to produce complex reports in minutes.
PivotTables are the most powerful analysis tool in Excel and most users either do not know how to use them or use them at 20 percent of their capability. We spend four full lessons on PivotTables alone.
Power Query is the modern way to import, clean, and transform data without writing formulas. It automates the process of pulling data from external sources and preparing it for analysis. Once you know it, you will not want to work without it.
The macro section covers recording and editing simple macros to automate repetitive tasks. You do not need to know how to program. By the end of the section you will be able to write a macro that automates your monthly reporting process.
Course curriculum
What is included
Delivery: Immediate access after purchase.
Student feedback
"Monthly reporting that took me 4 hours now takes 35 minutes. Power Query alone made this course worth 10 times the price."