• Home
  • Applied charts and dashboards - Session 6 - Interactive dashboards

Applied charts and dashboards - Session 6 - Interactive dashboards

Save 20% off this product as part of our EOFY CPD Sale. Spend $600 or over to receive 30% off, or spend $1,000 or over to receive 40% off. Discount applies automatically at checkout. Sale ends 11.59pm AEST 1 July 2024. T&Cs apply.

Applied charts and dashboards - Interactive dashboards forms the last part of a six course series that discussed the merits of relating key business narratives visually.

This final session draws on topics throughout the rest of the series, highlighting interactivity and impact.

  • Differences between a report, a chart, a summary and a dashboard revisited
  • Positioning and other layout considerations
  • Interactivity tricks:
    • Slicers
    • Data validation
    • Drop down boxes
    • Text boxes
    • Dynamic ranges using OFFSET
    • Dynamic arrays
    • Chart Title commentaries and the TEXT function
  • Brief consideration of Power BI

This 'Applied charts and dashboards' series will help fine tune your interactive charting / dashboarding skills and hone your reporting techniques and hone your reporting techniques. Understand the importance of colour, dashboard positioning, formats, styles and know which visual to use when, how and why. A mix of supporting theory, combined with many hands-on illustrative examples, used to work through concurrently or afterwards.

You can find more information about the other five sessions in the 'Agenda' tab.
Liam Bastick

Liam has over 30 years’ experience in financial model development / auditing, valuations, M&A, strategy, training and consultancy. He has considerable experience in many different sectors (e.g. banking, energy, finance, media, mining, oil and gas, private equity, real estate advisory services, transport and utilities). 

He is a regular contributor to the Chartered Accountants Australia and New Zealand (CAANZ), Certified Practising Accountants Australia (CPAA), the Chartered Institute of Management Accountants (CIMA), the Institute of Chartered Accountants in England and Wales (ICAEW), the American Institute of Certified Public Accountants (AICPA), Finance 3.0 and various LinkedIn specialist discussion groups. He is a regular contributor to FM Magazine, Insight, InTheBlack and CFO Innovation magazines, and presents regular webinars for CAANZ, CPA and ICAEW. He has also been a guest writer for several valuations and actuarial faculties worldwide, specialising in probability and simulations analysis.

He is recognised as a Most Valuable Professional (MVP) in Excel by Microsoft, one of only c.70 appointed globally and one of only several specialising in financial modelling. He has authored several books recently: An Introduction to Financial Modelling, Excel Insights, Power BI Insights and the upcoming Continuing Financial Modelling.


Topic: Reporting

Sub-Topic: Business Reporting, Financial Reporting, Presentation

Format: Recorded Webinar

Proficiency Level: All

CPD: Upto 1.5 hours