Masterclasses Package

Masterclasses Package

Date icon
Date:
Schedule icon time
Time:
Location Icon
Location:
London, UK

3x specially tailored Masterclasses that provide a deep dive into the advanced world of Microsoft Excel. Unlock data visualisation, analytics and Power Query functionalities you never knew existed and take your skills to the next level.

Who should attend the Summit?
  • Data Analytics and Finance department teams
  • Teams who would like to stay up to date with the latest features in Excel and Power BI, including Python, Office Scripts, Copilot, and more.
  • Teams that desire to improve their Excel and Power BI skills in order to work with greater efficiency, productivity, and collaboration.
  • Teams seeking new ways to solve problems, whether it's crunching data in Power Query or building custom functions using the LAMBDA function.
  • Team managers aiming to inspire their colleagues with new ideas and fresh impetus, allowing them to feel reinvigorated when they head back to the office.
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 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
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
21+ hours of live event footage
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
21+ hours of live event footage
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
21+ hours of live event footage
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
21+ hours of live event footage
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
13 hours of Masterclass footage
Check Icon
3x Masterclass recordings, working files and supporting documentation
Check Icon
Lifetime access to Masterclass content
Check Icon
Certificate of completion
Check Icon
13 CPD (Continuing Professional Development) hours / points
Check Icon
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
Full session details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Day 1 (6 February 2024)


No Day 1 sessions included in this ticket type.

Right Arrow Icon
Day 2 (7 February 2024)


No Day 2 sessions included in this ticket type.

Right Arrow Icon
Day 3 (8 February 2024)

✔︎ ChatGPT in Excel: Match made in heaven or hell..?
✔︎ Corporate charts inspired by social media
✔︎ A bank's perspective on Excel and AI
✔︎ Combine data in Excel like a pro
✔︎ Dynamic dashboard creation for KPI reporting using Power BI
✔︎ Expert Battles by FMWC
✔︎ Panel discussion: Does being Excel certified matter?
✔︎ Panel discussion: The future of Excel in an AI world
✔︎ And more...

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
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

About the trainer

Profile Pic

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
3x Expert Masterclasses

Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.

✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query

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 insights complete the Tech & Innovation Track!

✔︎ Keynote by Microsoft: Transforming Excel through research and AI
✔︎ Keynote by Leila Gharani
✔︎ Actionable Data Storytelling in Excel with Zebra AI
✔︎ AI: Sorting fact from fiction
✔︎ Python in Excel: First Steps
✔︎ Teaching Excel with AI
✔︎ Is AI taking over the role of the data analyst?
✔︎ How to build re-usable Excel automations with AI
✔︎ Empowering learners to Excel with digital skills certifications
✔︎ Kids meet spreadsheets
✔︎ ChatGPT: Match Made in Heaven or Hell..?
✔ Turn Excel models into Web apps: features, sharing, monetization
✔ Panel discussion: The future of Excel in an AI world
✔ Panel discussion: Does being Excel-certified matter?

Right Arrow Icon
Finance & Accounting Track

Harness the power of Excel and Power BI for budgeting, forecasting, and modelling. You'll master dashboards, P&L statements, and learn to build bullet-proof models that won't disintegrate!

✔ Client's perspectives on quality — lessons from a career in financial modelling and what that means for the future
✔ Dynamic Arrays - A financial modelling game changer
✔Upgrading financial modelling — how, who, and why?
✔ Fivecasting: One Better than Forecasting
✔ A bank’s perspective on Excel and AI

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, intuitive analytic experiences, and write DAX expressions for true flexibility!

✔ Is this an Excel chart?!? - 5 ways to take your boring charts to the NEXT Level
✔ Interactive Data Visualisation for decision support using Excel
✔ How to create an intuitive analytic experience in Excel using Script Labs
✔ Dynamic dashboard creation for KPI reporting using Power BI

Right Arrow Icon
The Power Stack Track

Expand your understanding of Power Query, Power Pivot, Power BI, and Power Automate. You'll arm yourself with the latest time-saving functionalities, powerful visualisations & expert techniques.

✔ Why use Power Query to solve practical data cleaning problems?
✔ 5 Things every Excel user should know about Power BI
✔ Using Git in Power BI for effective teamwork and version control
✔ Overcoming real-world problems with Power BI
✔ Power Query on Excel for Mac

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!

✔ Optimising the Monetisation of Spreadsheets
✔ LAMBDA - There is no stopping you
✔The *NEVER SEEN* Tips & Tricks by Bob Umlas
✔ Converting spreadsheets into web apps; 3 apps in fifteen minutes
✔ 5 ways for analysts to leverage 'Analyze Data’ in Excel
✔Combine Data in Excel Like A Pro
✔ Why VLOOKUP when there is Power Query?

Masterclasses Package

*Quality of videos may vary between sessions due to stream compression.
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):
£ 295.00 GBP

£ 590.00 GBP

An icon that shows a camera or video.
Expert Footage: 13 hours
An icon that shows a camera or video.
Expert Footage: 34+ hours
An icon that shows a camera or video.
Expert Footage: 21+ hours
An icon that shows a lock.
Access to all speaker files
An icon that shows a star.
Watch any time, from anywhere
An image that shows CPD accreditation.
CPD accredited content
Calendar Icon 22 June
Schedule Icon - Time
Location Icon
Level icon
Level:
Money back guarantee
Money back guarantee
An icon that represents a date.
Date:
Time Icon
Time:
Location Icon
Location:
CoPilot image in Excel

Tech & Innovation

Discover how AI is shaping the Excel world and the ways you can take advantage of it. Plus, immerse yourself in thought-provoking panel discussions.

An icon that shows a checkmark.
ChatGPT and CoPilot
An icon that shows a checkmark.
Python in Excel
An icon that shows a checkmark.
Reusable automations with AI
An icon that shows a checkmark.
The future of Excel in an AI world
Zebra BI Image

Data Viz & Analytics

Unlock the secrets to showcasing data with style and substance as you unearth Microsoft Excel’s and Power BI’s rich visualisation possibilities.

An icon that shows a checkmark.
Next level Excel charting
An icon that shows a checkmark.
Actionable reporting made easy
An icon that shows a checkmark.
Dynamic dashboard creation for  KPI reporting
An icon that shows a checkmark.
Data visualisation for decision making
Openbox image

Finance & Accounting

Harness Excel’s power to budget, forecast, and model, as well as understand the process of building bullet-proof models that won’t fall apart.

An icon that shows a checkmark.
Build financial models in minutes
An icon that shows a checkmark.
Dynamic arrays - a game changer
An icon that shows a checkmark.
Financial modelling at PwC
An icon that shows a checkmark.
Fivecasting - better than forecasting
Gustaw Dudek dashboard

The Power Stack

Power up your Power Query, Power Pivot, and Power BI skills to become a data analysis and transformation virtuoso!

An icon that shows a checkmark.
Clean data with Power Query
An icon that shows a checkmark.
Key items to know about Power BI
An icon that shows a checkmark.
Dynamic dashboard creation for  KPIs reporting using Power BI
An icon that shows a checkmark.
Power Query on Excel for Mac
CoPilot image in Excel

Formulas & Automation

Get equipped with the Excel hacks, shortcuts, and tricks of the trade that enable you to slash hours out of monotonous tasks.

An icon that shows a checkmark.
Multiple methods to combine data
An icon that shows a checkmark.
LAMBDA -there is no stopping you
An icon that shows a checkmark.
The 'Analyze Data' tool in Excel
An icon that shows a checkmark.
VLOOKUP vs. Power Query
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
An image that shows the venue of Global Excel Summit 2024.

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