Digital Skills
Spreadsheet Magic: 10 Google Sheets Formulas in 8 Slides
8 slides • 2 minutes • beginner-friendly
Formula 1
SUM adds up anything in seconds
Type =SUM(A1:A12) and Sheets totals the whole column instantly. No calculator, no mental maths — perfect for budgets and expense lists.
Formula 2
AVERAGE finds the middle ground
=AVERAGE(B1:B20) gives you the mean of any range — handy for grades, monthly spending, or workout stats. MIN and MAX find the smallest and largest values the same way.
Formula 3
IF makes decisions for you
=IF(A1>100,"Over budget","On track") returns one of two answers based on a condition. It is the formula that turns a sheet into a smart assistant.
Formula 4
VLOOKUP searches long lists
Got hundreds of rows? VLOOKUP finds a matching item and pulls back the value beside it — like looking up a price from a product code automatically.
Formula 5
COUNTIF counts what matters
=COUNTIF(C1:C50,"Yes") tallies only the cells that meet your condition. Ideal for surveys, attendance sheets, and to-do lists.
Formula 6
CONCATENATE joins text together
=CONCATENATE(A1," ",B1) merges first and last names into one cell. TODAY() stamps the current date automatically. Small tricks, big time savings.
Full Guide
Want all 10 formulas with examples?
Read the complete beginner’s guide on Tivorenza — free, no signup needed.
Read the Full Guide →