Google Sheets Intro Training

Google Sheets is the spreadsheet application of Google's cloud-based office suite, which also includes Google Docs (word processing) and Google Slides (presentation). Google's cloud-based office suite is tightly integrated with Google Drive for seamless cloud storage. Being cloud-native, remote access, collaboration, and sharing is as simple as sharing a link.

AcademyX's Google Sheets Intro class will start off with the basics of the application and progress on to some of the more advanced features so that by the end of the course, you will be able to quickly and comfortably create spreadsheets, manipulate data, and produce professional looking spreadsheets with powerful charts and graphs.

Topics covered:

  • Overview of Google Sheets
    • Overview of Google Sheets
    • Accessing Google Sheets
    • Creating a New Google Sheets File
    • Google Sheets Terminology
    • Entering Spreadsheet Data
    • Naming and Saving a Google Sheet File
    • Changing the Name of the File
    • Creating New Folders
    • Moving a Google File to a Folder
    • Downloading Google App File to Another Location
    • Opening A Downloaded File
    • Sharing a Google App File
    • Closing A Google App File
    • Saving and Sharing and Closing
  • Navigating Through And Selecting Data In Google Sheets Files
    • Navigating Google Sheets
    • Navigating With Your Mouse
    • Navigating With Your Keyboard
    • Navigating Spreadsheet Tabs
    • Selecting Google Sheet Cell Ranges
    • Dragging Through Cells
    • Keyboard Selection Techniques
  • Editing Data in Google Sheets
    • Editing and Delete Sheet Data
    • Editing and Replacing Data
    • Inserting Rows, Columns, or Cells in Google Sheets
    • Using Undo and Redo Commands in Google Sheets
    • Copying and Moving Google Sheets Data
    • Copy, Cut, and Paste in Google Sheets
    • Moving Data Using Drag and Drop
    • Copy Data Using Fill Handle
    • Copy and Create a Sequence With Fill Handle
  • Creating and Managing Formulas and Functions
    • Formulas and Functions
    • Mathematical Operators and Order of How Operations Are Performed
    • Creating Basic Formulas
    • Using Functions To Calculate
    • Common Functions
    • Creating Common Functions
    • Getting Help On Functions
    • Copy Formulas and Functions Using the Fill Handle
    • Absolute Reference vs. Relative Reference
    • Assigning Absolute References
  • Working With Multiple Google Sheets
    • Navigating Between Sheets
    • Renaming Sheet Tabs
    • Changing the Color of the Sheet Tabs
    • Inserting New Sheets
    • Deleting Sheet Tabs
    • Moving Sheet Tabs
    • Copying Sheets to Another File
    • Duplicating Sheet Tabs
    • Hiding and Un-hiding Sheet Tabs
    • Protecting and Un-Protecting Sheets
    • Performing Calculations Across Sheets
  • Printing with Google Sheets
    • Viewing Sheet in Preview
    • Understanding Print Options
    • Setting Paper Size and Orientation
    • Setting Scaling Options
    • Setting Margin Options
    • Setting Formatting Options
    • Setting Header and Footer Options
    • Working with Customize Header and Footer
  • Sorting and Filter Data Lists
    • Steps to Sort Data in a Single Field in Lists
    • Sorting On Multiple Fields Simultaneously
    • Filtering Data in Google Sheets Lists
  • Charting Google Sheet Data
    • Steps to Charting Data
    • Customizing Charts
    • Creating Charts in Google Sheets

Prerequisites:

  • Familiarity with web browsers, tabs, new windows, links, and filing systems with files and folders

Google Sheets training offered at