I will create an excel tracker with formulas and a dashboard
About this Gig
Replace a confusing spreadsheet with a clear tracker for sales, expenses, inventory or project progress.
Basic includes one input sheet, one summary and up to 5 formula types. Standard includes up to 3 working sheets, 10 formula types and a dashboard with 2 charts. Premium includes up to 5 working sheets, 10 formula types, a dashboard with 4 charts and agreed validation rules.
A formula type is a distinct calculation pattern; filling the same formula down rows counts as one type. You receive the editable XLSX file and usage notes. I check agreed calculations using sample cases and inspect the layout.
Please supply anonymised sample data, required fields, expected calculations, row count and your Excel version before ordering. Macros, bank connections, external integrations, accounting certification and large data migrations are outside these packages. Google Sheets delivery requires a separate agreement so it can be checked in that format.
Platform:
Excel
Development technology:
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Charts
•
Data validation
FAQ
Does this include macros or live bank connections?
No. These packages cover an editable XLSX workbook using manually supplied data, formulas and the agreed layout. Macros and external integrations require a separate brief.
