Spreadsheets that think.
Every workbook here goes through the same pipeline I use for real financial reporting: raw data in, cleaning and formulas in the middle, an executive-ready report out. No screenshots — every number on this page is computed straight from the actual .xlsx files, which you can also download below.
1
Workbook
3.260
Rows analyzed
8+
Formula types
=SUMPRODUCT(CLEAN_DATA!J4:J1503)
Product Sales Region
End-to-end sales analysis workbook — raw data to executive report
Jan 2023 – Jun 20257 sheets664 KB
A 7-sheet sales analysis workbook built from 1,500 raw transactions: cleaning and feature engineering, a reference lookup table, a pivot analysis, a KPI dashboard, and a written executive report with prioritized business recommendations.
Rp4.379.992
Total Revenue
Jan 2023 – Jun 2025
1.500
Total Orders
transactions
Rp2.920
Avg Order Value
per transaction
15.616
Total Qty Sold
units
24.8%
Return Rate
372 of 1,500 orders
6.0 days
Avg Delivery
order to delivery
Product-Sales-Region.xlsxLive Preview
DownloadLoading Excel file...
Powered by Microsoft Office Online
Viewing actual .xlsx file via Microsoft Office Online • Download file
More Excel case studies get added here over time — village fund reports, reconciliation sheets, and budgeting models join this same page as they're finished.