Excel and Google Sheets formulas
The formulas that cover most real work: references, SUM and IF families, lookups, text and dates, and pivot tables.
- 1Formulas and cell referencesStart with =, use ranges, and understand relative and absolute references.9 min
- 2IF, SUMIF and COUNTIFMake decisions and total only the rows that match.10 min
- 3Lookups: VLOOKUP, XLOOKUP and INDEX/MATCHFind a value in a table by a key.10 min
- 4Text, dates and pivot tablesClean data, work with dates and summarize with a pivot table.10 min
Your certificate
Finish all 4 lessons, passing every exercise, to unlock your certificate of completion.
You completed Excel and Google Sheets formulas. Put your name on a certificate you can download and share.
Your name is used only in your browser to draw the certificate. It is never sent to us.
Share your achievement
Post it and tag the creator. Pick a network to get the text with the right mention.
This is a self-paced completion certificate. Your browser issues it when you pass the exercises. It is not an accredited qualification or a verified credential.