Additional resources - Google Sheets Tutorial

Contents

• Introduction Introduction

  • Get organized with Google Sheets

    1m 2s
  • Importing exercise files to Google Sheets

    1m 45s
• 1. Getting Started with Google Sheets 1. Getting Started with Google Sheets

  • (Locked)
    What is Google Sheets?

    3m 19s
  • (Locked)
    Accessing Google Sheets with your account

    2m 29s
  • Navigating Google Sheets

    6m
• 2. Creating and Managing Spreadsheets 2. Creating and Managing Spreadsheets

  • (Locked)
    Creating, naming, and saving a spreadsheet

    3m 52s
  • (Locked)
    Copying and renaming a spreadsheet

    2m 29s
  • (Locked)
    Moving a spreadsheet

    2m 4s
  • (Locked)
    Deleting a spreadsheet

    2m 31s
  • Importing spreadsheets from Excel and OpenOffice

    3m 36s
  • (Locked)
    Importing data files

    1m 37s
• 3. Editing Spreadsheets 3. Editing Spreadsheets

  • (Locked)
    Entering and editing cell data

    5m 35s
  • (Locked)
    Inserting, deleting, and clearing rows and columns

    2m 32s
  • (Locked)
    Moving or copying rows, columns, and cells

    3m 2s
  • (Locked)
    Working with multiple sheets

    3m 44s
  • (Locked)
    Creating a series of numbers, letters, or dates

    2m 27s
  • (Locked)
    Inserting images and hyperlinks

    4m 12s
• 4. Viewing Spreadsheets 4. Viewing Spreadsheets

  • (Locked)
    Freezing rows and columns

    2m 5s
  • (Locked)
    Hiding rows, columns, and sheets

    2m
  • (Locked)
    Using filters and creating filter views

    4m 4s
  • (Locked)
    Sorting data on a spreadsheet

    3m 20s
• 5. Formatting, Printing, and Publishing Spreadsheets 5. Formatting, Printing, and Publishing Spreadsheets

  • (Locked)
    Formatting cells, rows, and columns

    5m 5s
  • (Locked)
    Using conditional formatting

    3m 1s
  • (Locked)
    Printing a spreadsheet

    3m 11s
• 6. Working with Spreadsheet Data 6. Working with Spreadsheet Data

  • (Locked)
    See the Sum, Average, Min, Max, or Count

    3m 48s
  • Using formulas and functions

    5m 52s
  • (Locked)
    Using IF and nested functions in formulas

    4m 32s
  • (Locked)
    Creating charts and graphs

    4m 12s
  • (Locked)
    Using pivot tables

    4m 47s
• 7. Collaborating with Google Sheets 7. Collaborating with Google Sheets

  • (Locked)
    Sharing a spreadsheet with other people

    4m 45s
  • (Locked)
    Collaborating and commenting on a spreadsheet

    4m 41s
  • (Locked)
    Working with spreadsheet revisions

    3m 17s
• Conclusion Conclusion

  • (Locked)
    Additional resources

    1m 7s