Liam Bastick

Mr. Sumproduct from Down Under


Liam has over 30 years’ experience in financial model development/auditing, valuations, M&A, strategy, training and consultancy, having worked across many industries in many countries.

Liam has headed modelling teams around the world, currently running his own business SumProduct, specialising in data analysis, decision support, modelling, financial analysis and training.  He has also stood in as an Acting Chief Financial Officer for numerous clients over the years whilst they filled their vacancies.

He is a regular contributor to many accounting institutes around the world, writing regular articles accessible by up to five million accountants, students and affiliates worldwide, reproduced in numerous magazines and financial press. He is author of An Introduction to Financial Modelling, with no fewer than three more books to be published this year on Excel, financial modelling and Power Query.

He is recognized as a Most Valuable Professional (MVP) in Excel by Microsoft, one of approximately 100 appointed globally, specialising in financial modelling, Power Pivot, Power Query and Power BI.

Academic qualifications: PhD (Mathematics), MPhil, MSc, BA (Hons), FCA, FCMA, CGMA, ACA.



Financial Modelling in Power BI

How do you build three-way integrated financial statements into business intelligence suite?  Simple!  Use Power Query, Power Pivot and Power BI to consolidate historical, actual and forecast data which may be presented in Power BI dashboards with what-if? analysis capabilities. End users will see how Power Query cleans up the data, Power Pivot links the […]

Data Modelling & Formulas

Masterclass: Critical Skills for Strategic Forecasting & Reporting Success

This masterclass is intended to give analysts, managers and senior managers (would-be and otherwise) an overview of the key concepts, tools and skills to undertake timely and efficient strategic forecasting and reporting in the 21st century. Insight + Hindsight = Foresight How often have you looked back with the benefit of hindsight and wished you […]

Data Modelling & Formulas Data Visualization & Reporting