What is included?

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. 


Course Curriculum

  • 1

    Excelerator Module 1 - Excel 101

    • Welcome to The Excelerator Course!!! 🎉

    • Join The Excelerator Lounge Facebook Group!

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

    Excelerator Module 2 - Formatting

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

    Excelerator Module 3 - Conditional Formatting

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

    Excelerator Module 4 - Cleaning Data

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

    Excelerator Module 5 - Wheel of Functions!!!

    • 501 - Case Functions

    • 502 - Extraction Functions

    • 503 - Location Functions

    • 504 - Date & Time Functions

    • 505 - Logical Functions

    • 506 - Statistical Functions

    • 507 - Combination Functions
  • 6

    Excelerator Module 6 - Business 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
  • 7

    Excelerator Module 7 - Analysis Tools

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

    Excelerator Module 8 - Pivot Tables

    • 801 - Pivot Table Prep

    • 802 - Building Pivot Tables

    • 803 - Refreshing and Behind the Scenes

    • 804 - Slicers
  • 9

    Excelerator Module 9 - Lookup Functions

    • 901 - VLOOKUP Function

    • 902 - VLOOKUP Limit

    • 903 - HLOOKUP Function

    • 904 - Index / Match Combo

    • 905 - XLOOKUP Function (Microsoft 365 Only)
  • 10

    Excelerator Module 10 - Reviewing & Troubleshooting

    • 1001 - Proofing Your Workbook

    • 1002 - Reviewing Workbooks

    • 1003 - Protecting Sheets

    • 1004 - Error Messages

    • 1005 - Formula Auditing

    • 1006 - Delete Blanks
  • 11

    Excelerator Module 11 - Customizations & Collaborations

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

    Excelerator Module 12 - Creating Macros using VBA

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

    Welcome to the Advanced Excelerator Course! 🙌

    • Welcome!!!
  • 14

    Advanced Module 1 - Advanced Pivot Tables 🎉

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

    Advanced Module 2 - LOOKUP FUNCTIONS Advanced Uses 🔎

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

    Advanced Module 3 - VBA Foundations 🏫

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

    Advanced Module 4 - Writing VBA Code 📝

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

    Advanced Module 5 - Your VBA Tool Kit 🧰

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

    Advanced Module 6 - Debugging 🐛

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

    Advanced Module 7 - Beautify & Organize Your Code 💄

    • 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 🌈
  • 21

    Advanced Module 8 - UserForms & ActiveX Controls ☑

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

    Advanced Module 9 - Creating Your Own Custom Functions (UDFs) 🎨

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

    Advanced Module 10 - Macro Library 📚

    • Advanced 1000: Your Macro Script Library Card 💳
  • 24

    Advanced Module 11 - Productivity Hacks 💪

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

    Advanced Module 12 - Financial Modeling Tools 💸

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

    Dashboard Mini Course 💻

    • Welcome to the Dashboard Mini Course!

    • Dashboard - Part 1

    • Dashboard - Part 2

    • Dashboard - Part 3

    • Dashboard - Part 4

    • Dashboard - Part 5
  • 27

    Shortcut Guides & Template Library

    • Shortcut Guides & Template Library 📚