The Excel Fundamentals Bootcamp
4.9 (9)
2 Weeks
·Cohort-based Course
Transform your Excel skills in this intensive, fast paced fundamentals course.
The Excel Fundamentals Bootcamp
4.9 (9)
2 Weeks
·Cohort-based Course
Transform your Excel skills in this intensive, fast paced fundamentals course.
Course overview
Do you use Excel every day but struggle to get the most from it?
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.
Who is this course for
01
Anyone looking to advance their Excel skills beyond the basics and equip themselves with an incredible Excel toolkit
02
Finance professionals who use Excel everyday and struggle to get the most from it
03
Excel users who want to improve their skills to work more efficiently and avoid mistakes
What you’ll get out of this course
The core Excel functions every modeller needs to master, including
- XLOOKUP
- INDEX & MATCH
- SUMIFS
- IF, AND & OR
- TEXTSPLIT & TEXTJOIN
- UNIQUE, SORT & FILTER
- Text and date functions
How to build your model with Excel Tables
- How to create an Excel Table
- Core Excel Table functionality
- How to transform your modelling using structured reference formulae
- The benefits of a table based approach to modelling
Pivot Tables and Pivot Charts
- Master the Pivot Table fundamentals
- Create insightful charts with ease
- Wow your team with an interactive dashboard
Best practice modelling
- Learn how to build models that are simple, clear and consistent
- Build models that can be shared easily with your team
Handy tips and tricks
- Shortcuts
- Handy tricks and hacks that will revolutionise the way you use Excel
What’s included
Live sessions
Learn directly from Myles Arnott 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.
The Excel Fundamentals Bootcamp
Course syllabus
Week 1
Dec
4
Session 1: The core Excel functions
Dec
7
Session 2: Excel Tables
Session 1: Core functions
Week 2
Dec
11
Session 3: Pivot Tables and Pivot Charts
Dec
14
Session 4: Best Practice Modelling & Tips and Tricks
Dec
15
Session 5: Case Study Review
4.9 (9 ratings)
What students are saying
Meet your instructor
Myles Arnott
Co-founder Full Stack Modeller
Myles is a CIMA qualified accountant with over 25 years of experience using Excel.
Myles has worked across a range of industries and has run his spreadsheet consultancy and training business for the last 15 years.
Myles is a co-founder of Full Stack Modeller, an award-winning training platform and community for finance professionals from all over the world.
Myles also works as a Fractional Finance Director for a number of growing SMEs in the UK so has plenty of real world experience.
Be the first to know about upcoming cohorts
The Excel Fundamentals Bootcamp
Course schedule
4-6 hours per week
Monday 4th December
4pm - 6pm GMT
Core functions
Thursday 7th December
4pm - 6pm GMT
Excel Tables
Monday 11th December
4pm - 6pm GMT
Pivot Tables and Charts
Thursday 14th December
4pm - 6pm GMT
Best Practice
Friday 15th December
4pm - 6pm GMT
Case Study Review
Stay in the loop
Sign up to be the first to know about course updates.
Be the first to know about upcoming cohorts