How to Create AWESOME Excel Dashboards in the "NEW" Excel

How to Create AWESOME Excel Dashboards in the "NEW" Excel

Date icon
Date:
9 February 2024
Schedule icon time
Time:
10am-4pm
Location Icon
Location:
London, UK

Excel 365 offers many powerful & fun features to take your dashboards to the next level. We can now get images into cells, make self-updating charts and create powerful insights with DAX. Unlock its full potential and mesmerize your boss with this masterclass.

Join data visualisation expert Chandoo and master powerful Excel features that will take your dashboards to the next level.

Who should attend this course?

This course is for beginners to Power Query. If you know a little Power Query or if you’ve never used it, this masterclass is for you.

  • Customer Service Reps
  • Sales Assistants
  • Marketers
  • Data Analysts
  • Every day Excel users who regularly work with data that’s not immediately useful and clean
  • Business and Management Students
Who should attend this course?

If you create Data Models in Excel or Power BI, then this Masterclass is for you.

  • Data professionals
  • Business Intelligence or Analytics professionals
  • Every day Excel or Power BI users who want to learn how to build advanced DAX + Power BI skills
Who should attend this course?

If you create Data Models in Excel or Power BI, then this Masterclass is for you.

  • Data professionals
  • Business Intelligence or Analytics professionals
  • Every day Excel or Power BI users who want to learn how to build advanced DAX + Power BI skills
Who should attend this course?

This Masterclass is for people who already know and have worked with Power Query’s user interface (either in Excel or Power BI) and want to explore advanced problem solving using the M Language.

  • Business Intelligence or Data Analytics professionals
  • Every day Excel or Power BI users who want to learn an in-demand business skill and build advanced Power Query skills
  • Professionals willing to experience Power Query in new ways
Who should attend this course?

This is course is for intermediate and advanced Excel users.

  • Small business owners who want to better visualize their data
  • Business Intelligence professionals
  • Every day Excel users who want to learn how to build awesome dashboards in Excel, using the latest new features
  • Business and Management Students
Who should attend this course?

This Masterclass is designed for users who use Excel on a regular basis and are comfortable  with using its tools and functions. It is assumed that attendees will have  some financial background.

  • Financial modellers and analysts
  • Business professionals who are eager to improve their Excel and Financial Modeling skills
  • Finance & Accounting students
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
One-day in-person training with Microsoft MVP Chandoo
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours / points
Check Icon
Sample data & completed workbooks
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
What will you learn?


✔︎ What's new in Excel and how it can help with our dashboards
✔︎ The new data handling features for dashboarding - Power Query
✔︎ The new functions for dashboarding - Dynamic Arrays, Lambda Helpers and IMAGE
✔︎ The new charts for dashboarding - Box plots, treemaps, forecasts
✔︎ The new pivots for dashboarding - data model & DAX Putting them all together for a KPI dashboard
✔︎ Making the dashboard interactive with Slicers & Timelines
✔︎ Updating the dashboard when you get new data

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you will learn as part of this course:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Budgeting and forecasting as a planning and management tool

• Forecast modelling best practices.
• Management Reporting to promote accountability.
• Building dynamic variance analysis reports

Right Arrow Icon
A range of Budgeting techniques and skills

• Top-down, bottom-up and zero-based budgeting
• Limitations of budgets and critique of the budget process
• Budgeting “Soft” Skills

Right Arrow Icon
Scenarios

• Stress-testing
• Break-even scenario
• Sensitivity analysis

Right Arrow Icon
Build your own forecasting model

During the class, participants will build their own forecasting models to bring a practical application to the skills they have learned.
• Creating a “rolling” forecast with live data
•  Phasing and seasonality in forecast models
•  Budgeting for Capital Expenditure and Depreciation
• The model will include capex spend, cashflow and depreciation calculations as well as scenarios and sensitivity testing.

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you will learn as part of this course:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Short-cuts and techniques to build a financial model in less time

Become super-efficient in Excel through intensive use of keyboard shortcuts and best practices to efficiently build an effective and robust model.

Right Arrow Icon
Experience designing solutions to real-world examples

