Business and IT training from QA

Google Sheets Introduction

About this Course

Tech Type Performance Plus
Code QAGSINT
Duration 1 Day

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.

Show more Show less

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Experience in web browsing
  • Work with windows - minimise, maximise, open and close
  • Basic skills with Microsoft Office applications, or equivalent, are recommended, but not mandatory
  • Basic knowledge of Google drive and what it does is recommended, although not necessary

Show more Show less

Delegates will learn how to

  • Get started with Google sheets
  • Create a basic worksheet
  • Modify a Google sheet
  • Use formulas and functions
  • Format a Google worksheet
  • Manage worksheets
  • Set up printing options

Show more Show less

Outline

Module 1: Getting started with Google Sheets
  • Introduction to Google Chrome / Google Drive
  • Google Sheets and the Environment
  • Navigate and Select Data
  • Create a Basic Spreadsheet
  • Open, Save and Close a Google Sheet
Module 2: Modifying a Google Sheet
  • Cut, Copy and Paste Commands
  • AutoFill Options
  • Insert and Delete Options
  • Column Width and Row Height
  • Find and Replace
  • Undo / Redo
Module 3: Using Formulas and Functions
  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas
Module 4: Formatting a Google Sheet
  • Font Formatting Options
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
Module 5: Managing Google Sheets
  • Manage Worksheets
  • View different Google Sheets and Files
  • Freeze Panes and Split
  • Navigate around different Sheets within Google Chrome and Drive
  • Print Google Sheets and Change Print Options

Show more Show less
Performance Plus

1 Day

Duration

This course is authored by QA

Delivery Method

Delivery method

Classroom / Attend from Anywhere

Receive classroom training at one of our nationwide training centres, or attend remotely via web access from anywhere.

Find dates and prices

We have 3 courses available across 1 locations on 3 different dates

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.