Google Sheets Level 3

Course Code: GSL3   Duration: 1 Day   Price: £285+VAT
Overview

This course is designed for users who want to take more control of Google Sheets and use it in order to facilitate business decisions.  This course allows users to start analysing data for the good of the business rather than just using it as an end user.

Audience

This course is designed for those wishing to gain the skills necessary to automate some common Google Sheets tasks.

Learning Objectives

By actively participating in this course, you will learn about the following:

  • Understand and create pivot tables.
  • Understand and use input tables.
  • Create advanced charts.
  • Create and use hyperlinks.
  • Linking.
  • Import text files.
  • Use various methods of sorting and filtering data.
  • Version history and re-naming a version.
  • Create and use scenarios.
  • Understand and use data validation.
  • Using comments.
  • Create and run macros.
  • Use various password and security features.
Pre-Requisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

 Course Contents
  • Pivot tables
  • Input tables
  • Charts
  • Hyperlinks
  • Linking
  • Importing text files
  • Sorting and filtering data
  • Version history
  • Validating
  • Comments
  • Macros
  • Security

Head Office

Skilltec Training

58 New George Street
City Centre
Plymouth
Devon
PL1 1RR

enquiries@skilltec.co.uk
01752 227330

Follow us on:

Payment methods:

Registered in England 06131527

Registered address: 58 New George Street, Plymouth, PL1 1RR