Create a financial model based on real-world financial modelling challenges. Incorporate current economic uncertainties into the model in order to take more calculated risks and make more informed business decisions.

Right Arrow Icon
Analytical thought on fluctuating economic assumptions in financial modelling

Identify correct economic inputs to model and deal with fluctuations. Quantify uncertainty in forecasting models with stress-testing, what-if analysis and risk analysis techniques.

Right Arrow Icon
Knowledge on how to deal with uncertainty and risk in financial modelling

Explore the several different ways to perform scenario and sensitivity analysis in Excel and learn to model in detail the complex but most commonly used methods of showing scenarios using a combination of formulas and drop-down boxes.

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Day 1 - Financial Modelling in Excel

Click on the link below for full details of our "Financial Modelling in Excel" course:

https://globalexcelsummit.com/
product/financial-modelling-in-excel

Right Arrow Icon
Day 2 - Budget and Forecast Modelling in Excel

Click on the link below for full details of our "Budget and Forecast Modelling in Excel" course:

globalexcelsummit.com/product/
budget-and-forecast-modelling-in-excel

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Day 1 - Financial Modelling in Excel

Click on the link below for full details of our "Financial Modelling in Excel" course:

https://globalexcelsummit.com/
product/financial-modelling-in-excel

Right Arrow Icon
Day 2 - Budget and Forecast Modelling in Excel

Click on the link below for full details of our "Budget and Forecast Modelling in Excel" course:

globalexcelsummit.com/product/
budget-and-forecast-modelling-in-excel

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Test title

Click on the link below for full details of our "Financial Modelling in Excel" course:

https://globalexcelsummit.com/
product/financial-modelling-in-excel

Right Arrow Icon
Day 2 - Budget and Forecast Modelling in Excel

Click on the link below for full details of our "Budget and Forecast Modelling in Excel" course:

globalexcelsummit.com/product/
budget-and-forecast-modelling-in-excel

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Day 1 - Financial Modelling in Excel

Click on the link below for full details of our "Financial Modelling in Excel" course:

https://globalexcelsummit.com/
product/financial-modelling-in-excel

Right Arrow Icon
Day 2 - Budget and Forecast Modelling in Excel

Click on the link below for full details of our "Budget and Forecast Modelling in Excel" course:

globalexcelsummit.com/product/
budget-and-forecast-modelling-in-excel

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Day 1 - Financial Modelling in Excel

Click on the link below for full details of our "Financial Modelling in Excel" course:

https://globalexcelsummit.com/
product/financial-modelling-in-excel

Right Arrow Icon
Day 2 - Budget and Forecast Modelling in Excel

Click on the link below for full details of our "Budget and Forecast Modelling in Excel" course:

globalexcelsummit.com/product/
budget-and-forecast-modelling-in-excel

Right Arrow Icon
6x expert-led Masterclasses
Full course details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Dynamic Arrays as a Modelling Tool

✔︎ The most useful array functions for modelling
✔︎ Selecting the right function (arrays vs. traditional formulas)
✔︎ Nesting functions with arrays

Right Arrow Icon
Financial Modelling Best Practice and Design

✔︎ Principles of financial modelling best practice with dynamic arrays
✔︎ Designing a layout to incorporate spill ranges
✔︎ Dangers of working with array functions

Right Arrow Icon
Financial Statements Modelling

✔︎ Building a simple financial model with array functions
✔︎ Dynamic debt and depreciation schedules
✔︎ Dealing with inconsistent formulas with LAMBDAs

Right Arrow Icon
Advanced Modelling Tools and Techniques

✔︎ Switching between dynamic scenarios
✔︎ Applying sensitivities with data tables
✔︎ Avoiding circularity in interest calculations

Right Arrow Icon
6x expert-led Masterclasses

Training requirements

Suggested Skill Level: Intermediate or above Excel Skills. Not for beginners.

About the trainer

Profile Pic

Chandoo

Chandoo runs one of the most popular and extensive online resources for data analysis and dashboard reporting through Excel & Power BI at Chandoo.org. His mission is to make people awesome in their work.

