Professional corporate training since 2008
info@jfl-media.com1-866-259-5647
JL JFL MEDIATRAINING
Google Sheets training plan builderCreate a customized learning path in minutes
CatalogueAssess my levelFRBook a conversation

GsGoogle Sheets

Build your training plan

Drag modules into your plan, then reorder them to match your team’s needs. Each module is a private three-hour session.

10 available modules3 hours per moduleBeginner to advancedEmail copy included

Your customized pathway

Drag modules to the centre

The catalogue stays on the right. Your plan is built in the centre and totals update automatically.

02

Build area

My training plan

Drag a module here

Drop cards from the catalogue, then drag them within the plan to change their order.

Google Sheets

The 10 available modules

Each module is three hours and can be combined with others to create a pathway suited to your team’s level and priorities.

Beginner · 3 h

01. 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
Beginner · 3 h

02. 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
Beginner · 3 h

03. 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
Intermediate · 3 h

04. 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
Intermediate · 3 h

05. 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
Intermediate · 3 h

06. 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
Intermediate · 3 h

07. 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
Advanced · 3 h

08. 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
Advanced · 3 h

09. 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
Advanced · 3 h

10. 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

Back to Google Sheets training