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
Recommended
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
Industries
Building & Construction
Computer Software