Excel Wizard for Financial Reporting
Budget: $30 – $250 AUD
I'm looking for an Excel expert who can assist with graphing and refining data.
Key Tasks:
- 1) A formula to compare 2 lists and pick the closest match cell from the alternative list;
2) Create sophisticated graphs, primarily Speedo and Bar charts, to visually represent financial data. These graphs need to pop and be dynamic. ie each month it can compare
Ideal Skills:
- Advanced Excel proficiency, particularly in top-level graphs.
- Experience in smart formulas that compare close but not exact match data
- Imagination. Graphs need to be visual and easy for non accountants to read and compare YTD Actuals v YTD budget v Full year Budget v Full year forecast.
Please include examples of similar projects you've completed in your proposal.
Key Tasks:
- 1) A formula to compare 2 lists and pick the closest match cell from the alternative list;
2) Create sophisticated graphs, primarily Speedo and Bar charts, to visually represent financial data. These graphs need to pop and be dynamic. ie each month it can compare
Ideal Skills:
- Advanced Excel proficiency, particularly in top-level graphs.
- Experience in smart formulas that compare close but not exact match data
- Imagination. Graphs need to be visual and easy for non accountants to read and compare YTD Actuals v YTD budget v Full year Budget v Full year forecast.
Please include examples of similar projects you've completed in your proposal.