Use one row per record and one column per field. Put a single clear header at the top. Avoid merged cells, blank rows in the middle and mixing dates, text and amounts in one column. Convert the range to a Table so headers, filters and formulas remain connected as data grows.

1. Create columns such as Date, Item, Category, Quantity, Unit Price and Status.
2. Use consistent date and currency formats; store numbers as numbers, not typed symbols.
3. Select a cell in the range and choose Insert > Table (or the equivalent in your version); confirm headers.
4. Use the header arrows to sort or filter without deleting records.

Exercise: Make a 10-row sample sales table. Filter to one category, then clear the filter and confirm all records return.

Excel formulas begin with =. A formula can refer to cells, ranges, operators and functions. Try =SUM(Table1[Sales]), =AVERAGE(Table1[Sales]) and =COUNT(Table1[Order ID]), adjusting the table and field names to match yours. Use SUMIFS when you need a total that meets multiple conditions, such as sales for one category during one month.

1. Enter a formula in a new column and check the result on a row you can calculate by hand.
2. Use =SUMIFS(SalesRange,CategoryRange,"Books") as a simple conditional-total pattern.
3. Use XLOOKUP to find a matching value in one range and return a related value from another, if your Excel version supports it.
4. When copying a formula, remember relative references move. Use $A$1 for a fixed assumption that must not move.

Table formulas may automatically fill down. The Total Row uses SUBTOTAL by default and can exclude filtered-out rows, so check what your report is meant to count.

Exercise: Calculate monthly sales and one conditional total; verify with a small hand calculation.

A report should show what was measured and the period covered. Add a pivot summary or a simple chart only when it helps answer a specific question. Keep raw records on a separate sheet and label assumptions. Excel for the web is available free with a Microsoft account; desktop app availability is subscription-dependent.

1. State the question, such as “Which product category had the most sample sales?”
2. Check for blank IDs, duplicate records and inconsistent categories.
3. Summarize totals by category, then make a labeled chart if comparisons are easier to see visually.
4. Check that filters, formulas and date range include the intended rows.

Mini-project: Build a small inventory or sales report with a clean table, one SUMIFS calculation, one lookup (where supported), a category summary and a short note about what the sample does—and does not—show.

Revision: Clean columns first. Tables help sorting and expansion. Formulas start with =. Validate calculations and understand filtered totals before sharing.