I will build an excel attendance and fee tracker with an automatic dashboard
About this Gig
Still tracking attendance and fees in a notebook or WhatsApp? I build Excel attendance and fee trackers for tuition centres, classes, clubs and small teams, with a dashboard that updates by itself.
WHAT I CAN BUILD
Student attendance and fee tracker: who was absent, who has not paid, and how much is still owed
Employee or member attendance sheet that flags low attendance
Task tracker with deadline warnings and a dashboard
Simple inventory or order log with totals
WHAT YOU GET
Clean .xlsx file, no macros, so no security warnings
Works in Excel 2016 and later, Windows and Mac
Dropdowns to stop typing mistakes
A built-in instruction sheet
You type in one or two sheets; everything else updates by itself
HOW IT WORKS
Step 1: Message me first with what you track today (a file or a photo is fine)
Step 2: I confirm the scope and the right package
Step 3: I build, you review, I revise
Sensitive data can be replaced with dummy values. Your file is used only for your order.
Platform:
Excel
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Forms
•
Pivot tables
•
Formulas
•
Dashboard
My Portfolio
FAQ
Will it work on my computer?
Yes. I build for Excel 2016 and later, on Windows and Mac, without macros, so there are no security warnings. Tell me your Excel version and I will test for it.
Can I add more rows, staff or students later?
Yes. Lists like categories, staff or classes live in a settings sheet you can edit, and the tracker has room to grow. Tell me how many records you expect.
Is my data safe?
Your file is used only for your order and is not shared. You can also send dummy data, and I build the structure so you can paste your real data in later.

