Build your first monthly Excel report: a beginner workplace project

Define the question before opening a template

Imagine a fictional stationery shop wants to know which products generated revenue in September. Your deliverable is a spreadsheet and a one-page explanation. Write down the reporting period, currency, included transactions and treatment of cancelled orders before building anything. This makes the exercise useful for office assistants, operations teams and aspiring analysts alike.

Use fictional records for practice. Keep the original data on a separate sheet and work on a copy. Give your columns meaningful names: order ID, date, product, units and unit price. One transaction belongs on one row; avoid merged cells in the data table.

Check the inputs and calculate a result you can verify

Turn the working range into an Excel table. Check that dates are dates, prices are numbers and order IDs are not accidentally duplicated. A blank quantity is a question to investigate, rather than an automatic zero. Record the decision you make for each exception.

For a simple exercise, revenue is units multiplied by unit price. These figures deliberately exclude discounts, returns and taxes; add separate fields before using this approach in a real commercial report.

Fictional transactions: 10 notebooks × ₹80 = ₹800; 5 folders × ₹60 = ₹300; 4 notebooks × ₹80 = ₹320. Total revenue = ₹1,420. Notebook revenue = ₹1,120. Folder revenue = ₹300.

Summarise, then reconcile

Create a PivotTable with product as rows and revenue as the summed value. Compare its grand total with the revenue column total. Both should be ₹1,420 in this example. If the figures differ, look for an incomplete source range, filtered records, wrong aggregation or numbers stored as text.

Add a simple bar chart only after the totals agree. Label it “Revenue by product — fictional September sample” and include the currency. Three rows of practice data do not establish a business trend, so avoid forecasting demand from this example.

• Check one source transaction manually.
• Confirm the reporting period includes the intended dates.
• Add a new test row and refresh the summary.
• Keep an exception log beside your cleaned data.

Explain your work in a way an employer can follow

Write a short handover: what the report answers, how you calculated it and what you checked. A useful observation is “Notebooks account for ₹1,120 of the ₹1,420 sample revenue.” An unsupported conclusion is “The shop should stop selling folders.” Revenue alone does not establish profitability or customer demand.

Save a read-only presentation copy, a working spreadsheet and a brief README. In an interview, demonstrate one correction and explain why it mattered. If you are returning to work, this project can also refresh file organisation and communication alongside spreadsheet skills.

Progress to repeatable reporting

Once you can check this report confidently, practise lookup functions, conditional totals and Power Query with larger fictional files. Keep the same validation habits when the tools become more advanced. DigiOffice Pro connects these techniques with Word, PowerPoint and workplace collaboration, so the final outcome can be communicated as well as calculated.

Common questions