5 star rating

Challenging but worthwhile!

Alan Kaplan

I was offered the chance to take this course at work. I use sheets everyday as part of my job but this course highlighted how much more there is to it. I've have started using a lot more functions and formulas, noticed that I can no get the breakd...

Read More

I was offered the chance to take this course at work. I use sheets everyday as part of my job but this course highlighted how much more there is to it. I've have started using a lot more functions and formulas, noticed that I can no get the breakdowns I want much faster and present them in a better way.

Read Less
5 star rating

Enjoyed it

Julia Anderson

The course was in-depth, with lots of examples and the instructor engaging. The emphasis on real-world applications and gaining insights from large datasets enhanced my experience with the course. I now feel confident analysing and presenting find...

Read More

The course was in-depth, with lots of examples and the instructor engaging. The emphasis on real-world applications and gaining insights from large datasets enhanced my experience with the course. I now feel confident analysing and presenting findings. Highly recommended for anyone wanting to improve not only their sheets skills but also learn how to present data in an engaging way.

Read Less
5 star rating

Elevate Your Sheets Skills!

Salman A.

I was impressed by the course's structure, teaching, and practical approach. The instructor distills complex concepts into easily digestible lessons that make learning sheets fun.

I was impressed by the course's structure, teaching, and practical approach. The instructor distills complex concepts into easily digestible lessons that make learning sheets fun.

Read Less

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.