Advanced Excelerator Course
Let's take it to the next level!
Welcome + Download Course Materials
Join the Excelerator Lounge
Shortcut Guides & Template Library 📚
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 💳
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!