Software training across Canada

Google Sheets training adapted to the actual level

45-question technical assessment drawn from a 72-question bank to place a learner in Google Sheets and recommend the most useful training modules.

Google Sheets diagnostic: knowledge, workflow habits and training priorities.

Start the free assessment Request delivery terms

Approach

Build the path around observed needs

The free assessment helps separate concepts already mastered from those that deserve training. The final path can then be adjusted to the organization’s tasks, context and objectives.

The diagnostic is not an official certification. It is used to guide training decisions.

Intended audience

Google Sheets analyst

Employees and professionals.
Managers and HR teams.
Training coordinators.
Groups to be organized by skill level.

Visible content

Google Sheets training modules

The modules below come from the catalogue used by the recommendation engine. Their order and depth are adapted after the assessment or engagement analysis.

Module M01

Sheets, ranges and formatting

Keep headers visible while scrolling through a large table • Give a readable name to a range to simplify references • Automatically change a cell’s appearance based on its value

Keep headers visible while scrolling through a large table
Give a readable name to a range to simplify references
Automatically change a cell’s appearance based on its value
Quickly apply row banding to improve readability
Apply a structured workflow for sheets, ranges and formatting

3 h

Module M02

Formulas and references

Lock both column and row when copying a formula • Return a different result depending on whether a condition is true or false • Sum values that meet one or more criteria

Lock both column and row when copying a formula
Return a different result depending on whether a condition is true or false
Sum values that meet one or more criteria
Count cells that meet one or more criteria
Apply a structured workflow for formulas and references

3 h

Module M03

Sorting, filtering and data quality

Temporarily show only rows matching selected criteria • Apply your own filter without disrupting other collaborators’ views • Restrict or guide the values allowed in a cell

Temporarily show only rows matching selected criteria
Apply your own filter without disrupting other collaborators’ views
Restrict or guide the values allowed in a cell
Remove repeated rows based on selected columns
Apply a structured workflow for sorting, filtering and data quality

3 h

Module M04

Lookup, extraction and dynamic arrays

Look up a key in a range and return a corresponding value • Perform a flexible lookup by separating result position from key matching • Dynamically return only rows that meet a condition

Look up a key in a range and return a corresponding value
Perform a flexible lookup by separating result position from key matching
Dynamically return only rows that meet a condition
Query a range with selection, filtering, grouping and aggregation
Apply a structured workflow for lookup, extraction and dynamic arrays

3 h

Module M05

Pivot tables, charts and analysis

Quickly summarize a dataset by categories and measures • Provide a visual control for filtering a pivot table or range • Choose a chart type and configure series, axes and presentation

Quickly summarize a dataset by categories and measures
Provide a visual control for filtering a pivot table or range
Choose a chart type and configure series, axes and presentation
Add a derived calculation inside a pivot table
Apply a structured workflow for pivot tables, charts and analysis

3 h

Module M06

Collaboration and protection

Limit who can edit selected cells or sheets • View or restore an earlier state of the spreadsheet • Draw a collaborator’s attention to a cell and leave follow-up context

Limit who can edit selected cells or sheets
View or restore an earlier state of the spreadsheet
Draw a collaborator’s attention to a cell and leave follow-up context
Receive alerts for selected changes to the file
Apply a structured workflow for collaboration and protection

3 h

Module M07

Advanced functions and dynamic calculations

Apply a calculation to multiple rows or cells with one formula • Name intermediate values inside a formula to improve readability and performance • Turn reusable formula logic into a custom function without scripting

Apply a calculation to multiple rows or cells with one formula
Name intermediate values inside a formula to improve readability and performance
Turn reusable formula logic into a custom function without scripting
Automatically generate a series of numbers in a dynamic range
Apply a structured workflow for advanced functions and dynamic calculations

3 h

Module M08

Imports, connections and external sources

Retrieve a range from another authorized Google Sheets file • Import a table or list from a compatible web page • Analyze large data from supported sources such as BigQuery inside Sheets

Retrieve a range from another authorized Google Sheets file
Import a table or list from a compatible web page
Analyze large data from supported sources such as BigQuery inside Sheets
Automatically populate a sheet with Google Forms responses
Apply a structured workflow for imports, connections and external sources

3 h

Module M09

Macros, Apps Script and automation

Record a sequence of repetitive actions so it can be replayed • Program custom automations and integrations around the spreadsheet • Automatically run a script based on time or an event

Record a sequence of repetitive actions so it can be replayed
Program custom automations and integrations around the spreadsheet
Automatically run a script based on time or an event
Expose Apps Script logic as a function usable in a cell
Apply a structured workflow for macros, apps script and automation

3 h

Canada

Availability for provinces and territories

JFL Media can receive requests from anywhere in Canada. Delivery terms, time zone, availability, location and pricing are confirmed for each engagement.

View service areas →

Before training

Complete the assessment or describe the need precisely.
Choose modules and confirm duration.
Confirm delivery terms, availability and price.

Next step

Start by establishing the Google Sheets level.

The assessment is free and produces a detailed report that can be used to prepare a focused path.

Start the assessment