Power Query

Introduction to Power Query, Data transformation, Merging and appending queries

Macro (VBA Basics)

Introduction to VBA, Recording macros, Editing and debugging macros, VBA programming basics

Solver

Introduction to Solver, Optimization problems, Constraints and scenarios

Dashboard Modelling

Dashboard design principles, Interactive dashboards, Slicers and timelines

Data Modelling

Data relationships, Power Pivot, DAX basics

Pivot Table and Pivot Charts

Creating pivot tables, Advanced pivot table features, Pivot charts

Scenario Manager

Creating scenarios, Scenario summary reports

Lookup and Reference Functions

VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, OFFSET, INDIRECT

Date Functions

DATE, EDATE, EOMONTH, NETWORKDAYS, DATEDIF

Logical Functions

IF, AND, OR, NOT, Nested IF, IFS, SWITCH

MIS Reporting

MIS report design, Automated reports

Financial Modelling Basics

Financial statements, Forecasting, Valuation basics

Charts and Visualisation

Chart types, Advanced charting, Data visualization best practices