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

Subashkaran Perumalu

Excel, Power BI and programming trainer

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.

Programme enquiry