Google Sheets

Google Drive and Google Docs

• 1

  All About Google Drive

  

  • Introduction

  • What is Google Drive?

  • Creating Files on Google Drive

  • Challenge!

• 2

  Getting Started with Google Drive

  

  • Introduction

  • Creating an account

  • Google Drive

  • Google Drive interface

  • Drive for mobile devices

  • Challenge!

  

  • Getting Started with Drive

    Set up everything you need to use Google Drive on the web, as well as on your desktop.

    02:468,998 views
• 3

  Uploading and Syncing Files

  

  • Introduction

  • Uploading and syncing files

  • Uploading files and folders to Google Drive

  • Uploading files and folders on the Web

  • Challenge!

  

  • Uploading and Syncing Files

    Learn how to sync and upload files from your computer, so you can access them on your Drive.

    04:3758,331 views
• 4

  Creating Google Docs

  

  • Introduction

  • Creating new docs

  • Creating docs with templates

  • Challenge!

• 5

  Managing your Files

  

  • Introduction

  • Managing your files

  • Organizing files

  • Organizing files on your computer

  • The file action buttons

  • Challenge!

  

  • Managing Your Files

    Different ways to organize your files in Google Drive, and make them easier to find.

    04:3010,232 views
• 6

  Sharing and Collaborating

  

  • Introduction

  • Sharing and collaborating on files

  • Sharing with a link

  • Collaboration tools

  • Challenge!

  

  • Sharing and Collaborating

    Find out how to share files in Drive, and collaborate on Google Docs.

    04:1569,273 views
• 7

  Converting and Printing

  

  • Introduction

  • Converting files from Google Drive format

  • Printing docs in Google Drive

  • Challenge!

Spreadsheet Basics

• 8

  Getting Started with Google Sheets

  

  • Introduction

  • Getting to know Google Spreadsheets

  • The Google Spreadsheets interface

  • Cell basics

  • Challenge!

  

  • Getting Started with Spreadsheets

    Learn how to navigate the Google Spreadsheets interface.

    02:564,230 views
• 9

  Modifying Columns, Rows, and Cells

  

  • Introduction

  • Working with columns, rows, and cells

  • Inserting, deleting, and moving rows and columns

  • Wrapping text and merging cells

  • Freezing rows and columns

  • Challenge!

  

  • Modifying Columns, Rows, and Cells

    Ways to modify columns, rows, and cells, including merging and wrapping text.

    04:164,972 views
• 10

  Formatting Cells

  

  • Introduction

  • Formatting cells

  • Text alignment

  • Cell borders and background colors

  • Formatting text and numbers

  • Challenge!

  

  • Formatting Cells

    Learn how to format cells to make your workbooks more visually appealing.

    04:107,635 views
• 11

  Working with Multiple Sheets

  

  • Introduction

  • Using multiple sheets

  • Challenge!

  

  • Working with Multiple Sheets

    Learn how to create and manage multiple sheets.

    02:161,712 views

Common Spreadsheet Tasks

• 12

  Creating Simple Formulas

  

  • Introduction

  • Creating simple formulas

  • Creating formulas

  • Challenge!

  

  • Creating Simple Formulas

    Find out how to write simple formulas using addition, subtraction, and more.

    03:297,300 views
• 13

  Creating Complex Formulas

  

  • Introduction

  • Complex formulas

  • Challenge!

  

  • Creating Complex Formulas

    Use the order of operations to create complex formulas.

    05:062,420 views
• 14

  Types of Cell References

  

  • Introduction

  • Types of cell references

  • Absolute references

  • Challenge!

  

  • Types of Cell References

    Learn about absolute and relative cell references in Google Spreadsheets.

    04:302,650 views
• 15

  Working with Functions

  

  • Introduction

  • Basic functions

  • Creating a function

  • Google Spreadsheets function list

  • Challenge!

  

  • Working with Functions

    An introduction to functions, including Sum, the functions list, and more.

    05:411,586 views
• 16

  Sorting and Filtering Data

  

  • Introduction

  • Sorting and filtering data

  • Challenge!

Extras

• Understanding the New Google Sheets

• Quiz

Learn More

• Excel Formulas

• Google Docs

• Google Account

• Excel 2013