Course Overview

Google Sheets is a spreadsheet program that can be used for storing, organising and manipulating data.

This course will enable delegates to gain a good general understanding of the main features of Google Sheets, giving them the ability to produce standard spreadsheets, create formulae and format and print sheets.

Course Content

• Exploring the Environment

  Accessing Sheets
  Exploring the User Interface
  Getting Help

• Understanding Workbooks and Worksheets

  Creating a new workbook
  Saving in Sheets
  Opening an existing workbook
  Navigating
  Selecting and entering data
  Saving a workbook in Sheets as a .xlsx file
  Upload an existing Excel spreadsheet into Sheets
  Downloading your worksheet

• Entering and Editing Data

  Entering text and numbers
  Entering numbers as text
  Inputting dates and times
  Editing the contents of a cell
  Manipulating data
  Undo and redo buttons

• Selecting Data

  Select a range of cells
  Select more than one range
  Select an entire column and row
  Highlight the entire worksheet

• Cell Formatting in Sheets

  Cell Formats options
  Understanding the General Format
  Date and Time Formats
  Currency and Accounting Formats
  Text Formats
  Clearing and Resetting Formats

• AutoFill

  Using Autofill to automate data entry
  Text AutoFill
  Number Autofill
  Date AutoFill
  Custom Lists
  Flash Fill
  

• Columns and rows

  Inserting and deleting cells, columns and rows
  Changing column widths and row heights
  Auto-fitting a column to its contents
  Hiding and un-hiding a column or row
  Searching for data in a worksheet
  Freezing and unfreezing rows and columns

• Formatting a worksheet

  Changing fonts
  Merging cells
  Aligning cell contents
  Applying borders to a selection
  Deleting borders around a selection of cells
  Changing the alignment of the contents of a cell
  Using the format painter
  Clearing cells (removing formats)

• Developing a workbook

  Formatting worksheet tabs
  Repositioning worksheets in a workbook
  Inserting and deleting worksheets
  Copying and pasting worksheets

• Cut, Copy and Paste

  Cut, Copy and Paste
  Shortcuts
  Copying and Pasting to different sheets
  Paste Options

• Performing calculations

  Adding and Subtracting Numbers
  Multiplication and Division
  BODMAS
  Cell references
  SUM function
  AUTOSUM
  Useful Basic Functions AVERAGE, MIN, MAX and COUNT

• Basic Sorting and Filtering Data

  Sorting data
  Filtering data

• Basic Charts

  Chart types
  Simple Chart Customisations
  

• Spelling and Printing

  Spell checker
  Print preview
  Printing the spreadsheet
  Printing a section of a worksheet

• Sharing and Collaborating

  Sharing in Sheets
  Emailing a Document as an Attachment
  Collaborating in Real-Time