Kat Norton – The Excelerator Course

Description

Kat Norton – The Excelerator Course download , Kat Norton – The Excelerator Course review , Kat Norton – The Excelerator Course free

Kat Norton – The Excelerator Course

The Excelerator Course is perfect for beginner to intermediate level Excel users (think the person who hasn’t made it past the Home ribbon to the Data Ribbon dabbler who can make a basic pivot table). By the end of the course, you will be confidently utilizing lookup functions, building powerful pivot tables and easily automating tasks. You will also become shortcut savvy and put that pesky mouse to rest!

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 to do more of what you love in life!

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

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

Course Curriculum

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 🤖

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

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.