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
Google Sheets — Beginner
Google Sheets — Beginner
Private Google Sheets beginner training for businesses across Canada: 3 three-hour modules and a customizable plan.
Program
Modules in this level
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
Outcomes
Directly observable outcomes
✓
Navigate workbooks, sheets and ranges
Practised in an exercise or work case.
✓
Enter and edit data efficiently
Practised in an exercise or work case.
✓
Create formulas with basic operators
Practised in an exercise or work case.
✓
Use SUM, AVERAGE, MIN, MAX and COUNT
Practised in an exercise or work case.
✓
Sort by one or more criteria
Practised in an exercise or work case.
✓
Create filters and filter views
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.