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!

What You’ll Learn In Sheet Smarts For Google Sheets

Welcome to Sheet Smarts!!

• Welcome + Download Course Files
• Shortcut Guides

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

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!)

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

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

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

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

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

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

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

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

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

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

Sale Page: Kat Norton – Sheet Smarts For Google Sheets

When will I receive my course?

You will receive a link to download your course immediately or within 1 to 21 days. It depends on the product you buy, so please read the short description of the product carefully before making a purchase.

How is my course delivered?

We share courses through Google Drive, so once your order is complete, you'll receive an invitation to view the course in your email.

To avoid any delay in delivery, please provide a Google mail and enter your email address correctly in the Checkout Page.

In case you submit a wrong email address, please contact us to resend the course to the correct email.

How do I check status of my order?

Please log in to MMOCourse account then go to Order Page. You will find all your orders includes number, date, status and total price.

If the status is Processing: Your course is being uploaded. Please be patient and wait for us to complete your order. If your order has multiple courses and one of them has not been updated with the download link, the status of the order is also Processing.

If the status is Completed: Your course is ready for immediate download. Click "VIEW" to view details and download the course.

Where can I find my course?

Once your order is complete, a link to download the course will automatically be sent to your email.

You can also get the download link by logging into your mmocourse.hk account then going to Downloads Page.