About this course

Course type Performance Plus
Course code QAGSITM
Duration 1 Day

In this hands-on instructor led course, you will learn about the Google Sheets app to an intermediate level.

Following the course, delegates will be confident in analysing their data in Google sheets using various formulas and functions.

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Experience in web browsing
  • Work with windows - minimise, maximise, open and close
  • Have attended the Google Sheets Introduction course (QAGSINT) or have equivalent knowledge
  • Basic knowledge of Google drive and Google apps or equivalent knowledge is necessary
  • Have attended the G-Suite for Business course or have equivalent knowledge

Delegates will learn how to

  • Use named ranges to streamline their spreadsheets
  • Understand and use some date and time functions
  • Use text functions to clean up a spreadsheet
  • Use the Logical IF function
  • Utilise the VLOOKUP function to compare data
  • Use filtering options to analyse lists
  • Work with Charts to present data visually
  • Analyse large amounts of data using Pivot Tables

Outline

Module 1: Calculating with Advanced Formulas
  • Naming Ranges
  • Date and Time Functions
  • Text Functions
  • Logical IF
  • V + H Lookup
Module 2: Database Management
  • Sorting
  • Multiple Sorts
  • Filtering
  • Filter Views
  • Filter View Options
  • Grouping Rows and Columns
  • Google Explore
  • Database Functions
Module 3: Working with Charts
  • Creating and Editing Charts
  • View / Edit Mode
  • Chart Options such as Save Image / Publish
  • Organisational / Geo / Gauge Charts
Module 4: Working with Pivot Tables
  • Creating a Pivot Table
  • Editing and Modifying a Pivot Table
  • Adding Data to the Pivot Table
  • Formatting Fields to e.g. Currency
  • Calculated Fields
Module 5: Templates
  • Working with Google Templates
  • Inserting Comments
  • Hyperlinks
  • Adding a Note

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

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

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

All third party trademark rights acknowledged.