Google Sheets: The Basics

Master spreadsheets basics by learning about functions, data visualizations, collaboration and Apps Script.

What you'll learn
- Navigate Google Sheets Web Interface
- Basic and Advanced Function Writing
- Conditional Formatting
- Charts and Visualization
- An Introduction to Apps Script Basics

Requirements
- No programming or spreadsheet experience necessary.
- You'll need online access to Google Sheets (If you have a Gmail account, you already have access)

Description
This is an introductory Google Sheets course for students, professionals, business owners and operators looking to work faster and more efficiently by using spreadsheets and automations.

Whether you're just getting started using spreadsheets for the first time or are coming over from Excel into the Google Sheets' ecosystem, this is a great intro course to give you a lay of the land.

We'll cover several topics, including:

Navigation: how to get where you need to and know where you are

Toolbar: where things are and the fastest way to get the job done

Collaboration: how to save and collaborate in real time with co-workers

Importing Data

Using basic functions and writing our own custom formulas

Formatting our data

Using built-in tables

Using conditional formatting based on different criteria

Using dropdown lists and data validation

Changing column types in tables

Filtering data with functions

Using slicers to filter and sort data

Creating search bars using built-in functions and tools

Creating data visualizations by using charts: pie, bar and line charts

An introduction to Google Apps Script

This course will give you a great overview to get started with Google Sheets. I've used Sheets professionally for 15+ years and it is extremely capable. Particularly for those who need to collaborate with others quickly and share spreadsheets, Sheets is one of my favorite pieces of software.

Who this course is for:
- Students - business, engineer, liberal arts…everybody is going to use spreadsheets for something!
- Professionals getting started with spreadsheets
- Business operators getting more efficient with spreadsheets
More Info