Kat Norton – The Excelerator Course

Description

The Excelerator Course is designed for beginner to intermediate Excel users—whether you’ve only explored the Home ribbon or dabbled with basic pivot tables. By the end of the course, you’ll confidently use lookup functions, create powerful pivot tables, and automate tasks with ease. You’ll also master essential shortcuts, making your workflow faster and more efficient—no mouse required!

100+ Training Videos

from Excel basics to lookup functions and pivot tables

50+ Practice Files

to walk through the training videos with me

Library of Templates & Guides

collection of pre-made worksheets and PDF Guides

The Excelerator Course with Kat Norton

1. Welcome to the Excelerator Course!

Welcome!!! 🥳

Download the Practice Workbooks & Answer Keys 📚

Join The Excelerator Lounge Facebook Group!

Shortcut Guides & Template Library 📚

2. Module 1 – Excel 101

100 – Excel 101 👩‍🏫

101 – Spreadsheet Shuffle 💃

102 – Anatomy of a Function 🦴

103 – Meet the Ribbon 👋

104 – Getting Started in Excel ✨

105 – Copy, Cut and Paste ✂️

106 – Moving Sheets ⬅️

107 – Printing 🖨️

108 – Saving & Closing 💾

3. Module 2 – Formatting

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 📅

4. Module 3 – Conditional Formatting

300 – Intro to Conditional Formatting 🖌️

301 – 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 📅

5. Module 4- Cleaning Data

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 🔢

6. Module 5-Wheel of Functions!!!

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 👏

7. Module 6- Business / Finance 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 🎢

*BONUS* Investing Resource!

8. Module 7 – Analysis Tools

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 🔎

9. Module 8 – Pivot Tables

800 – Intro to Pivot Tables 🧘‍♀️

801 – Pivot Table Prep 🧼

802 – Building Pivot Tables 👷‍♀️

803 – Refreshing and Behind the Scenes 🔃

804 – Slicers ✂️

10. Module 9-Lookup Functions

900 – Intro to Lookup Functions 🛞

901 – VLOOKUP Function ⏸️

902 – VLOOKUP Limit 😅

903 – HLOOKUP Function 🚥

904 – Index / Match Combo 🙌

905 – XLOOKUP Function (Microsoft 365 Only) ❎

11. Module 10 – Reviewing & Troubleshooting

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 🔨

12. Module 11 – Customizations & Collaborations

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 ➕

13. Module 12 – Creating Macros using VBA

1200 – Intro to VBA 🤖

1201 – What even is VBA?! 🤔

1202 – Let’s Meet VBA 👋

1203 – Breaking down VBA code 🧑‍💻

1204 – Recording a Macro 📽️

1205 – VBA and ChatGPT 🤖

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, The Excelerator Course with Kat Norton do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank You For Choosing Us! We appreciate it.