Create an Excel spreadsheet, dashboard or report

Delivery in
3 days

  • Views 20
  • 0

What you get with this Hourlie

I can create an Excel spreadsheet, dashboard or report using a data set you provide.

I have created numerous spreadsheets in Excel, both professionally as Head of Marketing at an international business school and personally. A well-constructed spreadsheet, where time has been invested into setting it up properly so that data can be manipulated to filter, sort and highlight the key information that is most important to you can save you a huge amount of time. Spreadsheets I have created, with functionalities listed in the next section, include annual budget and expenses, marketing plans, graphs for board reports and a dashboard which was pulled through to a PowerPoint presentation. If Excel isn't your thing, let me do the set-up for you.
My aim is to create a spreadsheet that calculates as much as possible automatically. Some of the features and functionality that I can include are:
☑ Tidy the structure of the data
☑ Use simple formulas (INDEX MATCH, VLOOKUP, INDIRECT, SUMIF, etc)
☑ Use more complex formulas, creating custom function combinations to produce the results you require
☑ Create a dashboard to highlight key figures (eg by highest value, upcoming date, etc)
☑ Graphs
☑ Strategic use of colour to illustrate ranges of values, using conditional formatting
☑ Data validation
☑ Arrays
☑ Automation
Your spreadsheet will be accurate, functional and efficient, saving you from adding up totals and sorting by date every week as you go about your work. You will be able to simply enter any new data, then view the dashboard or graph, which will automatically be updated. It will also look clean with a simple but effective layout, which I can design using my marketing background.
This Hourlie is suitable for small businesses and people who rely on Excel for keeping on top of tasks or data, but who want to focus on their actual role, rather than constantly updating a spreadsheet. A small number of the unlimited ideas for which this Hourlie could be used are:
☑ Attendance registers with absence threshold alerts
☑ Marketing plans, with week-by-week breakdowns and highlights/progress of due and upcoming actions
☑ Department budgets, with items attributed categories and budget forecasts
☑ Inventories
☑ Sales updates, to be displayed on a screen in the office

What the Seller needs to start the work

To get started, I require clear instructions about how you want me to utilise your data set and the functionalities that you would like included.