Spreadsheet Basics: Essential Formulas Everyone Should Know

September 5, 2026 · 5 min read

You do not need to be a data analyst to benefit from spreadsheets. Basic spreadsheet skills — a handful of formulas, some formatting, and simple organization — handle personal budgets, project tracking, inventory management, and dozens of other everyday tasks. Five formulas cover 90% of what most people need.

SUM and AVERAGE

=SUM(A1:A10) adds all values in cells A1 through A10. =AVERAGE(A1:A10) calculates the mean. These two formulas handle budgets, expense tracking, grade calculations, and any situation where you need a total or average. You can also sum non-contiguous cells: =SUM(A1,B3,C5).

IF — Conditional Logic

=IF(A1>100, "Over budget", "Within budget") checks a condition and returns different values based on the result. Use IF for grading (=IF(B2>=90,"A",IF(B2>=80,"B","C"))), flagging items, and any decision that depends on a value. Nested IFs handle multiple conditions.

COUNT and COUNTIF

=COUNT(A1:A100) counts how many cells contain numbers. =COUNTIF(A1:A100, ">50") counts cells meeting a condition. =COUNTIF(B1:B100, "Completed") counts how many tasks are marked complete. These formulas turn raw data into simple dashboards.

Formatting for Clarity

Bold headers in the first row. Freeze the top row (View > Freeze) so headers stay visible while scrolling. Use currency format for money, percentage format for rates, and date format for dates. Alternate row colors for readability in large tables. These formatting basics make any spreadsheet easier to read and less error-prone.

Try It Now

Our free Percentage Calculator handles this instantly — no signup, no limits.

Also useful: our Unit Converter for related calculations.