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:
- 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.
- 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.
- 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.
- 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:
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.
Reviews
There are no reviews yet.