Cohort 1

Transform your Excel skills in this intensive, fast paced fundamentals course.

Myles Arnott

Co-founder Full Stack Modeller

The Excel Fundamentals Bootcamp

If the answer to that question is "Yes" then this bootcamp is for you. I will teach you all of the fundamental Excel skills that you need to transform the way you use Excel. We will start with the core Excel functions including XLOOKUP, SUMIFS, IF and Excel's dynamic array functions. I'll then introduce you to Excel Tables and the incredible benefits of using them as the base of your modelling. Finally we will unleash the power of Pivot Tables and Pivot Charts. Discover how easy it is to find insights from your data and create awesome charts. This is a hands-on course, with plenty of practical experience offered throughout. I will be there every step of the way to support you. You will leave the course with an incredible Excel toolkit that will put you leaps and bounds ahead of most other Excel users.

Do you use Excel every day but struggle to get the most from it?

Anyone looking to advance their Excel skills beyond the basics and equip themselves with an incredible Excel toolkit

Finance professionals who use Excel everyday and struggle to get the most from it

Excel users who want to improve their skills to work more efficiently and avoid mistakes

Who is this course for

What you’ll get out of this course

<ul><li>XLOOKUP</li><li>INDEX &amp; MATCH</li><li>SUMIFS</li><li>IF, AND &amp; OR</li><li>TEXTSPLIT &amp; TEXTJOIN</li><li>UNIQUE, SORT &amp; FILTER</li><li>Text and date functions</li></ul>

The core Excel functions every modeller needs to master, including

<ul><li>How to create an Excel Table</li><li>Core Excel Table functionality</li><li>How to transform your modelling using structured reference formulae</li><li>The benefits of a table based approach to modelling</li></ul>

How to build your model with Excel Tables

<ul><li>Master the Pivot Table fundamentals</li><li>Create insightful charts with ease</li><li>Wow your team with an interactive dashboard</li></ul>

Pivot Tables and Pivot Charts

<ul><li>Learn how to build models that are simple, clear and consistent</li><li>Build models that can be shared easily with your team</li></ul>

Best practice modelling

<ul><li>Shortcuts</li><li>Handy tricks and hacks that will revolutionise the way you use Excel</li></ul>

Handy tips and tricks

Provide a brief description for each module as a way to sell the value of what students will be learning throughout the course.

First Module

Second Module

Third Module

Course syllabus

Meet your instructor

Monday 4th December

Thursday 7th December

Monday 11th December

Thursday 14th December

Friday 15th December

Course schedule

This course builds on live workshops and hands-on projects

Active hands-on learning

You’ll be interacting with other learners through breakout rooms and project teams

Interactive and project-based

Join a community of like-minded people who want to learn and grow alongside you

Course completed by

About this course

Get notified about the next cohort

Learn from live sessions