Sheet Smarts For

Google Sheets

TOTAL VALUE: $1,516 Your PRICE: $297.00

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!

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

100+
Training Videos

from Google Sheets basics to lookup functions and pivot tables
50+
Practice Files

to walk through the training videos with me
Library of PDF Guides

a $99 valued collection of PDF shortcut Guides
Access to me in our Excelerator Lounge

a private Facebook group where I will be answering your questions and providing my top tips

Course Curriculum

101 VIDEO LESSONS ·

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.

AS SEEN IN

Join 17,000 + students who’ve achieved mastery with Miss Excel Courses

You have an amazing ability to communicate and convey information in a direct, succinct, and relatable way while being extremely engaging!

Your deep knowledge set and accessible expertise is obviously the core of your skillset here, but WOW, I'm impressed with how you've packaged all of it and your other skills in delivering relevant and functional info to your customers!

- Kevin Ho

Thank you so much for bringing such innovation and creativity to your Excel lessons. You truly have a unique approach to keeping the audience engaged and learning.

As someone who has taught Excel courses at the University level, I personally find it to be exceptional.

- Jeff Peake

It's literally AMAZING! I'm 35% of the way through and I'm beyond impressed. I've purchased my fair share of online courses (my business is totally virtual so I guess you can say I'm in that "world") but you have gone above and beyond in the content and delivery.

Your course is worth every penny!

- Alix Turoff

It’s AHHMAZING!! I’m loving it so much! I’m already using so many of the functions in my accounting job that I had no idea about and it’s really boosted my productivity and efficiency!

- Madison Hopkins

Frequently Asked Questions

How long will the courses take me?

Each course is designed to be one module per week over 12 weeks. However, if you are the “Netflix binge-watching” type (like myself) — feel free to go forth and conquer! The courses have approximately 12 hours of content in each and the Mini Courses are about 3 hours each.

Do I have to start the courses at a certain date or time?

No! You can start the courses whenever you’d like!

Will I have lifetime access?

Yes! Each course comes with lifetime access to all course materials.

I am evaluating this for our team. Who can I speak with to learn more?

Please email Kat directly at [email protected] to learn more about bulk discounts.

Can I add a course certificate to my LinkedIn or resume?

Yes! You will receive a Completion Certificate at the end of each course.

The Miss Excel Guarantee

If in the first 14 days of your purchase your course doesn't address your learning and growth needs, we'll refund you in full!