Google Sheets Training Course Intermediate Training in Cambridge

Cambridge Intermediate Google Sheets Course Overview

Cambridge is a strong location for business-focused software training, with a long history of innovation, research and professional development. We regularly deliver Google Sheets Training Course training for organisations in and around the area.

This location works well for cloud-based spreadsheet training, giving delegates time to practise formulas, shared reporting and collaborative workflows.

Whether you want us to come to your premises or use a local venue, we can usually provide the equipment needed, including laptops and a projector where required. It is especially helpful for teams looking to improve shared documents, visibility and day-to-day efficiency.

We also run a wider range of computer training courses in Cambridge if you are reviewing other options.

You've got the basics of Google Sheets covered, but now it's time to unlock its full potential. What are the most useful formulas? Can they match Excel's functionality? This Google Sheets Level 2 course will answer these questions and more, giving you the tools to confidently work with powerful formulas, PivotTables, charts, and advanced features that take your spreadsheets to the next level.

What You'll Learn in this Google Sheets Intermediate Training Course

• Use advanced formulas like IF, VLOOKUP, and INDEX/MATCH
• Work with PivotTables to analyse and summarise data
• Filter and organise data efficiently with custom formulas
• Create and customise charts to visualise your data
• Share and protect your Google Sheets with advanced options
• Explore useful add-ons to enhance your productivity

Course Duration: 1 Days

Course Prerequisites for your training in Cambridge

To get the most from this course, you should:

Complete Course Outline

Functions and Formulas in Google Sheets

• Use IF, VLOOKUP, and INDEX/MATCH functions
• Nest functions for advanced calculations
• Work with the FILTER and QUERY functions

PivotTables in Google Sheets

• Create a PivotTable
• Use handy formulas to prepare data for a PivotTable
• Apply different formulas within a PivotTable

Filtering Data

• Add and use filters
• Perform basic searches and filter by condition
• Use custom formulas to filter data
• Save filters as a filter view

Charts in Google Sheets

• Create pie, bar, line, and scatter charts
• Format and customise charts for clarity

Sharing a Google Sheet

• Apply password protection and sharing permissions
• Share sheets securely with others

Reviewing and Adding Comments

• Insert and respond to comments
• Add hyperlinks for easy navigation

Add-Ons

• Install and manage useful add-ons
• Explore popular add-ons to boost productivity
• Remove add-ons as needed

Saving a Google Sheet as a PDF

Other Related Courses

Google Sheets Beginners Training

Google Apps Script Beginners Training

Google Apps Script Intermediate Training

Post-Course Resources

• Training notes & exercise files
• Online materials: video tutorials & shortcuts
• 3 months post training support

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.