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

More courses from the same author: Kat Norton