I will build an excel attendance and fee tracker with an automatic dashboard

Malaysia

I speak Malay, English

Excel Tracker and Dashboard Builder

I build practical Excel tools for small businesses, tuition centres and office teams: fee trackers, attendance sheets, task trackers and one-screen dashboards. 10+ years working with Excel and data, M...
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