I will build a custom excel employee tracker with automation

Croatia

I speak English, Croatian
I am skilled in data cleaning, transformation, and visualization using Excel and Power BI. My focus is on helping businesses and individuals turn raw, unstructured data into clear, meaningful insights...
About this Gig

Managing data in Excel can quickly become time-consuming and confusing when done manually.


I will create a custom Excel tracker that saves you time, reduces manual working and gives you clear insights into your data. It can be used to track employee data, absences, tasks, or any type of structured information.


What I can build for you:

  • Custom Excel trackers (employee tracking, vacation tracking, task tracking...)
  • Automated calculations and smart data input
  • Data validation for clean and consistent data
  • Conditional formatting for better visibility
  • Summary tables and reports
  • Interactive dashboards


Example use cases:

  • Employee vacation and absence tracker
  • Task or project tracking
  • Simple reporting dashboards


Features used:

  • Excel formulas, data validation, conditional formatting, pivot tables, graphs, sheet protection, optional basic VBA automation


My goal is to build a solution that saves you time, reduces mistakes and manual work and gives you a clear overview of your data.

It is fully customizable to you business needs.


Feel free to contact me before ordering so I can understand your requirements and suggest the best solution.

Platform:

Excel

Google Sheets

Power BI

Development technology:

Power Query

Excel

Power BI

Expertise:

Formatting

Formulas

Functions

Dashboard

Data validation