Google Sheets

Spreadsheet inconsistency creates rework, reporting delays, and avoidable errors when teams collect, calculate, and present data without a shared baseline. This foundational Google Sheets course is a fit for IT Directors, Training Managers, and Team Leads onboarding technical or non-technical staff with little or no Sheets experience.

Each learner should plan for about 6 hours of training, with additional time for applying the lessons to internal spreadsheets. The curriculum moves from spreadsheet fundamentals into formulas, charts, lists, pivot tables, macros, templates, forms, collaboration, and mobile work. For change management, Team Leads can assign it before standardizing shared reporting templates or moving teams deeper into Google Workspace workflows.

CBT Nuggets Playlists can group this course with other Google Workspace onboarding, while Team Reporting helps Training Managers track completion and identify teams that need follow-up practice.

IT teams complete this training to help departments work from cleaner, more consistent spreadsheets and reduce reliance on ad hoc support for basic Google Sheets tasks.

• Faster onboarding: New hires learn spreadsheet navigation, formatting, and core data-entry practices before they inherit team reporting workflows.
• More reliable reporting: Staff learn formulas, functions, lists, and pivot tables to summarize operational data instead of manually recalculating results.
• Clearer stakeholder communication: Teams learn to turn spreadsheet data into charts that support persuasive, readable presentations of trends and outcomes.
• Better shared workflows: Learners practice using templates, forms, collaboration features, and mobile access to support distributed work in Google Workspace.

Knowledge

• Core Google Sheets navigation, spreadsheet structure, and formatting concepts
• How formulas and functions support repeatable calculations
• When to use charts to visualize spreadsheet data
• How lists and pivot tables help organize and summarize information
• Where macros, templates, forms, collaboration, and mobile features fit into Google Sheets workflows

Ability

• Create and format spreadsheets for team use
• Write formulas and use functions to process data
• Build charts that present data clearly to stakeholders
• Organize lists and create pivot tables for analysis
• Use templates, forms, and macros to reduce repetitive work
• Collaborate in Google Sheets and work with files while on the move