Month End Excel Automation Bootcamp

Revolutionise Your Month End with Automation

Do you feel stuck performing soul-destroying, manual month-end tasks in Excel?

If so, this bootcamp is for you. Over six live sessions, Giles Male, Co-Founder of Full Stack Modeller, will guide you through the fundamentals of Power Query and Dynamic Arrays, showing you how to build automation processes that tackle real-world month-end challenges.

You’ll learn through interactive live sessions, practical projects, and direct feedback – all while working alongside a community of peers.

This is more than just learning formulas; it’s about empowering you to become an Excel developer who adds real value.

“You didn’t train for years as a finance professional to spend your time copying and pasting. Let me help you get your time back so you can focus on the work that truly matters.”

— Giles Male

The Fundamentals of Power Query

• Import and clean data from multiple sources.
• Transform data into usable formats.
• Build efficient, auditable queries with best-practice principles.

The Fundamentals of Dynamic Arrays

• Master key functions, from basics to advanced.
• Solve real-world challenges with Dynamic Arrays.
• Avoid common mistakes and pitfalls.

Real-World Applications

• Automate trial balance reporting across multiple files.
• Build accruals models with automated calculations and journal outputs.
• Create month-end variance reports seamlessly.

The Developer Mindset

• Transition from being an Excel user to an Excel developer.
• Scope and manage automation projects effectively.
• Leverage tips to maximise efficiency in your workflows.

• Six Interactive Live Sessions
– Fully recorded for lifetime access.
• Practical Projects
– Apply your learning to real-world scenarios.
• Community Support
– Join a private group of peers for collaboration.
• Direct Access to the Instructor
– Ask questions and get feedback.
• One-Month Access to the Full Stack Modeller Platform
– Explore additional training content and resources.

• Certificate of Completion

– Showcase your new skills.

Companies That Trust Us

Choose Your Membership Package Today

Standard Membership

12-months access to the entire library of members-only content & community for one person.

Full access to our award-winning training content
Members-only live event series
+150 hours of CPD time
Global community
Regular training support
Masterclass Series
Extended product trials
Does not include Full Stack accreditation

SAVE 16% BY PAYING ANNUALLY

Premium Membership

All Standard Membership features, plus entry into our supported three-stage accreditation programme.

Full Stack Modeller accreditation
Initial one-to-one coaching call
Training guidance and targets provided
Quarterly one-to-one check ins
End of year one-to-one with Full Stack founder

SAVE 16% BY PAYING ANNUALLY

Full Stack Bundle

Memberships and season passes from four leading players in the modelling and analytics industries.

A 12-month Premium Membership with Full Stack Modeller
An AFM exam sitting with the Financial Modeling Institute
A 12-month membership with Maven Analytics
A season pass for the Financial Modeling World Cup
A season pass for the Excel Battle Series

CLICK ON A PRICING OPTION ABOVE TO COMMENCE THE SIGN-UP PROCESS

Still on the fence? Here's why Full Stack is the smart choice for your financial modelling training:

Award-Winning

In 2022 Full Stack won the Training Provider of the Year award at the Digital Finance Function Awards ceremony, hosted by GENCFO and ACCA. We were chosen by a panel of expert judges in recognition of the impact we've made since we started training people in 2020

World-Class Training Faculty

Our core Full Stack training team have decades of real-world modelling experience across multiple sectors. It gets better though. We have a core extended team of experts, including multiple Microsoft MVPs, who deliver live training sessions regularly throughout the year

Exclusive Community Support

Our global, private community is ready and waiting to support you with your modelling challenges. No more hunting around forums and YouTube channels. You ask, and your fellow Full Stackers will be there for you

CPD-Accredited

We have over 150 hours of CPD-Accredited content available to you across our training courses. You can tick off those CPD requirements for years to come

Become A Full Stack Member

Individual Membership

12-months' access to our entire library of members-only content & community for one person.

Members-only live event series
Masterclass Series
Extended product trials
Regular training support
+150 hours of CPD time
Global community
Optional Full Stack Modeller accreditation

Team Training

Customisable training programmes, private team support sessions, progress reports, and more.

Access to all content listed for Individual Membership, plus:
Private consultation from founders
Private team welcome event
Optional private team check ins
Monthly progress reports
Bespoke training options
Optional ongoing coaching

Our Team

Giles Male

Excel Mastery

Iain Morrow

Openbox

Jordan Goldmeier

Data Visualisation & Analytics

Kenny Whitelaw Jones

Financial Modelling

Myles Arnott

Technology for Finance

Toby Tucker

Financial Modelling

Standalone Courses

Not ready to join as a full member? Take a look at some of our alternative training options

Data Visualisation

Master the skills you need to create exceptional presentations & reports

Free

18 Days

Find Out More

Fundamentals of FAST Modelling

Learn the FAST modelling skills you need to build Flexible, Appropriate, Structured and Transparent financial models

$198

3 Months' Access

Find Out More

Excel Mastery Bootcamps

Rethink how you build models in Excel

ON REQUEST

Live, Virtual Training

Find Out More

Transform Your Month End Process

Revolutionise Your Month End with Automation

What You'll Learn

The Fundamentals of Power Query

The Fundamentals of Dynamic Arrays

Real-World Applications

The Developer Mindset

Who Is This Bootcamp For?

What's Included?

Companies That Trust Us

Course Schedule

What Our Students Say

Choose Your Membership Package Today

Standard Membership

Premium Membership

Full Stack Bundle

Still on the fence? Here's why Full Stack is the smart choice for your financial modelling training:

Award-Winning

World-Class Training Faculty

Exclusive Community Support

CPD-Accredited

Become A Full Stack Member

Individual Membership

Team Training

Our Team

Giles Male

Excel Mastery

Iain Morrow

Openbox

Jordan Goldmeier

Data Visualisation & Analytics

Kenny Whitelaw Jones

Financial Modelling

Myles Arnott

Technology for Finance

Toby Tucker

Financial Modelling

Standalone Courses

Data Visualisation

Fundamentals of FAST Modelling

Excel Mastery Bootcamps

Blog

6 weeks to go until the FMI AFM exam

7 weeks to go until the FMI AFM exam

9 weeks to go until the FMI AFM exam

Interview with Victor Momoh

Interview with Michael Jarman: Named Ranges

Interview with Danielle Stein Fairhurst: Reflections & Future Plans

Unlock your modelling potential

with our award-winning training

Unlock your modelling potential

with our award-winning training

Meet Your Trainer

Get Started Today