Kat Norton – The Advanced Excelerator Course

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!

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!

What You’ll Learn In The Advanced Excelerator Course

1. Welcome to the Advanced Excelerator Course!

• Welcome + Download Course Materials
• Join the Excelerator Lounge
• Shortcut Guides & Template Library

2. Chapter 1: Advanced Pivot Tables

• 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!

3. Chapter 2: Advanced Uses of LOOKUP Functions

• 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*)

4. Chapter 3: VBA Foundations

• 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

5. Chapter 4: Writing VBA Code

• 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

6. Chapter 5: Your VBA Tool Kit

• 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

7. Chapter 6: Debugging

• 600: Why do we Debug?
• 601: Debugging Methods (Step Into)
• 602: Debugging Tools
• 603: Local & Watch Windows
• 604: Error Controls

8. Chapter 7: Beautify Your Code

• 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

9. Chapter 8: UserForms & ActiveX Controls

• 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

10. Chapter 9: Creating Your OWN Functions (UDFs)

• 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

11. Chapter 10: Macro Library

• 1000: Your Macro Script Library Card
• 1001: Ebook with 100 ready to run macros
• 12. Chapter 11: Productivity Hacks
• 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

13. Chapter 12: Financial Modeling Tools

• 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!