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
Google Sheets — Advanced
Google Sheets — Advanced
Private Google Sheets advanced training for businesses across Canada: 3 three-hour modules and a customizable plan.
Program
Modules in this level
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
Outcomes
Directly observable outcomes
✓
Use QUERY to filter and summarize
Practised in an exercise or work case.
✓
Combine FILTER, SORT and UNIQUE
Practised in an exercise or work case.
✓
Define dashboard indicators and objectives
Practised in an exercise or work case.
✓
Combine charts, formulas and filters
Practised in an exercise or work case.
✓
Connect Forms and Sheets for data collection
Practised in an exercise or work case.
✓
Import or export Excel files
Practised in an exercise or work case.
FAQ
Prepare the right pathway
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.
JFL Media
Ready to build your plan?
Select modules from this level and add other topics as needed.