I will create an excel tracker with formulas and a dashboard

South Africa

I speak English

Web Developer and Digital Tools Creator

I build practical websites and digital tools. My services include HTML, CSS and JavaScript fixes, responsive landing pages, Minecraft Skript commands and events, and Excel trackers. I work from a clea...
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