Google Sheets: Essential Features

Too often underestimated, Google Sheets is a powerful tool that can transform your daily efficiency, particularly when it comes to data analysis. However, without a clear method or guidelines, its many features, including sorting, formulas, formatting, and pivot tables, can quickly discourage unfamiliar users.

This training is for people who want to consolidate the basics needed to effectively manipulate, structure, and present data in Google Sheets. Suitable for users with minimal experience with Google Sheets (or Microsoft Excel), it teaches good habits and simple practices to gain autonomy and productivity.

From organizing a table to using essential calculation functions, creating charts, filters, and pivot tables, each section is designed to provide a practical understanding of the available tools. An introduction to some advanced features exclusive to Google Sheets will complete the training.

Objectives

By the end of this training, participants will be able to use basic features to analyze data in Google Sheets.

Is it for you ?

Anyone who handles data in an administrative, operational, or commercial context and wants to use the essential features of Google Sheets more effectively.

Prerequisite

Proficiency with office tools and experience using Google Workspace. Basic familiarity with Google Sheets is desirable.

Your benefits

easy-to-use way in Google Sheets.

• Save time by using essential calculation functions, filters, and pivot tables

to better read and analyze your data.

• Improve the readability and impact of your tables with a polished visual

presentation (conditional formatting, charts, dynamic formats).

Content

Learn basic functions and time-saving tips

• Formula propagation and series extension
• Reference types (absolute and relative)
• Freezing panes and hiding cells or sheets
• Useful keyboard shortcuts for selecting and manipulating data ranges

Organizing and structuring your data

• Simple sorting and configuring automatic filters
• Creating filtered views (collaborative or individual)
• Validating data (numbers, dates, lists)
• Clear presentation of data: alternating colors, alignments, cell adjustments
• Formatting numbers and dates
Détails + / -
Summarizing, calculating, and visualizing data
• Using the SUM and SUBTOTAL functions
• Displaying and reading column statistics
• Creating simple charts from data ranges
• Conditional formatting
• Introduction to pivot tables and linking them to charts
Explore advanced or Google Sheets-specific functions
• Understanding and applying the VLOOKUP function
• Best practices for getting started with tables in Google Sheets (named ranges, structured references)
• Compare Google Sheets and Excel spreadsheets to anticipate incompatibilities
• Discover exclusive and powerful functions such as UNIQUE, FLATTEN, and FILTER, which are useful for dynamically extracting, combining, or filtering data sets

💡 Useful information

Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .