Applied charts and dashboards - Session 2 - Key tools of the trade
Applied charts and dashboards - Key tools of the trade forms the 2nd part of a six course series that discusses the merits of relating key business narratives visually.
This session brings together some of the key features and functions in Excel necessary to create the underlying data, charts and other outputs.
The '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.
- A litany of functions: EDATE / EOMONTH, INDEX / MATCH and other similar functions, SUMIF vs. SUMPRODUCT, LOOKUP
- Why you should never use VLOOKUP and HLOOKUP
- Custom number formatting
- Conditional formatting
- Interactivity using OFFSET, TEXT and other useful tools
The '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.
You can register for the other sessions of the series by clicking on the relevant links:
Session 1 - A necessary introduction
Session 2 - Key tools of the trade
Session 3 - Turning data into information
Session 4 - Chart basics
Session 5 - Key charts
Session 6 - Interactive dashboards
Session 1 - A necessary introduction
Session 2 - Key tools of the trade
Session 3 - Turning data into information
Session 4 - Chart basics
Session 5 - Key charts
Session 6 - Interactive dashboards
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.
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.
EVENT DETAILS
Topic: Reporting
Sub-Topic: Business Reporting, Financial Reporting, Presentation
Format: Recorded Webinar
Proficiency Level: All
CPD: Upto 1.5 hours