Importing data files - 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

  • What is Google Sheets?

    3m 19s
  • Accessing Google Sheets with your account

    2m 29s
  • Navigating Google Sheets

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

  • Creating, naming, and saving a spreadsheet

    3m 52s
  • Copying and renaming a spreadsheet

    2m 29s
  • Moving a spreadsheet

    2m 4s
  • Deleting a spreadsheet

    2m 31s
  • Importing spreadsheets from Excel and OpenOffice

    3m 36s
  • Importing data files

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

  • Entering and editing cell data

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

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

    3m 2s
  • Working with multiple sheets

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

    2m 27s
  • Inserting images and hyperlinks

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

  • Freezing rows and columns

    2m 5s
  • Hiding rows, columns, and sheets

    2m
  • Using filters and creating filter views

    4m 4s
  • Sorting data on a spreadsheet

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

  • Formatting cells, rows, and columns

    5m 5s
  • Using conditional formatting

    3m 1s
  • Printing a spreadsheet

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

  • See the Sum, Average, Min, Max, or Count

    3m 48s
  • Using formulas and functions

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

    4m 32s
  • Creating charts and graphs

    4m 12s
  • Using pivot tables

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

  • Sharing a spreadsheet with other people

    4m 45s
  • Collaborating and commenting on a spreadsheet

    4m 41s
  • Working with spreadsheet revisions

    3m 17s
• Conclusion Conclusion

  • Additional resources

    1m 7s