Microsoft Excel & Power BI Automation Sheet + Dashbaord

Starting at

$

250

About this service

Summary

I developed an automated budgeting system in Excel with a structured Master Budget sheet, PO Tracker, and Transactions log. The model calculates all financial metrics automatically, including spend, remaining budget, expenses, and upcoming due payments. I also designed a dynamic dashboard with KPIs and charts to visualize project budgets and spending trends, giving the client accurate and real-time financial visibility.

What's included

  • Automated Excel Sheets

    Used SUMIFS, COUNTIFS, AGGREGATE,PIVOT TABLES, and much more to link excel sheets and make the automated

  • Data Cleaning

    Accurate data and organized to be used for dashboards

  • Data Visualization

    used Power BI to Visualize the Data

Recommendations

(5.0)

Hassnaa Ouda • New Giza

Client • Dec 8, 2025

Mohamed is a great freelancer with professional communication skills. He helped in setting and optimizing ClickUp very professionally and even managed our projects within it. I would recommend him for any client.


Duration

3 days

Skills and tools

Data Analyst

Data Scientist

Data Visualizer

D3.js

D3.js

Matplotlib

Matplotlib

Tableau

Tableau

TensorFlow

TensorFlow

three.js

three.js

Industries

Building & Construction
Computer Software