Are you stuck running soul-destroying, manual month end processes in Excel?
If the answer to that question is "Yes!" then this bootcamp is for you.
I'll introduce you to Power Query, an Excel feature that will change your world.
Then I'll introduce you to Dynamic Arrays, and show you how they can add value to real-world month end challenges.
And finally, I'll talk you through the latest developments in AI, including Claude's Excel add-in, and Microsoft's new Agent.
This is a hands-on course, with plenty of practical experience offered throughout. Your class mates and I will be there every step of the way to support you.
You didn't train all those years as a finance professional to just copy & paste numbers all day. Let me give you your time back, so you can do the real value-adding work you are capable of.
* Please note, you must have an Office 365 subscription or Excel 2021, and be working on a Windows computer (not a Mac) to get the best experience from this bootcamp.
** This bootcamp includes one month of full access to the Full Stack Modeller training platform and community, giving students the opportunity to take advantage of ALL of our additional training content.
What you’ll learn
Create Excel-based automation processes using Power Query and Dynamic Arrays to revolutionise your month end.
If you perform any manual data processes, Power Query will transform your working life
Dynamic Arrays bring incredible new powers and flexibility to your Excel grid modelling
Link your data from Power Query to the grid of Excel with Dynamic Arrays. This is where the magic really happens
We'll discuss the latest developments in LLMs, Agents, and more to help you boost your productivity even further
Learn directly from Giles
Giles Male
Co-Founder of Full Stack Modeller. CIMA Qualified Financial Modeller.
Who this course is for
Finance professionals involved in the month end process
Excel users who manage data on a regular basis
Anyone with an interest in Excel-based automation
What's included
Live sessions
Learn directly from Giles Male in a real-time, interactive format.
Lifetime access
Go back to course content and recordings whenever you need to.
Community of peers
Stay accountable and share insights with like-minded professionals.
Certificate of completion
Share your new skills with your employer or on LinkedIn.
Maven Guarantee
This course is backed by the Maven Guarantee. Students are eligible for a full refund up until the halfway point of the course.
Course syllabus
Week 1
Apr
7
Session 1: The Fundamentals of Power Query
Apr
8
Session 2: The Fundamentals of Dynamic Arrays
Week 2
Apr
14
Session 3: Practical Case Studies
Apr
15
Session 4: Final Tips & Tricks and a look at AI tools
Schedule
Live sessions
4 hrs / week
Tue, Apr 7
4:00 PM—6:00 PM (UTC)
Wed, Apr 8
4:00 PM—6:00 PM (UTC)
Tue, Apr 14
4:00 PM—6:00 PM (UTC)
Wed, Apr 15
4:00 PM—6:00 PM (UTC)
Projects
2 hrs / week
Frequently asked questions
$395
USD