Ultimate Excelerator crayon mark

Bundle

Ultimate Excelerator Bundle (Excelerator Course + Advanced Excelerator Course + Dashboard Mini Course)
TOTAL VALUE: $2,699 Your PRICE: $497.00

The Ultimate Excelerator Bundle is perfect for ALL Excel Users. The Bundle Includes: The Excelerator Course, The Advanced Excelerator Course & the Mini Dashboard Course. Get ready to become the Excel wizard in your office!

Ultimate Excelerator Bundle (Excelerator Course + Advanced Excelerator Course + Dashboard Mini Course)

Do you ever feel like...

  • You would be more marketable for a job or promotion if you were more efficient in Excel?

  • You waste time trying to figure things out in your spreadsheets and then spend hours Googling what to do?

  • You wrote "Proficient in Excel" on your resume but hope they don't make you prove it?

  • You are doing too many tasks manually in your spreadsheets...there must be a way to automate!

  • You would be more confident at work or school if you were an Excel wiz?

  • You would rather spend less time fumbling with spreadsheets & more time doing what you love?

Can You Imagine...

  • Securing your dream job offer

  • Landing that raise you've always wanted

  • Saving HOURS at work allowing you do to more of what you love in life!

If any of this resonated with you, my course package has exactly what you need!

  • 200+
    Training Videos

    from Excel basics to lookup functions, pivot tables & VBA Macros

  • 100+
    Practice Files

    to walk through the training videos with me

  • Library of Templates & Guides

    a $127 valued collection of pre-made worksheets and PDF Guides

  • Access to me in our Excelerator Lounge

    a private Facebook group where I will be answering your questions and providing my top tips

Course Curriculum

219 VIDEO LESSONS · 37H 45M

Welcome!!! 🥳

Download Excelerator Course Practice Files 📚

Download Advanced Excelerator & Dashboard Mini Course Materials 🎉

Join The Excelerator Lounge Facebook Group!

Shortcut Guides & Template Library 📚

100 - Excel 101 👩‍🏫

101 - Excel 101

102 - Anatomy of a Function

103 - Meet the Ribbon

104 - Getting Started in Excel

105 - Copy, Cut & Paste

106 - Moving Sheets

107 - Printing

108 - Saving & Closing

200 - Intro to 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

300 - Intro to 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

400 - Intro to Data Cleaning 🧽

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

407 - Delete Blanks ❎

408 - SORT & UNIQUE Functions

409 - TRANSPOSE Function

410 - Rounding

500 - Welcome to 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

600 - Intro to 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

700 - Intro to 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

800 - Intro to Pivot Tables 🧘‍♀️

801 - Pivot Table Prep

802 - Building Pivot Tables

803 - Refreshing and Behind the Scenes

804 - Slicers

900 - Intro to Lookup Functions 🛞

901 - VLOOKUP Function

902 - VLOOKUP Limit

903 - HLOOKUP Function

904 - Index / Match Combo

905 - XLOOKUP Function (Microsoft 365 Only)

1000 - Reviewing & Troubleshooting 🔍

1001 - Proofing Your Workbook

1002 - Reviewing Workbooks

1003 - Protecting Sheets

1004 - Error Messages

1005 - Formula Auditing

1006 - Data Validation

1007 - Views

1008 - Function Help Tools

1100 - 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

1200 - Intro to VBA 🤖

1201 - What is VBA

1202 - Let's Meet VBA

1203 - Breaking down VBA code

1204 - Recording a Macro

1205 - VBA and ChatGPT 🤖

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 1001: Ebook with 100 ready to run macros ⚡

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

kat norton

Kat Norton

Miss Excel And Instructor

Kat Norton energetically teaches Microsoft Excel to individuals, businesses and educational institutions.

Since launching Miss Excel in June 2020, she has grown a community of over 1,000,000 people on TikTok & Instagram (@miss.excel) through viral Excel trick videos infused with creativity, music and dance.

Kat was recently awarded the Microsoft MVP Award and has been featured in Business Insider, CNBC, and Entrepreneur Magazine as a pioneer in the "Excel Influencer" space. Kat was also named one of the Top Influencers of 2021 by Forbes.

AS SEEN IN

Forbes logo
Business Insider logo
CNBC logo
microsoft logo
Bloomberg logo
Morning Brew logo
Daily Mail logo
Sunday Times logo
Daily Express Logo

Join 17,000 + students who’ve achieved mastery with Miss Excel Courses

You have an amazing ability to communicate and convey information in a direct, succinct, and relatable way while being extremely engaging!

Your deep knowledge set and accessible expertise is obviously the core of your skillset here, but WOW, I'm impressed with how you've packaged all of it and your other skills in delivering relevant and functional info to your customers!

- Kevin Ho

Thank you so much for bringing such innovation and creativity to your Excel lessons. You truly have a unique approach to keeping the audience engaged and learning.

As someone who has taught Excel courses at the University level, I personally find it to be exceptional.

- Jeff Peake

It's literally AMAZING! I'm 35% of the way through and I'm beyond impressed. I've purchased my fair share of online courses (my business is totally virtual so I guess you can say I'm in that "world") but you have gone above and beyond in the content and delivery.

Your course is worth every penny!

- Alix Turoff

It’s AHHMAZING!! I’m loving it so much! I’m already using so many of the functions in my accounting job that I had no idea about and it’s really boosted my productivity and efficiency!

- Madison Hopkins

Frequently Asked Questions

Each course is designed to be one module per week over 12 weeks. However, if you are the “Netflix binge-watching” type (like myself) — feel free to go forth and conquer! The courses have approximately 12 hours of content in each and the Mini Courses are about 3 hours each.

No! You can start the courses whenever you’d like!

Yes! Each course comes with lifetime access to all course materials.

Please email Kat directly at [email protected] to learn more about bulk discounts.

Yes! You will receive a Completion Certificate at the end of each course.

The Miss Excel Guarantee

If in the first 14 days of your purchase your course doesn't address your learning and growth needs, we'll refund you in full!

Ready to excelerate
your skills?