Kat Norton – The Advanced Excelerator Course

Description

The Advanced Excelerator Course  sits one level above the flagship Excelerator Course and focuses on advanced Excel techniques, with a special emphasis on task automation using VBA macros alongside complex pivot table and lookup methods

• It features over 100 video lessons, more than 50 practice files, a library of templates and PDF guides, and access to a private Facebook community (“Excelerator Lounge”) for peer support and instructor interaction

• The curriculum breaks down as follows:

  • Advanced Pivot Tables

  • Advanced Lookup Functions

  • VBA Foundations including writing code, debugging, beautifying code, creating user forms, custom functions (UDFs), and building a macro library

  • Productivity Hacks and Financial Modeling tools

The Advanced Excelerator Course with Kat Norton

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!

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, The Advanced Excelerator Course with Kat Norton do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank You For Choosing Us! We appreciate it.