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.
What you’ll learn
Transform your Excel skills in this intensive, fast paced fundamentals course.
XLOOKUP
SUMIFS
Dynamic arrays
Its one thing to know a function, it's another to know when to use it
Bring structure to your model using Excel Tables
Benefit from simple, clear & consistent formulae
One dataset that you can leverage in reports and Pivots Tables
Learn the key best practice principle
And how to apply them
Reduce risk, increase shareability
Learn directly from Myles
Myles Arnott
Co-Founder of Full Stack Modeller. CIMA Qualified Modeller.
Who this course is for
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
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.
Course syllabus
Week 1
Mar
16
Session 1: Excel Tables and core functions part 1
Mar
17
Session 2: Excel Tables and core functions part 2
Week 2
Mar
23
Session 3: Building your reports
Mar
24
Session 4: Best Practice Modelling & Tips and Tricks
Mar
26
Session 5: Case Study Review
Schedule
Live sessions
2-3 hrs / week
Mon, Mar 16
4:00 PM—6:00 PM (UTC)
Tue, Mar 17
4:00 PM—6:00 PM (UTC)
Mon, Mar 23
4:00 PM—6:00 PM (UTC)
Homework
1-3 hrs / week
Frequently asked questions
$245
USD