The Ultimate Excelerator Course Bundle!
Let's Excelerate!
The Ultimate Excelerator Bundle includes immediate access to the Excelerator Course + the Advanced Excelerator Course + the Dashboard Mini Course. Take advantage of this presale bundle pricing!
Do I have to start on a certain day?
You can complete the course at your own pace and start whenever you'd like! You will have lifetime access to the videos and materials.
Welcome + Download Course Materials 🎉
Join The Excelerator Lounge Facebook Group!
Shortcut Guides & Template Library 📚
101 - Excel 101
102 - Anatomy of a Function
103 - Meet the Ribbon
104 - Getting Started in Excel
105 - Navigating Around the Workbook
106 - Moving Sheets
107 - Printing
108 - Saving & Closing
201 - Formatting Basics
202 - Exploring Themes
203 - Visible Cells Only
204 - Freezing Panes
205 - Naming Cells
206 - Drop Down Menu
207 - Absolute Referencing
208 - Paste Special
209 - Tables
301 - Intro & Highlight Cell Rules
302 - Duplicate / Unique Values
303 - Text That Contains
304 - Top & Bottom Rules
305 - Heat Maps
306 - Clear Rules & New Rules
307 - Conditional Format Entire Row
401 - Left & Find / Flash Fill
402 - Find & Replace / Color Replace Trick
403 - Text to Columns Tool
404 - IFERROR Function
405 - Remove Duplicates
406 - Randomize Cells
501 - Case Functions
502 - Extraction Functions
503 - Location Functions
504 - Date & Time Functions
505 - Logical Functions
506 - Statistical Functions
507 - Combination Functions
601 - FV Function
602 - FV Schedule Function
603 - PV Function
604 - NPV Function
605 - XNPV Function
606 - PMT Function
607 - PPMT Function
608 - IRR Function
609 - MIRR Function
610 - XIRR Function
611 - NPER Function
612 - Rate Function
701 - Ideas Tool
702 - Chart Building
703 - Data Types Geography Tool
704 - Data Types Stocks Tool
705 - Filtering
706 - Filter Function
707 - Counting & Summing
708 - Grouping & Subtotal
709 - Goal Seek Tool
801 - Pivot Table Prep
802 - Building Pivot Tables
803 - Refreshing and Behind the Scenes
804 - Slicers
901 - VLOOKUP Function
902 - VLOOKUP Limit
903 - HLOOKUP Function
904 - Index / Match Combo
905 - XLOOKUP Function (Microsoft 365 Only)
1001 - Proofing Your Workbook
1002 - Reviewing Workbooks
1003 - Protecting Sheets
1004 - Error Messages
1005 - Formula Auditing
1006 - Delete Blanks
1101 - Ribbon and Quick Access
1102 - Auto Correct and Error Checking
1103 - Defaults and Auto Save Customizations
1104 - Office Collaborations (PowerPoint & Word)
1105 - Embedding Links
1106 - Add Ins Intro
1200 - Download Module 12 Workbook
1201 - What is VBA
1202 - Let's Meet VBA
1203 - Breaking down VBA code
1204 - Recording a Macro
1205 - Relative Referencing
1206 - Macro Buttons
Welcome!!!
Advanced 100: Welcome -- Let's take a deep dive into Pivot Tables!
Advanced 101: Pivot Table Prep
Advanced 102: Creating Pivot Tables
Advanced 103: Pivot Tables Behind the Scenes
Advanced 104: Slicer City 🏙
Advanced 105: Advanced Slicer Uses
Advanced 106: Calculated Fields
Advanced 107: Grouping
Advanced 108: It's Timeline Time! ⌛
Advanced 200: Welcome to LOOKUP Land!
Advanced 201: All Things VLOOKUP!
Advanced 202: Limitation of VLOOKUP 😨
Advanced 203: HLOOKUP
Advanced 204: The OG Love Match: Index / Match 🥰
Advanced 205: Meet your new BFF -- XLOOKUP! 👯♀️
Advanced 206: Advanced Uses of XLOOKUP
Advanced 207: Hey I heard you were a...WILDCARD!
Advanced 208: Easy Model using XLOOKUPs
Advanced 209: XMATCH (*NEW FUNCTION*)
Advanced 300: Let's Automate Your World 🌎
Advanced 301: What even is VBA?!
Advanced 302: Let's Meet Macros
Advanced 303: Breaking Down VBA Code
Advanced 304: Prepping your computer for VBA
Advanced 305: Finding Properties / Methods 🔍
Advanced 306: How to Record a Macro 🎬
Advanced 307: Best Practices for Recording Macros
Advanced 308: Navigating Visual Basic Editor (Treasure Map Included! 🏴☠️)
Advanced 309: Relative Referencing
Advanced 400: Welcome to Code 101
Advanced 401: Referencing Ranges
Advanced 402: Most Popular Range Methods / Properties
Advanced 403: Finding Last Row of Your Range
Advanced 404: Referencing Rows / Columns
Advanced 405: Working with Worksheets
Advanced 406: Working with Workbooks
Advanced 500: Meet your VBA Tool Kit
Advanced 501: VBA Functions You Need to Know
Advanced 502: Looping - For Each
Advanced 503: Looping - For Next
Advanced 504: Subs on Subs 🥪
Advanced 505: If Else Statements (The IF Statements of VBA)
Advanced 506: Select Case
Advanced 507: Working With Files in VBA
Advanced 508: Tables in VBA
Advanced 600: Why do we Debug?
Advanced 601: Debugging Methods (Step Into)
Advanced 602: Debugging Tools
Advanced 603: Local & Watch Windows
Advanced 604: Error Controls
Advanced 700: Code...but make it cute
Advanced 701: Dimming Variables
Advanced 702: Code too long? You need to CUT IT
Advanced 703: Button Hack (No More Ugly Buttons Allowed!)
Advanced 704: Making Code Prettier 💁🏻♀️
Advanced 705: With & End With
Advanced 706: Message Box
Advanced 707: Input Box
Advanced 708: Input Box (Bottom of List Trick)
Advanced 709: Speed Up Your Code 🏁
Advanced 710: Working with Colors in VBA 🌈
Advanced 800: Welcome to UserForms & ActiveX Controls
Advanced 801: ActiveX Basics
Advanced 802: ActiveX Combo Box
Advanced 803: ActiveX Check Box ✅
Advanced 804: ActiveX Show / Hide Controls
Advanced 805: UserForm Basics
Advanced 806: UserForm Basics Part 2
Advanced 900: Don't See the Function You Want? Let's Make Your Own!
Advanced 901: Creating Functions 101
Advanced 902: Custom Function Rules
Advanced 903: Example: Cell Count by Color
Advanced 904: Example: Extract Numbers Only
Advanced 905: Example: Extract Text Only
Advanced 1000: Your Macro Script Library Card 💳
Advanced 1100: Welcome to the Productivity Portal!
Advanced 1101: Case Functions
Advanced 1102: Extraction Functions
Advanced 1103: Location Functions
Advanced 1104: Date & Time Functions ⏰
Advanced 1105: Logic Functions
Advanced 1106: Statistical Functions
Advanced 1107: And / Concat / Textjoin
Advanced 1108: Color Swap
Advanced 1109: Restore Titles
Advanced 1110: Number Format Pro Tip
Advanced 1111: Linked Picture
Advanced 1112: Shapes Hack
Advanced 1113: Office Collaborations
Advanced 1200: Financial Modeling Intro
Advanced 1201: Future Value
Advanced 1202: Future Value Schedule
Advanced 1203: Present Value
Advanced 1204: Net Present Value
Advanced 1205: Net Present Value for Cash Flow Schedules (XNPV)
Advanced 1206: Payment Function
Advanced 1207: PPMT Function
Advanced 1208: Internal Rate of Return
Advanced 1209: Modified Internal Rate of Return (MIRR)
Advanced 1210: XIRR Function
Advanced 1211: Number of Periods Function (NPER)
Advanced 1212: Rate Function
Advanced 1213: Additional Financial Modeling Resources
*BONUS* Investing Resource!
Welcome + Download Course Materials:
Dashboard - Part 1
Dashboard - Part 2
Dashboard - Part 3
Dashboard - Part 4
Dashboard - Part 5