I will build an excel workbook with formulas, reports and a dashboard
Full Stack Engineer, Python, TypeScript, Java, AI and Automation
About this Gig
Tired of a spreadsheet that breaks every time you add a row? I build Excel workbooks that run on formulas: you type into clearly marked input tables, and every total, report and chart updates by itself.
Typical projects:
- Business trackers: sales, expenses, inventory, orders, invoices
- Costing and P&L: recipe/product costing, margins, monthly P&L, cash flow
- Dashboards: KPIs and charts on one sheet
- Fixing an existing file: broken formulas, #REF errors, slow sheets, duplicate data
How I work:
- Input cells are highlighted, formulas are protected from accidental edits
- Real formulas you can read (SUMIFS, XLOOKUP, tables), no macros or VBA to break
- Before delivery I test it with sample data and check every total, so the file works the first time
- A short "How to use" sheet is included in the dashboard package
Send me your current file or a list of what you need to track, and I'll confirm the scope before you order. Google Sheets versions are available on request.
Platform:
Excel
•
Google Sheets
•
LibreOffice
Development technology:
Python
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Formulas
•
Dashboard
•
Charts
•
Data validation
My Portfolio
FAQ
Excel or Google Sheets?
Either. Tell me which; every formula is recalculated and checked, and the file is opened in Excel (web) or Google Sheets before delivery.
Do you use macros/VBA or Power Query?
No. I build formula-only workbooks: they work in any recent Excel and in Google Sheets, and nothing breaks when macros are blocked.
Can you work with my existing file?
Yes, that's the Basic package. Remove anything confidential first, or replace it with dummy numbers.

