Beginner
Modules 01 to 03 — exercises adapted to the team’s projects.
View this levelGsGoogle Sheets
Private Google Sheets training tailored to your team
Analyze, structure and share data in Google Sheets with formulas, pivot tables, charts and reliable collaboration methods.
Method
A practical method focused on your projects
The pathway focuses on business spreadsheet functions and data practices without requiring Apps Script programming.
✓
Focused demonstrations
✓
Guided exercises
✓
3-hour modules
✓
Customizable plan
Three levels
A beginner-to-advanced learning path
The full path is 30 hours across 10 modules. Beginner: 9 h / modules 01 to 03. Intermediate: 12 h / modules 04 to 07. Advanced: 9 h / modules 08 to 10.
Intermediate
Modules 04 to 07 — exercises adapted to the team’s projects.
View this levelAdvanced
Modules 08 to 10 — exercises adapted to the team’s projects.
View this levelComplete program
Ten three-hour modules
Interface, data entry and sheet structure
- Navigate workbooks, sheets and ranges
- Enter and edit data efficiently
- Use number and date formats
- Freeze useful rows and columns
- Organize a file with a clear structure
- Apply naming conventions
Essential formulas and functions
- Create formulas with basic operators
- Use SUM, AVERAGE, MIN, MAX and COUNT
- Understand relative and absolute references
- Use IF for simple conditions
- Copy formulas without errors
- Diagnose common errors
Sorting, filters, filter views and formatting
- Sort by one or more criteria
- Create filters and filter views
- Use conditional formatting
- Create useful custom formats
- Identify duplicates and blanks
- Prepare a readable team sheet
Logical and lookup functions
- Combine IF, AND, OR and IFERROR
- Use XLOOKUP where available
- Use INDEX and MATCH when needed
- Understand exact matches
- Connect tables reliably
- Test results with edge cases
Data validation, cleaning and normalization
- Create drop-down lists and input rules
- Clean spaces and inconsistent text
- Standardize dates, numbers and categories
- Use common text functions
- Detect missing or invalid values
- Establish a quality-control method
Pivot tables and charts
- Prepare a clean data source
- Create a pivot table
- Group and summarize data
- Choose an appropriate chart
- Create useful slicers or filters
- Refresh and share an analysis
Collaboration, protection and history
- Share with the right permissions
- Use comments and mentions
- Protect ranges and sheets
- Use version history
- Create personal filter views
- Avoid conflicts and parallel copies
QUERY, array functions and consolidation
- Use QUERY to filter and summarize
- Combine FILTER, SORT and UNIQUE
- Combine ranges when appropriate
- Create dynamic reports without scripts
- Handle errors and incomplete data
- Document complex formulas
Dashboards and named functions
- Define dashboard indicators and objectives
- Combine charts, formulas and filters
- Create reusable named functions
- Organize a summary page
- Optimize readability and performance
- Prepare a management view
Workspace integrations and no-code workflows
- Connect Forms and Sheets for data collection
- Import or export Excel files
- Insert tables and charts into Docs or Slides
- Use built-in notifications and features
- Manage permissions across linked files
- Design a maintainable workflow without Apps Script
Audience
Who this training is for
Administrative, sales, operations, finance, HR, project teams and users who track or analyze data in Google Sheets.
Outcomes
Skills put directly into practice
Interface, data entry and sheet structure
Essential formulas and functions
Sorting, filters, filter views and formatting
Logical and lookup functions
Data validation, cleaning and normalization
Pivot tables and charts
Use cases
Examples of needs the training can address
Content can be adapted to the organization’s real files, methods and objectives, subject to available licenses and features.
Sales or operations tracking
Simple dashboards
Data cleaning and consolidation
Collaborative files with input controls
Focused workshops
Possible focused workshops
These workshops can be selected individually in the builder or included in a longer path.
Logical and lookup functions
Data validation, cleaning and normalization
QUERY, array functions and consolidation
Dashboards and named functions
FAQ
Frequently asked questions
Can we choose only certain modules?
Yes. The builder lets you create a plan from the 10 Google Sheets modules.
Is the training suitable for beginners?
Yes. Modules 01 to 03 form the 9-hour beginner path.
Can we work with our own files?
Yes, when the files can be shared and doing so complies with your organization’s confidentiality rules.
Do we need a license?
No prerequisite for beginner level. Basic Excel familiarity can help but is not required.
Canada
Private training across Canada
Videoconference training is available to your team across Canada, in English or French.
Extend the learning path
Training that complements Google Sheets
These recommendations extend the workflow covered by this course and make it easier to build a coherent team learning path without adding unrelated topics.
Google Workspace
Connect Gmail, Drive, Docs, Sheets and Slides in a coherent team collaboration workflow.
View training Google Workspace →Google Drive
Organize files, permissions, versions and shared spaces that support the rest of Google Workspace.
View training Google Drive →Google Slides
Turn team data and content into coherent collaborative presentations that are easy to maintain.
View training Google Slides →Microsoft Power BI
Turn Excel and business data into interactive dashboards, measures and shareable reports.
View training Microsoft Power BI →JFL Media
Build your Google Sheets plan
Select modules and send a clear pathway to JFL Media.