Personal Financial Analysis
Project details
Description
Problem Statement:
This project was developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.
Dataset Used:
In this dashboard, data is pulled from income and expense statements from January 2022 to July 2022, represented in 345 rows and 10 columns.
Tools Used: Utilized MS Excel to categorize income and expenditure reports into a detailed pivot table to develop an improved financial strategy that resulted in 15% savings. Administered IF, COUNTA, and VLOOKUP function to summarize and project monthly monetary inflows and outflows. Automated manual filter removal using macros and VBA to reduce budget preparation time by 5%.
Please refer to the Github Repository for this project "here"
-
Technology Used:
Excel, Git -
Status:
Completed -
Project:
Link