Looking for an experienced excel spreadsheet guru who is good with data calculations as well as visualization of data.
I work with clients in a marketing consulting capacity. Part of the role requires me to help my clients tease out key metrics that drive the scale / scope of their marketing efforts.
I have created a spreadsheet I use with my clients. Each section in the spreadsheet builds on the previous section resulting in outcomes such as leads required, max cost per lead, budget requirements etc.
This job requires the following:
1. To review each section and confirm that all the formulas / calculations are correct. Where not correct or data can be improved upon, suggest how and what formulas to use to improve the accuracy. I will provide context / specific details on what each section is and it's intended data outcome.
2. Suggest ways to improve how the data is visualized. This will not apply to all sections, but there are 2 in particular that may require some guidance there.
3. Again, more details will be provided on this project. Recommendations on how I can improve the spreadsheet (suggestions for additional useful data, calculations etc.) would be great, but not necessary. Hopefully it will be obvious to an expert in this area what else i can add to make the data more powerful (and accurate).
4. Ultimately this will be a secured web based tool hosted on my site. So, the person working on this will have to keep this in mind when refining.
Please feel free to ask any question.
Note: the budget fixed price is a best guess assuming a few hours of work for an experienced freelancer.