Google Sheet Intermediate Course

1 day

HRD Corp claimable

Runs in-house for your team

Overview

This programme moves Google Sheets users up to intermediate level, where they analyse data with formulas, functions and database tools. It is for end users who have completed Google Sheets Essentials or have equivalent knowledge.

Participants start with named ranges and mixed references, then use date, time and text functions, the IF function and VLOOKUP. They sort and filter lists, set up filter views, group rows and columns, and use Explore. Later sessions cover charts and pivot tables, including date fields, drill-down and calculated fields.

The course is hands-on, with interactive lectures, discussion and practical exercises. Participants finish able to clean up a spreadsheet with text functions and analyse large amounts of data with pivot tables.

Module topics

  • Range names and mixed references
  • Date, text, logical and lookup functions
  • Sorting, filtering and filter views
  • Grouping, Explore and database functions
  • Creating and formatting charts
  • Pivot tables and calculated fields
  • Templates, hyperlinks, notes and comments

Who runs this programme

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

At a glance

1 day

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry