A spreadsheet with names, dates, and status updates is a familiar part of many office tasks. You do not need to learn every Excel feature before becoming useful with a sheet; a small set of formulas can help you total figures, handle simple conditions, and find values. Practice on sample data first, especially before changing a shared work file.
Start with everyday calculations
SUM adds values, as in =SUM(B2:B20), while AVERAGE finds the mean for a range, as in =AVERAGE(C2:C20). COUNT counts cells containing numbers, which is handy when checking whether a column of entries is complete. Confirm that the selected range covers the rows you intend; a correct formula can still return an incomplete answer if the range is too short.
Add a simple decision
IF returns one result when a condition is true and another when it is false. For example, =IF(D2="Complete","Done","Check") can label a status in D2, provided the text in the cell matches the condition. Try it with a few sample rows and check how the result changes when you edit the status.
Find and clean information
XLOOKUP can search one range and return a related value from another, such as finding a department using an employee ID; the exact formula depends on how your columns are arranged. TRIM removes extra spaces from text, which can help when names or labels are inconsistent. Learn what each formula expects, and check a few outputs against the source data before relying on them in a report.