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
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.
More in this category
Google Workspace & Analytics
2 days
Google Workspace & Analytics
2 days
Google Workspace & Analytics
2 days