Modelling with Dynamic Arrays

Real Time Online Delivery – Live Training Sessions
Virtual Attendance for 5 Days Training
Guided Learning Hours – 20 (4 Hrs x 5 Days)
Comprehensive Learning Kit, Case Studies
Pre-Course Preparation: Assignment, Assessment

Course Overview

This 5 Day online course will help you understand how to “tame” your data and make it work for you! Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs. Covering dashboard reporting, balanced scorecards, visual design of charts and tables, we will also discuss the new charting and analysis features of Excel 365 and Power BI. Understanding how Modern Excel tools can help analyse data and create dashboards to communicate your message is a critical skill for Excel users today.

Trainer’s Profile

Our Expert Trainer Danielle Stein Fairhurst with over 20 years’ experience as a financial analyst, she helps her clients create meaningful financial models in the form of business cases, pricing models and management reports. She has hands-on experience in several industry sectors, including telecoms, information systems, manufacturing & financial services.

Has regular engagements around Australia and globally as a speaker, course facilitator, financial modelling consultant and analyst. In 2021 she was awarded the prestigious Microsoft Most Valuable Professional (MVP) award and regularly commentates “Excel as Esports” battles for the Financial Modeling World Cup (FMWC) on ESPN3. She is on the judging panel for the 2021 Financial Modelling Innovation Awards and is on the Diversity Council for the ModelOff Financial Modeling World Championships

Key Takeaways

Learn to synthesise and summarise information into a logical framework.
Know how to use visual effects to improve their reports and presentations
Understand the principles of good dashboard design and presenting data graphically
Evaluate the new Modern Excel tools available for data analysis and dashboards
Upgrade the tools to analyse data & build reports using your existing Excel tools and skills

Who Should Attend

Financial Modellers and Analysts
Business professionals who are eager to improve their Excel and Financial Modeling skills
Intensive users of excel, especially those responsible for reporting and analysis.
Finance & Accounting Manager
Business Analyst
Business Intelligence Consultants
Project Managers and Risk Analysts
Financial Consultants

For participation details contact

Mithun Siddartha

mithun.siddartha@biiworld.com

+1 780 851 7197 (Canada)