Sales Spreadsheet Cleanup & Dashboard (Sample)

Sales Spreadsheet Cleanup & Reporting Dashboard

SAMPLE PROJECT | FICTIONAL DATA | NOT PAID CLIENT WORK

This independent demonstration transforms a synthetic small-business transaction export into a clean, formula-driven Excel workbook with a reporting dashboard.

The sample contains 48 fictional orders. Inconsistent product categories and sales channels are standardized, revenue and direct costs are calculated, and category summaries feed a concise dashboard. The workbook includes raw data, cleaned records, dashboard, and documentation.

Quality checks include reconciling dashboard totals to the transaction table, checking formulas, and documenting refund handling and assumptions. Contribution is a simplified measure, not accounting profit.

Created using AI-assisted spreadsheet production and formula verification. All figures are invented. No employer, client, or confidential information is used.