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
Google Sheets — Intermediate
Google Sheets — Intermediate
Private Google Sheets intermediate training for businesses across Canada: 4 three-hour modules and a customizable plan.
Program
Modules in this level
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
Outcomes
Directly observable outcomes
✓
Combine IF, AND, OR and IFERROR
Practised in an exercise or work case.
✓
Use XLOOKUP where available
Practised in an exercise or work case.
✓
Create drop-down lists and input rules
Practised in an exercise or work case.
✓
Clean spaces and inconsistent text
Practised in an exercise or work case.
✓
Prepare a clean data source
Practised in an exercise or work case.
✓
Create a pivot table
Practised in an exercise or work case.
✓
Share with the right permissions
Practised in an exercise or work case.
✓
Use comments and mentions
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.