Log In
Rated_logo

Transform Your Month End Process

Learn how to automate manual Excel processes using Power Query and Dynamic Arrays.

Over six live sessions, this hands-on bootcamp will revolutionise your workflow, saving you time and effort.
Month End Excel Automation Bootcamp graphic
Finance professional woman smiling-1
Laptop working team
1-4

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.


Register for the Month End Excel Automation Bootcamp

“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

image (1)-1

What You'll Learn

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.

finance presentation on screen, lady presenting-1-1

Who Is This Bootcamp For?

This bootcamp is perfect for:

  •  

Finance Professionals:

Involved in the month end process

Excel Users

  • Managing data regularly

Anyone Eagre to Learn

Automation techniques for professional growth

online course studing black man-1

What's Included?

 

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

dyson
Enfield Council
Mulalley
Vorboss
KPMG
MDD
Tunstall
ComfortDelgro
PurpleLime
PitcherParners
Arup
PageGroup
biscuitville
Lloyds
Energy Aspects
UPS

Course Schedule

simple calendar icon in white-2

Week 1

Session 1: Power Query Fundamentals

Session 2: Dynamic Arrays Fundamentals

+ Optional Open Session

simple calendar icon in white-1-1

Week 2

Session 3: Real-World Case Studies

Session 4: The Developer Mindset

+ Optional Open Session

What Our Students Say

rating (1)

“The best Power Query workshop I’ve ever attended! Adding Dynamic Arrays has transformed how I approach month-end reporting. An absolute must!”

Renier, Head of Automation

rating (1)

“One of the most insightful courses I’ve taken. Thank you to Giles and the Full Stack Modeller community for making PQ and Dynamic Arrays so accessible!” 

Sam, FP&A Lead

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
Pay Monthly: £38.50/month
 Pay Annually: £385
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
Pay Monthly: £127.50/month
 Pay Annually: £1,275
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
Pay Upfront: £1,675
 Find Out More
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

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

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

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

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
Join us on a Standard, Premium, or Bundle package
Find Out More

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
Speak to us about our customisable team training
Find Out More

Our Team

Giles Male

Giles Male

Excel Mastery

iain-morrow

Iain Morrow

Openbox

jordan-goldmeier

Jordan Goldmeier

Data Visualisation & Analytics

kenny-whitelaw-jones

Kenny Whitelaw Jones

Financial Modelling

myles-arnott

Myles Arnott

Technology for Finance

toby-tucker

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

Unlock your modelling potential

with our award-winning training

Join as an Individual Register Your Team

Unlock your modelling potential

with our award-winning training

Join as an Individual Register Your Team

Meet Your Trainer

image (1)-1
Giles Male
Co-founder of Full Stack Modeller, Microsoft MVP, and triple-certified FMI professional
Giles is a career-long financial modeller and co-founder of Full Stack Modeller, an award-winning training platform for finance professionals.

With years of experience in financial modelling and month-end process improvement, Giles has helped teams from global organisations simplify their workflows with Power Query and Dynamic Arrays.

Get Started Today

Ready to take control of your month-end process?