Book Now

Google Sheets Advanced

Category: Google Sheets

 Advanced Functions

  • Linking worksheets using linking formulae, SUMIF and SUMIFS
  • Linking worksheets using INDIRECT function
  • Linking worksheets using VLOOKUP, INDEX, MATCH functions
  • IF with nested IF, AND and OR functions
  • Recap of IFERROR, COUNTIF(s) and AVERAGEIF(S)

Managing large data sets

  • Advanced Filters and the FILTER function
  • SUBTOTALS function combined with Advanced and standard Filters  with nested AND and OR
  • Using ArrayFormula with VLOOKUP to lookup multiple conditions

Query Function

  • Creating Named Ranges
  • Introduction to SQL code
  • SELECT *
  • Select specific columns
  • Using the WHERE clause
  • ORDER clause
  • LIMIT clause
  • Using maths in SQL
  • LABEL clause
  • AGGREGATE functions
  • GROUP BY clause

About SquareOne

SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions, individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

Who should attend?

This course is suitable for anyone who is a competent Google Sheets user and wishes to further develop their skills working with the advanced functions, features and tools of Google Sheets.

Objectives

On this course you will learn some of the more advanced features of Google Sheets and how they can be used to work together in an interactive and graphical way.

Course Duration

Duration: 1 Day

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course. All of our courses can be tailored to meet your business needs.

Training Locations

Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead, Aberdeen and Ireland.

Closed courses can also be delivered in European countries such as Austria, Belgium, Denmark, Greece, France, Finland, Hungary, Italy, Ireland, Netherlands, Norway, Portugal, Spain, Poland, Sweden, Switzerland and off shore.... Either in English or local languages

Course Dates 

View our full course schedule here.

Enquiry Form

* indicates required

Booking

Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

For more information about any of our courses please call +44 (0)151 650 6907,
email enquiries@squareonetraining.com or complete an enquiry form.

Back to top