Google Sheets Fundamentals

Master Google's Spreadsheet Program

Last updated 2022-01-10 | 4.7

- Competently navigate the Google Sheets Interface and successfully enter data
- Format spreadsheets so that they are both readable and attractive
- Create formulas and use built-in Spreadsheet functions

What you'll learn

Competently navigate the Google Sheets Interface and successfully enter data

Format spreadsheets so that they are both readable and attractive

Create formulas and use built-in Spreadsheet functions

Manage spreadsheet data and apply filters and sorts

Output

Use Collaboration Tools and Export Spreadsheets

* Requirements

* Be able to navigate the internet using a web browser.
* Must have or create a free Google Account to use Google Sheets

Description

Google Sheets has become the go-to spreadsheet program for millions of users.

An advanced spreadsheet application, Google Sheets is used for everything from tracking finances, to data management, to logging and tracking. With dozens of features, Google Sheets can be intimidating to first-time users. Luckily you can learn the basics in a short period of time and immediately be productive with the Google Sheets software.

This is a learn-by-doing course in which expert instructor Mark Lassoff will guide you step-by-step through creating your first spreadsheet in the very first sections of the course. You'll even write your first functions just a few minutes into the course! He'll then go deeper into formatting your spreadsheet document so it looks good and is readable. Next, Mark will talk about managing data within Google Sheets. You'll learn sorting and filtering as well as data entry validation. Mark will wrap up the course by discussing the output, export, and collaboration tools within Google Sheets.

Open your laptop and follow along with the video lectures and secure and solidify your knowledge with the step-by-step lab exercises included with the course. The exercises are specially designed to help you retain and apply the information taught in the video lectures.

Who this course is for:

People working in an office environment who must use a spreadsheet program
People moving from Microsoft Excel to Google Sheets
Students and Teachers who need a convenient, free spreadsheet program
Anyone who wants to learn, and take advantage of the power of Google Sheets.

Course content

4 sections • 16 lectures

Introduction 4 lectures

Welcome Preview 01:07

Mark welcomes you to the course and tells you what to expect.

Google Sheets Quick Start 1 Preview 04:44

You'll hit the ground running and develop your first spreadsheet in Google Sheets. Part I.

Google Sheets Quick Start 2 Preview 05:05

You'll hit the ground running and develop your first spreadsheet in Google Sheets. Part II

Google Sheets Quick Start 3 Preview 07:17

Create formulas and use built-in Google Sheets functions to do the calculations in your Spreadsheet. Complete the exercise after watching the video lectures in this section.

Formatting Worksheets 4 lectures

Applying Themes Preview 03:59

Themes is a new feature in Google Sheets that will ensure your spreadsheet look their best.

Formatting Numbers Preview 05:47

Learn about the different ways that Google Sheets can handle and display numbers.

Formatting Text Preview 02:06

Learn how to format text cells in Google Sheets.

Text Wrap and Rotation Preview 03:37

Learn how to wrap and rotate text within cells. Complete this exercise after watching the video lectures and downloading the .xlsx file in this section.

Working with Data 4 lectures

Sorting Data Preview 05:53

Learn different methods for storing data within a Google Sheets Spreadsheet.

Filtering Data Preview 04:25

Filtering allows you to set criteria for data displayed within a spreadsheet. Learn how to create filters in Google Sheets in this video.

Filter Views Preview 03:36

In this section you'll learn how to save filters you create with Filter views.

Data Validation Preview 07:36

Learn how to get better data by limiting the kinds of data that can be input to a cell. And then, after downloading the .xlsx file, complete the exercise after watching the video lectures in this section.