Description
Kat Norton – The Advanced Excelerator Course download , Kat Norton – The Advanced Excelerator Course review , Kat Norton – The Advanced Excelerator Course free
Kat Norton – The Advanced Excelerator Course
In the Advanced Excelerator Course you will master task automation with VBA macros. I break down all the coding language for you and make it easy to learn — and fun! You will also learn advanced pivot table and lookup techniques!
Do you ever feel like…
Your stomach churns when you hear things like “This can be done with VBA” or “Can you set up a Macro for me?”
You waste time researching “How to in Excel” only to receive 54,763 Google Search Results, a 50% increase in blood pressure and still zero clarity on how to complete your task?
You wrote “Proficient in Excel” on your resume and forgot to add “only to a certain extent”
You are going to start saying “ctions” instead of “functions” because…well, they are NOT fun
How many productivity hacks does it take to reclaim your sanity with Excel?
Financial Modeling is great when you’re not the one who has to do it
Can You Imagine…
Securing your dream job offer because of your impressive Excel skills?
Landing that promotion you’ve always wanted because you’re incredibly efficient with your work?
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
that will teach you how to create macros in VBA and automate your world
50+
Practice Files
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 Advanced Excelerator Course!
Welcome + Download Course Materials
Join the Excelerator Lounge
Shortcut Guides & Template Library 📚
2. Chapter 1: Advanced Pivot Tables
100: Welcome — Let’s take a deep dive into Pivot Tables!
101: Pivot Table Prep (Best Practices)
102: Creating Pivot Tables
103: Pivot Tables Behind the Scenes
104: Slicer City 🏙
105: Advanced Slicer Uses
106: Calculated Fields
107: Grouping
108: It’s Timeline Time! ⌛
3. Chapter 2: Advanced Uses of LOOKUP Functions
200: Welcome to LOOKUP Land!
201: All Things VLOOKUP!
202: Limitation of VLOOKUP 😨
203: HLOOKUP
204: The OG Love Match: Index / Match 🥰
205: Meet your new BFF — XLOOKUP! 👯♀️
206: Advanced Uses of XLOOKUP
207: Hey I heard you were a…WILDCARD!
208: Easy Model using XLOOKUPs
209: XMATCH (*NEW FUNCTION*)
4. Chapter 3: VBA Foundations
300: Let’s Automate Your World 🌎
301: What even is VBA?!
302: Let’s Meet Macros
303: Breaking Down VBA Code
304: Prepping your computer for VBA
305: Finding Properties / Methods 🔍
306: How to Record a Macro 🎬
307: Best Practices for Recording Macros
308: Navigating Visual Basic Editor (Treasure Map Included! 🏴☠️)
309: Relative Referencing
5. Chapter 4: Writing VBA Code
400: Welcome to Code 101
401: Referencing Ranges
402: Most Popular Range Methods / Properties
403: Finding Last Row of Your Range
404: Referencing Rows / Columns
405: Working with Worksheets
406: Working with Workbooks
6. Chapter 5: Your VBA Tool Kit
500: Meet your VBA Tool Kit
501: VBA Functions You Need to Know
502: Looping – For Each
503: Looping – For Next
504: Subs on Subs 🥪
505: If Else Statements (The IF Statements of VBA)
506: Select Case
507: Working With Files in VBA
508: Tables in VBA
7. Chapter 6: Debugging
600: Why do we Debug?
601: Debugging Methods (Step Into)
602: Debugging Tools
603: Local & Watch Windows
604: Error Controls
8. Chapter 7: Beautify Your Code
700: Code…but make it cute
701: Dimming Variables
702: Code too long? You need to CUT IT
703: Button Hack (No More Ugly Buttons Allowed!)
704: Making Code Prettier 💁🏻♀️
705: With & End With
706: Message Box
707: Input Box
708: Input Box (Bottom of List Trick)
709: Speed Up Your Code 🏁
710: Working with Colors in VBA 🌈
9. Chapter 8: UserForms & ActiveX Controls
800: Welcome to UserForms & ActiveX Controls
801: ActiveX Basics
802: ActiveX Combo Box
803: ActiveX Check Box ✅
804: ActiveX Show / Hide Controls
805: UserForm Basics
806: UserForm Basics Part 2
10. Chapter 9: Creating Your OWN Functions (UDFs)
900: Don’t See the Function You Want? Let’s Make Your Own!
901: Creating Functions 101
902: Custom Function Rules
903: Example: Cell Count by Color
904: Example: Extract Numbers Only
905: Example: Extract Text Only
11. Chapter 10: Macro Library
1000: Your Macro Script Library Card 💳
1001: Ebook with 100 ready to run macros ⚡
12. Chapter 11: Productivity Hacks
1100: Welcome to the Productivity Portal!
1101: Case Functions
1102: Extraction Functions
1103: Location Functions
1104: Date & Time Functions ⏰
1105: Logic Functions
1106: Statistical Functions
1107: And / Concat / Textjoin
1108: Color Swap Hack
1109: Restore Titles
1110: Number Formatting Pro Tip
1111: Linked Picture Trick
1112: Shapes Hack
1113: Office Collaborations
13. Chapter 12: Financial Modeling Tools
1200: Financial Modeling Intro
1201: Future Value
1202: Future Value Schedule
1203: Present Value
1204: Net Present Value
1205: Net Present Value for Cash Flow Schedules (XNPV)
1206: Payment Function
1207: PPMT Function
1208: Internal Rate of Return
1209: Modified Internal Rate of Return (MIRR)
1210: XIRR Function
1211: Number of Periods Function (NPER)
1212: Rate Function
1213: Additional Financial Modeling Resources
*BONUS* Investing Resource!
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.