What's Inside?

    1. Welcome To The Course!

    1. 1.00 - Get Started With Google Sheets

    2. 1.01 - Creating A New Spreadsheet

    3. 1.02 - Using the Ribbon

    4. 1.03 - Inputting & Formatting Data

    5. 1.04 - How To Input & Use Formulae

    6. 1.05 - Absolute vs. Relative Cell References

    7. 1.06 - Collaboration & Access Control

    8. 1.07 - Downloading & Printing Sheets

    9. 1.08 - Importing Data

    10. Test Your Knowledge #1

    1. 2.00 - Introduction To Formatting

    2. 2.01 - Merging Cells

    3. 2.02 - Formatting Numbers & Currencies

    4. 2.03 - Professional Tables

    5. 2.04 - Checkboxes & Drop Down Menus

    6. 2.05 - Find & Replace

    7. 2.06 - Trimming Data

    8. 2.07 - Freezing Rows & Columns

    9. 2.08 - Protect Sheets & Cells

    10. 2.09 - Hiding Rows & Columns

    11. 2.10 - Naming Cells & Ranges

    12. Test Your Knowledge #2

    1. 3.00 - Creating Highlighting Conditions

    2. 3.01 - Formatting Styles

    3. 3.02 - Blank vs. Not Blank

    4. 3.03 - Text Based Conditional Formatting

    5. 3.04 - Working With Dates

    6. 3.05 - Highlighting Entire Rows

    7. 3.06 - Multiple Conditional Formatting Rules

    8. Test Your Knowledge #3

    1. 4.00 - Data Preparation (A Necessary Evil)

    2. 4.01 - Date Formats

    3. 4.02 - Split Data Into Columns

    4. 4.03 - Remove Blank Rows

    5. 4.04 - Highlight & Remove Duplicates

    6. 4.05 - Convert Rows To Columns

    7. Test Your Knowledge #4

    1. 5.00 - Introduction To Functions

    2. 5.01 - Mathematical Operators

    3. 5.02 - Logical Operators

    4. 5.03 - Date Functions

    5. 5.04 - Statistical Operators

    6. 5.05 - Random Number Generator

    7. 5.06 - Partial Extractions

    8. Test Your Knowledge #5

Google Sheets Mastery

Begin Learning Now

The Secret To Advancing Your Career Isn't Playing Politics...

The secret is: Be Useful

We use spreadsheets for everything. In many jobs, you won't go a day without looking at a one.

But spreadsheets are also complicated. Most people don’t know how to use them properly.

That’s what Google Sheets Mastery is designed to help with. It shows you everything you need to know to be really, really good at spreadsheets.

  • Real-World Applications

    Put theory into practice with real-world examples and projects. Walk away with hands-on experience, ready to tackle challenges in your career or business. Upon successfully finishing the course, you will receive a certificate of completion for your resume.

  • Hands-On Google Sheets Expertise

    Dive into a extensive curriculum that will show you how to build dynamic models, automate repetitive tasks, and create interactive dashboards that impress colleagues and clients alike.

  • Lifetime Access

    Gain lifetime access to course materials and updates, ensuring you're always up-to-date with the latest Google Sheets features.