This intensive course teaches participants to transform, model, and analyse complex datasets using Excel’s most powerful features: Power Query, Power Pivot, DAX, Dynamic Array formulas, and advanced visualisation techniques. By the conclusion, you will be able to perform robust data consolidation, complex scenario planning, and create professional, flexible reports and dashboards that drive strategic business decisions.
Departments are often under-resourced with Risk/Internal Audit teams being smaller but having a huge responsibility across changing and emerging risks. This session introduces key risk management topics and aligns the teaching with specific risk thoughts within your Department. The session is designed to complement the current risk management practices of the state government and promotes the current risk management team.