Advanced functions, Power Query for cleaning data, what-if scenarios and professional financial dashboards that save hours of manual work.
Course Curriculum
| 1. Advanced Functions | |||
| 1.1 Dynamic arrays: FILTER, SORT, UNIQUE Details | 00:09:00 | ||
| 1.2 LET and LAMBDA Details | 00:08:00 | ||
| 1.3 Financial functions: PMT, NPV, IRR, XNPV Details | 00:10:00 | ||
| 1.4 Date logic for periods and fiscal years Details | 00:07:00 | ||
| 1.5 Error handling and auditing formulas Details | 00:07:00 | ||
| 2. Power Query | |||
| 2.1 Importing data from systems and files Details | 00:08:00 | ||
| 2.2 Cleaning and transforming data Details | 00:09:00 | ||
| 2.3 Merging and appending tables Details | 00:08:00 | ||
| 2.4 Combining monthly files automatically Details | 00:08:00 | ||
| 3. Power Pivot and Data Model | |||
| 3.1 Relationships between tables Details | 00:08:00 | ||
| 3.2 Measures with basic DAX Details | 00:09:00 | ||
| 3.3 Multi-entity reporting Details | 00:07:00 | ||
| 4. Scenarios and Sensitivity | |||
| 4.1 Goal Seek and Data Tables Details | 00:08:00 | ||
| 4.2 Scenario Manager Details | 00:06:00 | ||
| 4.3 Sensitivity tables for decisions Details | 00:07:00 | ||
| 5. Financial Dashboards | |||
| 5.1 Dashboard design principles Details | 00:07:00 | ||
| 5.2 KPIs and charts that work Details | 00:08:00 | ||
| 5.3 Interactive controls and slicers Details | 00:07:00 | ||
| 5.4 Automating with simple macros Details | 00:08:00 | ||
| 5.5 Final project: monthly management dashboard Details | 00:15:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
STUDENTS ENROLLED
