In the Advanced Excelerator Course you will master task automation with VBA macros. I break down all the coding language for you and make it easy to learn — and fun! You will also learn advanced pivot table and lookup techniques!
The Advanced Excelerator
Join 24,000+ students mastering work productivity
$397
$1,815
Join 24,000+ students
Advanced
Excelerator


Do you ever feel like...
-
Your stomach churns when you hear things like “This can be done with VBA” or “Can you set up a Macro for me?”
-
You waste time researching “How to in Excel” only to receive 54,763 Google Search Results, a 50% increase in blood pressure and still zero clarity on how to complete your task?
-
You wrote "Proficient in Excel" on your resume and forgot to add “only to a certain extent”
-
You are going to start saying “ctions” instead of “functions” because…well, they are NOT fun
-
How many productivity hacks does it take to reclaim your sanity with Excel?
-
Financial Modeling is great when you’re not the one who has to do it
Can You Imagine...
-
Securing your dream job offer because of your impressive Excel skills?
-
Landing that promotion you've always wanted because you’re incredibly efficient with your work?
-
Saving HOURS at work allowing you to do more of what you love in life!
If any of this resonated with you, my course package has exactly what you need!
-
100+
Training Videosthat will teach you how to create macros in VBA and automate your world
-
50+
Practice FilesPractice Files to walk through the training videos with me
-
Library of Templates & Guides
a $127 valued collection of pre-made worksheets and PDF Guides
-
Access to me in our Excelerator Lounge
a private Facebook group where I will be answering your questions and providing my top tips
Course Curriculum
Welcome + Download Course Materials
Join the Excelerator Lounge
Shortcut Guides & Template Library 📚
Proficiency Quiz: START HERE
100: Welcome -- Let's take a deep dive into Pivot Tables!
101: Pivot Table Prep (Best Practices)
102: Creating Pivot Tables
103: Pivot Tables Behind the Scenes
104: Slicer City 🏙
105: Advanced Slicer Uses
106: Calculated Fields
107: Grouping
108: It's Timeline Time! ⌛
200: Welcome to LOOKUP Land!
201: All Things VLOOKUP!
202: Limitation of VLOOKUP 😨
203: HLOOKUP
204: The OG Love Match: Index / Match 🥰
205: Meet your new BFF -- XLOOKUP! 👯♀️
206: Advanced Uses of XLOOKUP
207: Hey I heard you were a...WILDCARD!
208: Easy Model using XLOOKUPs
209: XMATCH (*NEW FUNCTION*)
300: Let's Automate Your World 🌎
301: What even is VBA?!
302: Let's Meet Macros
303: Breaking Down VBA Code
304: Prepping your computer for VBA
305: Finding Properties / Methods 🔍
306: How to Record a Macro 🎬
307: Best Practices for Recording Macros
308: Navigating Visual Basic Editor (Treasure Map Included! 🏴☠️)
309: Relative Referencing
400: Welcome to Code 101
401: Referencing Ranges
402: Most Popular Range Methods / Properties
403: Finding Last Row of Your Range
404: Referencing Rows / Columns
405: Working with Worksheets
406: Working with Workbooks
500: Meet your VBA Tool Kit
501: VBA Functions You Need to Know
502: Looping - For Each
503: Looping - For Next
504: Subs on Subs 🥪
505: If Else Statements (The IF Statements of VBA)
506: Select Case
507: Working With Files in VBA
508: Tables in VBA
600: Why do we Debug?
601: Debugging Methods (Step Into)
602: Debugging Tools
603: Local & Watch Windows
604: Error Controls
700: Code...but make it cute
701: Dimming Variables
702: Code too long? You need to CUT IT
703: Button Hack (No More Ugly Buttons Allowed!)
704: Making Code Prettier 💁🏻♀️
705: With & End With
706: Message Box
707: Input Box
708: Input Box (Bottom of List Trick)
709: Speed Up Your Code 🏁
710: Working with Colors in VBA 🌈
800: Welcome to UserForms & ActiveX Controls
801: ActiveX Basics
802: ActiveX Combo Box
803: ActiveX Check Box ✅
804: ActiveX Show / Hide Controls
805: UserForm Basics
806: UserForm Basics Part 2
900: Don't See the Function You Want? Let's Make Your Own!
901: Creating Functions 101
902: Custom Function Rules
903: Example: Cell Count by Color
904: Example: Extract Numbers Only
905: Example: Extract Text Only
1000: Your Macro Script Library Card 💳
1001: Ebook with 100 ready to run macros ⚡
1100: Welcome to the Productivity Portal!
1101: Case Functions
1102: Extraction Functions
1103: Location Functions
1104: Date & Time Functions ⏰
1105: Logic Functions
1106: Statistical Functions
1107: And / Concat / Textjoin
1108: Color Swap Hack
1109: Restore Titles
1110: Number Formatting Pro Tip
1111: Linked Picture Trick
1112: Shapes Hack
1113: Office Collaborations
1200: Financial Modeling Intro
1201: Future Value
1202: Future Value Schedule
1203: Present Value
1204: Net Present Value
1205: Net Present Value for Cash Flow Schedules (XNPV)
1206: Payment Function
1207: PPMT Function
1208: Internal Rate of Return
1209: Modified Internal Rate of Return (MIRR)
1210: XIRR Function
1211: Number of Periods Function (NPER)
1212: Rate Function
1213: Additional Financial Modeling Resources
*BONUS* Investing Resource!
FINAL QUIZ 📜


Kat Norton
Miss Excel And Instructor
Kat Norton energetically teaches Microsoft Excel to individuals, businesses and educational institutions.
Since launching Miss Excel in June 2020, she has grown a community of over 1,000,000 people on TikTok & Instagram (@miss.excel) through viral Excel trick videos infused with creativity, music and dance.
Kat was recently awarded the Microsoft MVP Award and has been featured in Business Insider, CNBC, and Entrepreneur Magazine as a pioneer in the "Excel Influencer" space. Kat was also named one of the Top Influencers of 2021 by Forbes.
AS SEEN IN
Frequently Asked Questions
Each course is designed to be one module per week over 12 weeks. However, if you are the “Netflix binge-watching” type (like myself) — feel free to go forth and conquer! The courses have approximately 12 hours of content in each and the Mini Courses are about 3 hours each.
No! You can start the courses whenever you’d like!
Yes! Each course comes with lifetime access to all course materials.
Please email Kat directly at [email protected] to learn more about bulk discounts.
Yes! You will receive a Completion Certificate at the end of each course.

The Miss Excel Guarantee
If in the first 14 days of your purchase your course doesn't address your learning and growth needs, we'll refund you in full!
Ready to
excelerate
your skills?
