
New Ways of Solving Problems in Excel
Explore powerful new ways to solve real business problems in Excel, as Microsoft MVP Chandoo guides you through LET, LAMBDA, GROUPBY, Dynamic Arrays, and Python in this practical, case study-driven 2 half-day Masterclass.
Excel is evolving. So should you. Join Chandoo for this hands-on Masterclass on new, powerful and simpler ways to work with your data and get results. In this case-study based course, you will go through 5 business situations and understand how "new" way of thinking simplifies the workflow and gets you to result quicker.
What you'll learn?
By the end of the Masterclass, each learner will be able to:
- Working with new Excel functions and features
- Simplifying formulas with LET & LAMBDA
- Checkboxes in Excel
- Implementing Python for Excel Data Analysis
This Masterclass will be delivered by Microsoft MVP Chandoo on 14 & 15 Oct 2025 as an online-only course.
What's included
Who is it for
This Masterclass is ideal for Excel users who are ready to move beyond traditional formulas and embrace powerful new tools that simplify complex problems and speed up results.
- Intermediate to advanced Excel users who want to level up their skills with the latest functions and tools.
- Business analysts and data professionals, looking to simplify workflows and solve real-world problems faster.
- Finance teams who rely on Excel for reporting, modelling and decision-making.
- Anone courious about integrating modern Excel tools like LET, LAMBDA, GROUPBY, Dynamic Arrays, and Python to boost productivity and clarity in their workbooks.
Download Course Brochure
About trainer

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 people think of
Chandoo
Course contents
Chandoo
Training requirements
- Microsoft Excel 365
- Optional – VSCode with Python, Jupyter Installed
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
