Boost Your Productivity with Google Sheets
2 days
HRD Corp claimable
Runs in-house for your team
Overview
Participants learn to create, edit, share and print spreadsheets in Google Sheets, and to present their data visually. The programme assumes basic computer skills, including the ability to find saved files, switch between applications and use a web browser.
Sessions combine interactive lectures, discussion and practical exercises. Early modules cover the interface, data entry and formatting, basic functions such as SUM, AVERAGE and COUNT, relative and absolute references, conditional formatting and simple charts. Later modules add IF statements, VLOOKUP, dates and times, print settings, sorting and filtering, data validation, sharing and real-time collaboration, and PivotTables.
Module topics
- Basic terminology and the Sheets interface
- Entering and editing cell data
- Basic formulas, functions and references
- Cell formatting and conditional formatting
- Creating and customising charts
- IF, VLOOKUP and date functions
- Print settings, page breaks and headers
- Sorting, filtering and data validation
- Sharing and real-time collaboration
- PivotTables, custom functions and add-ons
Who runs this programme
At a glance
2 days
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