Google Sheets Fundamentals

Master Google's Spreadsheet Program

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. 

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Google Sheets Quick Start 1

Lecture 3 Google Sheets Quick Start 2

Lecture 4 Google Sheets Quick Start 3

Section 2: Formatting Worksheets

Lecture 5 Applying Themes

Lecture 6 Formatting Numbers

Lecture 7 Formatting Text

Lecture 8 Text Wrap and Rotation

Section 3: Working with Data

Lecture 9 Sorting Data

Lecture 10 Filtering Data

Lecture 11 Filter Views

Lecture 12 Data Validation

Section 4: Finalizing Your Work

Lecture 13 Sharing Your Work with Others

Lecture 14 Printing Your Work

Lecture 15 Emailing Your Work

Lecture 16 Exporting Your Work

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.