Google Sheets: Formulas & Functions

Wishlist Share

About Course

Build reliable calculations in Google Sheets. This course covers entering formulas, relative and absolute references, essential functions such as SUM, IF, COUNTIF and SUMIF, lookups with XLOOKUP and VLOOKUP, and Sheets-specific array functions including FILTER, UNIQUE and ARRAYFORMULA.

This course is general training. Google Workspace features change regularly and some depend on your account type (personal or work/school) and your administrator’s settings. Check Google’s Help Centre for current details. Tutwoo is independent and not affiliated with Google.

What Will You Learn?

  • Write formulas with correct relative and absolute references Use SUM, AVERAGE, IF, COUNTIF, SUMIF and IFERROR Look up values with XLOOKUP and VLOOKUP Use FILTER, UNIQUE, SORT and ARRAYFORMULA, and know how they differ from Excel

Course Content

Course Lessons

  • Formulas, references and the basics
  • Logic and conditional functions
  • Looking up values
  • Array functions and Sheets-specific features

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