Course length 

1 day

Why come on this course?

In this hands-on instructor led course, you will learn about the basics of the Google sheets app. Following the course, delegates will be confident in navigating, creating and modifying a Google sheet. Delegates will also learn about basic formatting and create basic formulas and functions.

Course contents

Getting Started with Google Sheets

  • Introduction to Google Chrome / Google Drive
  • Google Sheet Environment
  • Introducing Google Chrome
  • Logging in to your G Suite Tools
  • Accessing Google Sheets
  • Navigate and Selecting Cells in Worksheets
  • Open, Save and Close a Google Workbook

Modifying a Google Sheet

  • Cut, Copy and Paste Commands
  • AutoFill Options
  • Find and Replace
  • Spell Check
  • Undo and Redo Commands
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options

Using Formulas and Functions

  • Create Relative Formulas
  • Insert Google Functions
  • Copying a Formula
  • Creating an Absolute Formulas

Formatting a Google Sheet

  • Font Formatting
  • Add Borders and Colours to Cells
  • Cell Alignment
  • Number Formatting

Managing Google Sheets

  • Managing Sheets
  • Freeze Panes

Printing Google Sheets

  • Printing Options
  • Print Preview Options
Contact Alpha Training