- Based on both the data sets, for the particular 48 data points, calculation of Min, Max Average and subset calculations be done.
- Third sheet with the data sheets and the necessary tables for the Bar, Pie and Scatter charts.
- Surface chart based on each 3 months of data.
- On the fix and flipping side, identify the properties, orignial cost, all additional costs and have a sale price fixed.
- Track the sales amount and calculate the profit.
- Additional features can be included to track the customers showing interest until the property deal gets closed.
- Additional charts and Smple line plots can be discussed.
- Have done similar calculations and graphing charts (Freelancer projects)
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Pl. go through my portfolio some of the highcompled projects done.