Kat Norton – Sheet Smarts For Google Sheets

Description

Kat Norton – Sheet Smarts For Google Sheets download , Kat Norton – Sheet Smarts For Google Sheets review , Kat Norton – Sheet Smarts For Google Sheets free

Kat Norton – Sheet Smarts For Google Sheets

This course is perfect for all Google Sheets users. Sheet Smarts takes you from the basics through advanced techniques such as Pivot Tables, Query Functions & more!

Do you ever feel like…

• You would be more marketable for a job or promotion if you were more efficient in Google Sheets?
•  You know exactly what you want your Google Sheet to look like and don’t know how to bring it to life?
• You would be more confident at work or school if you were a Google Sheets wiz?
• You waste time formatting each spreadsheet?
• You are doing too many tasks manually in Google Sheets…there must be a better way to automate!
• 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 promotion that you’ve always wanted
• Saving HOURS at work allowing you do to more of what you love in life!

Course Curriculum

1. Welcome to Sheet Smarts!! 🎉

• Welcome + Download Course Files
• Join The Excelerator Lounge Facebook Group!
• Shortcut Guides 📚

2. Module 1: Google Sheets 101 

• 101 – Google Sheets 101
• 102 – Sheets Basics
• 103 – Meet the Tool Bar! 🧰
• 104 – Data Entry
• 105 – Formula Entry
• 106 – Getting Funky with Functions 🕺🏼
• 107 – Sharing Sheets 👯‍♀️
• 108 – Printing Sheets & Saving as PDF

3. Module 2: Basic Formatting 

• 200 – Formatting 101 🎨
• 201 – All about Number Formats
• 202 – Working with Themes (the Presets of Sheets) 🤳🏼
• 203 – Workin’ It in your Worksheet 😎
• 204 – The art of the Hyperlink 🖌
• 205 – Brrrrr! Let’s Freeze Our Panes! ❄⛄
• 206 – Hiding Rows & Columns 🙈
• 207 – Grouping Rows & Columns
• 208 – Absolute vs Relative Referencing (VERY IMPORTANT!) 🚨

4. Module 3: Advanced Formatting 

• 300 – Welcome to Advanced Formatting! 👋🏼
• 301 – Conditional Formatting for Blanks
• 302 – Conditional Formatting with Text
• 303 – Conditional Formatting with Dates 📅
• 304 – Conditional Formatting with Numbers
• 305 – Create a Color Scale 🌈
• 306 – Conditional Formatting Custom Formulas
• 307 – Interactive Cross-Out Checkboxes (Pro Tip!) ✅
• 308 – Alternating Colors Tool
• 309 – Drop Down Menus

5. Module 4: Cleaning Data 

• 400 – Let’s Clean It Up! 🧼
• 401 – Delete Blank Rows
• 402 – Text to Columns Tool
• 403 – Split Function
• 404 – Remove Duplicates ❌
• 405 – Find & Replace
• 406 – Naming Cells / Ranges
• 407 – Spilling! 💦
• 408 – Rand Function
• 409 – Trimming Data ✂

6. Module 5: Wheel of Functions!!! 

• 501 – Case Functions
• 502 – Extraction Functions
• 503 – Location Functions 🌎
• 504 – Date & Time Functions 📆🕑
• 505 – Logical & Information Functions 🤔
• 506 – Statistical Functions 📈
• 507 – Combination Functions
• 508 – Transpose Functions 🔄

7. Module 6: Analysis Tools 

• 601 – Commonly Used Analysis Functions
• 602 – Feeling Iffy? 😵
• 603 – Sorting Techniques
• 604- Filtering Techniques
• 605 – Sort & Unique Functions
• 606 – Building Charts 📊
• 607 – Building Multi Series Charts 📉
• 608 – Chart Slicers

8. Module 7: Pivot Tables 

• 700 – Namaste Pivot Table Team! 🧘🏼‍♀️
• 701 – Preparing Your Data for Pivot Tables 🧹
• 702 – Pivot Table Basics 👩🏼‍🏫
• 703 – Filters vs. Slicers
• 704 – Positioning Pivots for Future Growth 📈
• 705 – Grouping

9. Module 8: Lookup Functions 

• 800 – Welcome to Lookup Land! 🔎
• 801 – VLOOKUP
• 802 – Limitation of a VLOOKUP 🙀
• 803 – Index & Match – The OG Love Match! 💘
• 804 – HLOOKUP
• 805 – Multiple Lookup Results with FILTER Function
• 806 – SORTN

10. Module 9: Query Function + Other Advanced Functions 

• 900 – Advanced Functions Intro 💪🏼
• 901 – Array Formulas
• 902 – Indirect Function
• 903 – Sequence Function
• 904 – IFERROR / IFNA 🙅🏼‍♀️
• 905 – QUERY Function 101
• 906 – QUERY: Select
• 907 – QUERY: Where 🤷🏼‍♀️
• 908 – QUERY: Order by
• 909 – QUERY: Limit
• 910 – QUERY: Group By
• 911 – QUERY: Label 🏷

11. Module 10: Reviewing & Troubleshooting 

• 1000 – Reviewing & Troubleshooting 101 ✍🏼
• 1001 – Spell Check & Personal Dictionary ✔
• 1002 – Debunking Error Messages 😱
• 1003 – Comments & Notes 📝
• 1004 – Protecting Sheets 🔒
• 1005 – Version History 🧾

12. Module 11: Customizations & Collaborations 

• 1100 – Customizations & Collaborations!
• 1101 – Creating Sheets Shortcuts 🩳✂
• 1102 – Using Sheets Offline 📶
• 1103 – Spreadsheet Language / Locale Settings 🌏
• 1104 – Importing Excel Workbooks
• 1105 – Working with Google Forms

13. Module 12: Google Sheets Productivity Hacks

• 1200 – Your Productivity Portal 📝
• 1201 – Sorting Data Within One Cell
• 1202 – Time Hacks ⏰
• 1203 – GOOGLEFINANCE Function 💵
• 1204 – IMPORTRANGE Function
• 1205 – GOOGLETRANSLATE Function 🗣
• 1206 – Emoji Fun (because why not 😇)
• CONGRATS!!!!!!! 🎈🎉💃🏼🥳

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.

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.