All resources ยท ๐Ÿ›  Tech & Productivity ยท ุงู„ุนุฑุจูŠุฉ

Excel & Google Sheets Formula Cheat Sheet

The 30 formulas that cover 90% of office work, each with a real example, plus 10 time-saving shortcuts.

Price: โญ 20 Telegram Stars

Open in Telegram

What's inside

Free preview

Formulas work in both Excel and Google Sheets unless noted. Some regional settings use ; instead of , between arguments.

Basics

  1. =SUM(B2:B50) โ€” total.
  2. =AVERAGE(B2:B50) โ€” mean.
  3. =MIN(B2:B50) / =MAX(B2:B50) โ€” smallest / largest.
  4. =COUNT(B2:B50) โ€” counts numbers. =COUNTA(A2:A50) counts non-empty cells.
  5. =ROUND(B2, 2) โ€” round to 2 decimals.

The full resource continues in Telegram. Preview free, pay only if you want it.

Open in Telegram