Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Google Sheets 2024: Learn Everything You Need To Know

via Skillshare

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Welcome to my Google Sheets 2024 course. My name is Kevin O'Brien and I'll be your Google Sheets Coach! 

WELCOME!

Interested in learning all about Google Sheets? Then you've come to the right place! Whether you're an absolute beginner or just looking to freshen up your current Google Sheets knowledge, then this is the course for you. I'll guide you through all the steps required to get up to scratch in no time, most importantly in a fun and helpful way. 

BECOME A SHEETS SUPERHERO!

Tired of using Microsoft Excel? Sick of creating an amazing spreadsheet on your laptop but forgetting to upload to the cloud or carry it on a flash drive? Google Sheets is the answer for you! Google Sheets allows you to create beautiful spreadsheets very easily on the cloud. And best of all, you can share and edit them with your colleagues or friends from anywhere. 

I'll take you through the most important functions of Google Sheets to help you become a Sheets Superhero! Together we'll cover Sheets's most useful features including:

  1. Creating a free Google account (in case you don't have one!)

  2. Accessing & Creating a Google Sheet

  3. Inviting & Sharing your Sheet

  4. Cell, Rows, & Columns

  5. Functions & Formulas

  6. Conditional Formatting 

  7. Data Validation 

    Plus much much more...

I've divided this course up into bite-sized video lectures to help you get on track easier and quicker. Before you'll know it you'll be saving so much time using Google Sheets so you can spend more time on other projects. So put the kettle on, make yourself a cup of coffee and let's get started :)

Syllabus

  • Course Introduction
  • Create G Account & Accessing Sheets
  • Sheets Interface & Layout
  • Rows & Columns in Sheets
  • Entering Data into Cells
  • Manipulating Cells, Rows & Columns
  • Protecting Range - Warnings & Permissions!
  • Adding New Sheets to your Project
  • Formulas - Adding & Subtracting Cell Values
  • Formulas - Multiplying & Dividing
  • Nested Formulas
  • Quick Functions
  • Functions - IF
  • Functions - SUM
  • Functions - AVERAGE
  • Functions - ROUND & All Functions List
  • Referencing Data From Other Sheets
  • Formatting Currencies, Time, Date & Text
  • Conditional Formatting
  • Inserting Image, Cells, Links, Checkboxes & More
  • Pivot Tables & Pie Charts
  • Google Sheet Filters
  • Sorting A - Z on Google Sheets
  • Menu & Tool Bar Walkthrough
  • Data Validation
  • Sharing & Collaborating on Sheets
  • Conclusion

Taught by

Kevin O'Brien

Reviews

Start your review of Google Sheets 2024: Learn Everything You Need To Know

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.