Excel data analysis report sample for business teams

An Excel data analysis report sample should show the complete path from a business question to a checked answer and an assigned action. The example below explains why a fictional US services company's revenue increased while gross margin declined. It includes the source rows, formulas, reconciliations and the wording a manager could use in a review.

Start with a question that changes a decision

The question is: Did growth from July to September preserve gross margin, and where should management investigate? The audience is the finance manager and operating leads. The period is July through September 2026, with the same segment definitions and direct-cost policy throughout.

This is a question about gross profit after direct costs. The file contains no overhead, interest or taxes, so the report cannot claim a change in operating or net profit. Use the gross profit margin method when you need the detailed cost-definition checks behind that distinction.

Before calculating anything, write the report's scope: selected business, selected months, USD only, and complete monthly summaries for the Enterprise and Midmarket segments. If a real export excludes an operating unit, say that next to the result rather than hiding it in a workbook note.

The source records and workbook layout

All records below are synthetic. One row represents one month and segment, with revenue and the direct costs matched to it. Copy the table into A1:D7, keeping the field names as shown.

Convert A1:D7 to a table with headers using Microsoft's documented table workflow. Keep the raw source separate from the report summary. In a company workbook, retain the export date, reporting cutoff and source report name so another reviewer can select the same records.

Add GrossProfitUSD in E1 and GrossMargin in F1. Fill these formulas from row 2 through row 7:

=C2-D2
=IF(C2=0,"",E2/C2)

The blank result for zero revenue means the ratio is undefined. It should prompt review rather than become a zero-margin claim. If you need a fuller practice table with a dictionary and independently stated controls, use the synthetic Excel dataset.

Produce the checked summary

Put July, August and September in H2:H4. Calculate monthly revenue in I2 and direct costs in J2, then copy down:

=SUMIFS($C$2:$C$7,$A$2:$A$7,H2)
=SUMIFS($D$2:$D$7,$A$2:$A$7,H2)

Microsoft's SUMIFS documentation defines the sum range and criteria ranges used here. Gross profit in K2 is =I2-J2; margin in L2 is =IF(I2=0,"",K2/I2). Keep full precision during calculation and show percentages to two decimal places.

Quarter margin is 345,500 / 990,000 = 34.90%, rounded. Divide the quarter's summed dollars rather than averaging monthly percentages.

The movement calculations use July as the comparison base:

Calculate the margin change from unrounded ratios. Subtracting rounded display values can introduce a small discrepancy. The Excel analysis workflow covers preparation before the report stage.

Reconcile the result and locate the movement

Group the same six source rows by segment. This produces a second view of the quarter, rather than additional activity to append to the monthly figures.

Both views must agree with the source totals. The identity also holds: $990,000 minus $644,500 equals $345,500. In a live report, tie the export totals to the relevant source control as well; these internal ties cannot detect a whole missing business unit.

Enterprise margin is 40.00% in every month: its gross profit divided by revenue is unchanged. Midmarket moves from $30,000 / $100,000 = 30.00% in July to $24,000 / $120,000 = 20.00% in September. That locates the margin deterioration in Midmarket. It does not establish whether the cause was service mix, purchasing rates, delivery hours or an accounting error.

A report summary the manager can use

The action follows the evidence: investigate the affected costs before making a larger commitment. It does not assume that cutting a specific expense will restore margin. If the summary needs a visual, use the Excel chart selection guide to match the chart to the decision.

Change one input and rewrite the conclusion

Suppose a review finds that September Midmarket direct costs should be $84,000 rather than $96,000. Treat this as a hypothetical correction to one input; revenue and all other costs remain unchanged.

The $12,000 reduction raises gross profit by $12,000. September margin now matches July's unrounded ratio. The revised conclusion is that growth preserved margin across those endpoints; the original deterioration was dependent on the cost input. In a real report, document and approve a correction before replacing the original result.

Where reports go wrong

• Comparing different scopes. A new segment or changed cost classification can make a movement look operational when the definition changed.
• Skipping the source tie. A polished summary can still omit records or include a subtotal twice.
• Confusing percent with percentage points. A margin difference subtracts ratios; revenue growth divides a dollar change by the prior-period dollars.
• Presenting a hypothesis as a finding. The source locates the change, but a causal explanation needs supporting records.
• Leaving the action unowned. A finding without a responsible person and a review point rarely changes the next decision.

Covirage is not affiliated with Microsoft.

Build the report from your own file in Covirage

Bring a sample of your own Excel export with periods, segments, revenue and matched costs. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your workbook.

See Excel analysis with Covirage for the file-based approach.