Chandoo has trained more than 10,000 professionals on Excel, Power Pivot, VBA & Power BI through online & in-person classes.

What they say about us

5 stars rating

 - 

5 stars rating

 - 

Full session details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Excel Essentials

Get to grips with Excel’s advanced features in a series of beginner-friendly sessions. You’ll grasp the basics of VBA, PivotTables, and Power BI to automate tasks and build dashboards.

Introduction to VBA

Introduction to Power Pivot

The most important functions an Excel analyst should master

Introduction to Power BI

Excel for the Mac: A guide for Windows switchers

Right Arrow Icon
Tech & Innovation Track

Check out the introductory keynotes from Microsoft and world-renowned MVP Leila Gharani. Software developers showcase add-ins that transcend Excel's limitations, plus robust panel discussions and expert battles complete the day!

Opening keynote by Microsoft

Opening keynote by Leila Gharani

Top 5 tips & tricks for actionable reporting in Excel

How to use Excel as a no-code app builder

Excel beyond expectation: glimpse the future of Excel

Panel discussion: Excel in education

Going Rogue in Excel: doing what you gotta do to get
what you gotta get

Right Arrow Icon
Finance & Accounting Track
Right Arrow Icon
Data Visualisation & Analytics Track

Showcase your data with insightful visuals and learn the secrets of presenting it for effective communication. You'll also create custom charts, 3D animated wireframes, and write DAX expressions for true flexibility!

Advanced sales analytics using Data Analysis Expressions (DAX) in Microsoft Excel.

Improve your dashboards with custom charts

The power of colour in data visualisation

How to build a 3D wireframe animation in MS Excel?

Panel discussion: The future of data visualisation

Why we should treat Excel more like PowerPoint?

Right Arrow Icon
The Power Stack Track
Right Arrow Icon
Formulas & Automation Track

Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!

Panel discussion: Is VBA dead or alive?

The end of PivotTables in Excel

The magic of names in Excel

Copy/paste chart settings with VBA

Power up with 10 NEW Excel functions

Dynamic arrays, a LIFE changer

Excel automation: Which tool to use?

The *NEVER SEEN* Tips & Tricks

Right Arrow Icon
6x expert-led Masterclasses

How to Create AWESOME Excel Dashboards in the "NEW" Excel

Please submit proof of student status  before proceeding to checkout.
Max file size 10MB.
Uploading...
fileuploaded.jpg
Upload failed. Max size for files is 10 MB.
Thank you! Your file has been attached successfully.
Oops! Something went wrong while attaching your file. Please try again.

If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
Total (incl. VAT):
£ 275.00 GBP

£ 395.00 GBP

Expert Footage: 34 hours
Access to all speaker files
Watch any time, from anywhere
CPD accredited content
Calendar Icon 22 June
9 February 2024
Schedule Icon - Time
10am-4pm
Location Icon
Central London, UK
Level icon
Level:
Money back guarantee
Money back guarantee
Date:
9 February 2024
Time Icon
Time:
10am-4pm
Location Icon
Location:
Central London, UK
Learn from a Microsoft MVP
laptop with conference mockup

Is the Global Excel Summit content right for me?

The Global Excel Summit event and course content is for YOU if...

  • You’re ready to nerd out on all things spreadsheets
  • You’re ready to become the most productive, efficient and confident Microsoft Excel user in your team
  • You want to learn the ins and outs of what’s been introduced in Excel over the past 1 year
  • You want to become unstoppable in Excel
  • You want to navigate Excel with crazy speed. Jumping one tab to another, pressing buttons, creating charts, printing PDFs

Is the Global Excel Summit content right for me?

The Global Excel Summit event and course content is for YOU if...

  • You’re ready to nerd out on all things spreadsheets
  • You’re ready to become the most productive, efficient and confident Microsoft Excel user in your team
  • You want to learn the ins and outs of what’s been introduced in Excel over the past 1 year
  • You want to become unstoppable in Excel
  • You want to navigate Excel with crazy speed. Jumping one tab to another, pressing buttons, creating charts, printing PDFs