Projects using Microsoft Excel in Seattle
Projects using Microsoft Excel in Seattle
Sign Up
Post a job
Sign Up
Log In
Filters
2
Projects
People
2
Joy Z
This was a small project for a SaaS startup to review the raw data, and generate a financial report. There were some known data anomalies and the goal of the project was to discover the extent of those data issues and how it impacted the reported financials. In my deliverables, I provided a report of the income statement and headcount summary, with formulas built in to allow the user to toggle between different countries, or display the holistic income statement of all countries. I also provided a quick report of what was observed in the current financials, the data anomalies, and what to realistically expect in the financials if we adjusted for those anomalies.
1
2
25
0
Esrael Elala
Creative development
0
15
0
Zoe Ugaitafa
Data Product Manager & Project Leader
0
1
0
Lenara Litmanovich
Psychometric Evaluation of Achievement Program
0
3
0
Nick Blaha
Copywriting & Cataloging For Automotive Parts Distributor
0
12
0
Esrael Elala
Creative direction
0
7
0
Nicholas Canfield
Retool App For Medical Insurance Billing
0
13
22
Joy Z
Excel model: 5-year forecast for new facility I created a pro forma to forecast the financial impact of building a new healthcare facility. In the model, I built in dynamic levers to account for changes in operations, such as staff, number of available rooms in the building, and changes to state policy affecting revenue drivers. Model was built to be driver-based such that key drivers lived in their own tabs, and fed to primary summary pages for exec review. Figures have been randomized in attached pictures with names removed to maintain confidentiality.
22
180
0
George Bonnin
Financial Modeling & Dashboards
0
0
0
Joy Z
Salary and Benefits budget for grant tracking The goal was to build a spreadsheet that tracked all expenses on a grant budget, the salary and benefits being the most complex. The challenge was capturing all employees' varying start/end dates at varying amounts, and designed in a digestible way for non-finance users to understand. The spreadsheet needed to also account for one-off stipend amounts that didn't align to regular budget cycles. Figures have been randomized in attached pictures with names removed to maintain confidentiality.
0
22
Explore projects
