Sample work · Data & Excel
Revenue Report in Excel: Six Months at a Glance
From 180 bookings of a bicycle workshop, this becomes an overview with monthly revenue, share by category, average receipt and a chart, all as traceable formulas.
Sample work, not a client job. The business and all figures are invented, so you can see what the work looks like before you order anything.
What is in the file
- Sheet “Daten” (data): 180 bookings with date, category, channel and amount
- Sheet “Kennzahlen” (key figures): revenue and bookings per month, average receipt, share per category, online share
- One chart, “Revenue per month”
- Sheet “Formeln” (formulas): the same key figures as formulas (SUMIFS, COUNTIFS) – enter new bookings and the report recalculates
Download the Excel file (.xlsx)
The downloadable workbook is the German original: sheet names and column headings are in German, the figures and formulas are the ones described here. For your own job it is built in your language.
How a job like this works
- You send your raw data, for example an export from your till, shop or accounting.
- I clean it up: duplicate rows, date formats, spelling of the categories.
- You get a workbook with data, key figures and charts that you can carry on yourself.
No software, no subscription: one file that works with Excel, LibreOffice or Google Sheets.
Something like this for your business?
Describe briefly what you need. You get a fixed price before I start; nothing happens without your yes.