The Excel Fundamentals Bootcamp
4.9
(9 ratings)
2 Weeks
·Cohort-based Course
Transform your Excel skills in this intensive, fast paced fundamentals course.
The Excel Fundamentals Bootcamp
4.9
(9 ratings)
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
This course includes
5 interactive live sessions
Lifetime access to course materials
In-depth lessons
Direct access to instructor
Projects to apply learnings
Guided feedback & reflection
Private community of peers
Course certificate upon completion
Maven Satisfaction Guarantee
This course is backed by Maven’s guarantee. You can receive a full refund within 14 days after the course ends, provided you meet the completion criteria in our refund policy.
The Excel Fundamentals Bootcamp
Course syllabus
Week 1
Dec 4—Dec 10
Week dates are set to instructor's time zoneEvents
- Dec
4
Session 1: The core Excel functions
Session 1: The core Excel functions
Mon, Dec 4, 4:00 PM - 6:00 PM UTC
- Dec
7
Session 2: Excel Tables
Session 2: Excel Tables
Thu, Dec 7, 4:00 PM - 6:00 PM UTC
Modules
- Session 1: Core functionsSession 1: Core functions0 Lessons • 0 Projects
Week 2
Dec 11—Dec 15
Week dates are set to instructor's time zoneEvents
- Dec
11
Session 3: Pivot Tables and Pivot Charts
Session 3: Pivot Tables and Pivot Charts
Mon, Dec 11, 6:00 PM - 8:00 PM UTC
- Dec
14
Session 4: Best Practice Modelling & Tips and Tricks
Session 4: Best Practice Modelling & Tips and Tricks
Thu, Dec 14, 4:00 PM - 6:00 PM UTC
- Dec
15
Session 5: Case Study Review
Session 5: Case Study Review
Fri, Dec 15, 4:00 PM - 6:00 PM UTC
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.