Course Curriculum

  • 1

    Welcome to the Advanced Excelerator Course! 🙌

    • Welcome to the Advanced Excelerator Course!

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