Freelancers using Microsoft PowerPoint in SeattleFreelancers using Microsoft PowerPoint in Seattle
ProjectsPeople
Joy Z's avatar
Joy Z
Seattle, USA
I turn messy spreadsheets into insight-driven tools.
New to Contra
I turn messy spreadsheets into insight-driven tools.
Cover image for This was a small project for a SaaS startup to review the ra...
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
Cover image for GTM enablement on customer value props slide deck At this st...
GTM enablement on customer value props slide deck At this startup, the goal was to educate the sales and marketing team on how customers were getting value out of the platform. I created 30+ slides (one for each customer) on their "before" and "after" states, collaborating with the CS team and directly with customers to get this data. I set up the Google Sheets deck in a templatized way to streamline the process when adding new customers to the deck. Data and info has been obfuscated in attached pictures to maintain confidentiality.
10
111
Cover image for Excel model: 5-year forecast for new facility I created a pr...
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
Cover image for Salary and Benefits budget for grant tracking The goal was t...
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
Microsoft PowerPoint(1)
Lunar Lemonade Creative's avatar
Lunar Lemonade Creative
Seattle, USA
Websites for Healers & Wellness Practitioners
Websites for Healers & Wellness Practitioners
Cover image for Academic or Medical Research Poster Design (PowerPoint)
Academic or Medical Research Poster Design (PowerPoint)
0
3
Cover image for Squarespace Website for Optometrist (Spec)
Squarespace Website for Optometrist (Spec)
0
2
Cover image for Canva Designs (Website Spec)
Canva Designs (Website Spec)
0
2
Placeholder project card media
View more →
Microsoft PowerPoint(1)
George Bonnin's avatar
George Bonnin
Seattle, USA
Real estate strategy, workplace ops & financial modeling.
Real estate strategy, workplace ops & financial modeling.
Cover image for Slide Decks
Slide Decks
0
0
Cover image for Real Estate Management
Real Estate Management
0
0
Cover image for Business Process Modeling
Business Process Modeling
0
0
Cover image for Financial Modeling & Dashboards
Financial Modeling & Dashboards
0
0
Microsoft PowerPoint(1)