Ultimate Bundle

Ultimate Bundle

Date icon
Date:
Schedule icon time
Time:
Schedule icon time
Location:

What to expect?

Our complete 2024 event package includes access to all 34+ hours of recorded content from the live event. From Main Stage speaker sessions to all 3x online Masterclasses that will transform your Microsoft Excel skillset.

Who is this for?

This Masterclass is for professionals concerned about dedicating excessive time to routine, error-prone tasks and would prefer to use AI to automate these processes, rather than facing the risk of AI rendering their roles obsolete.

Additionally, professionals uncertain about how the rise of AI affects their career paths — whether it necessitates evolving into more technical roles or stepping back from the technical aspects of their jobs, considering AI integration as a potentially insurmountable challenge.

This could be those in:

  • Accountants
  • Finance professionals
  • Operations teams
  • Everyone who uses Excel for data preparation and analysis on a daily basis.
Who is this for?

This Masterclass is for any finance professionals who want to stop working late at month end by automating their work. The typical roles/teams that could benefit from this masterclass are:

  • Management Accountants
  • Commercial Accountants
  • Financial Planning & Analysis
  • Financial Control
  • Financial Reporting
Who is this for?

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

  • Business Intelligence or Analytics professionals
  • Every day Power BI users
  • Users of other tools looking for advanced techniques and/or inspiration
  • Managers aiming to improve their current reporting systems
Who is this for?

This Mastercass is for anyone who wants to make the most of their data using next-generation features. Typical job titles who could particularly benefit include:

  • Data analysts
  • Financial analysts
  • Marketing coordinators
  • Accountants
  • Controllers
  • Operations analysts
Who is this for?

This Masterclass is for anyone using Excel 365 who wants to learn more about Office Scrips and Power Automate. By the end of this class, you will be able to build self-running automation processes that run in the background of Excel.

Who should attend this course?

This Masterclass is for people who already know and have worked with Microsoft Excel’s user interface and want to explore more advanced and dashboard functionalities:

  • Professionals willing to build visually appealing and interactive dashboards in Excel
  • Every day Excel users who want to learn how to optimise their reporting and data analysis processes
  • Excel users who want to learn the power of Pivot Tables, Pivot Charts and Slicers to produce a well designed dynamic dashboard
Who should attend this course?

This Masterclass is for people who want to automate boring, repetitive, and time-consuming tasks in Excel.

Whether you’re a beginner stepping into the world of data transformation or a user with basic Power Query knowledge trying to refine your skills, this session has something valuable for you. The typical roles/teams that could benefit from this masterclass are:

  • Accountants
  • Financial Analysts
  • Data Analysts
  • Business professionals, seeking to streamline data transformation processes in Excel.
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
3x Masterclass recordings, working files and supporting documentation
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
3x Masterclass recordings, working files and supporting documentation
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
3x Masterclass recordings, working files and supporting documentation
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
3x Masterclass recordings, working files and supporting documentation
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
What’s included?
Check Icon
34+ hours of event footage
Check Icon
30+ Main Stage sessions
Check Icon
Speaker presentation & working files
Check Icon
Lifetime access to event content
Check Icon
Certificate of completion
Check Icon
34 CPD (Continuing Professional Development) hours / points
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 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
Course content
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Lesson 1 - Getting Started with Power Query

✔︎ What is Power Query?
✔︎ Basic data loading
✔︎ Power Query editor overview
✔︎ Type of values


Right Arrow Icon
Lesson 2 - Data Transformation Fundamentals

✔︎ Exploring queries and steps
✔︎ Basic data cleaning and transformation (removing columns & rows, filtering data, sorting, etc.)
✔︎ Practical example


Right Arrow Icon
Lesson 3 - Transforming Data in Real Life

✔︎ Removing duplicates and handling nulls
✔︎ Text transformation
✔︎ Date and time values
✔︎ Query load
✔︎ Practical example


Right Arrow Icon
Lesson 4 - Beyond Basic Data Transformation

✔︎ Data aggregation
✔︎ Merging and appending queries basics
✔︎ Different options for adding columns
✔︎ Pivoting and unpivoting data
✔︎ Practical example


Right Arrow Icon
Summary and Q&A

✔︎ Key takeaways
✔︎ Addressing frequently asked questions
✔︎ Interactive Q&A session


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
What you'll learn?
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Data profiling with Power Query

✔︎ What is “extract, transform, load,”?
✔︎ We’ll look at how this process works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data.

Right Arrow Icon
Efficient reporting with Power Pivot

✔︎ How do you avoid memory-draining “Frankentables” and build relational data models and reports right from Excel?
✔︎ We’ll look at Power Pivot and DAX for data analysis in Excel

Right Arrow Icon
Efficient analysing with dynamic array functions

✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.

Right Arrow Icon
Augmented analytics and the future of Excel

✔︎ Where is data analytics headed, and can Excel keep up?
✔︎ Learn how to use predictive analytics and artificial intelligence inside and outside of Excel to make the most of your data

Right Arrow Icon
Interfacing with Python

✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn how to automate boring processes with Python
✔︎ Learn how to build compelling analyses with this programming language

Right Arrow Icon
6x expert-led Masterclasses
Full ticket 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
✔︎ Corporate charts inspired by social media
✔︎ 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?

Right Arrow Icon
3x Masterclasses

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!

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

Training requirements

About the trainer

Profile Pic

What people think of

★★★★★

★★★★★

Get Ticket

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):
SAVE 30% - Early bird
£ 197.50 GBP

£ 395.00 GBP

✔︎ Free cancellation before 1 September 2024
✔︎ Recording and downloadable files included
✔︎ Free cancellation before 3 January 2025
✔︎ 30% Early Bird discount applied
✔︎ Switch to a different class if you change your mind
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:
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