
Publication number: ELQ-83150-1
View all versions & Certificate

Expense insights and analysis for SME businesses using Excel and Power BI
Overview of the building blocks of a financial model for expense insights and forecasting using dynamic arrays and other hidden gems inside Excel and Power BI.
Further information
Understand how to structure a best practice financial model for expense insights and modelling
Leverage Power BI to take the experience to a new level
Show how you can apply Power Query to automate the expense analysis
For those needing to understand, analyse and forecast expense by various dimensions including suppliers, staff, chart of account etc.
Balance sheet management or elements relating to the full integrated financial modelling with balance sheet and cash flow