Create a custom designed form and data entry system in MS Excel with summary charts.

Delivery in
5 days
Response time
within a day

  • Views 138
  • 0

What you get with this Hourlie

I have over 15 years Excel development experience working full time for a large services based organization in the UK, with clients including BT plc., city of London banking groups and the UK government. During this time I have worked as a MI specialist, service design / introduction project manager and business improvement manager using MS Excel as a primary tool for trialing new processes and delivering management information to clients and senior management.

I will design and develop a fully functional custom-designed form (maximum of 15 data fields), either to interface with an existing worksheet, or form a new worksheet to contain the data. This form will allow the addition of new records and the amendment of existing records as required. The form can be either an Excel 'Userform' or a separate work sheet. Also included in the basic hourlie are up to 4 charts providing summaries of the data stored.

Additional elements available for an additional charge are:
• Further charts & data analysis of the information stored
• Complex validation of the data entered into the form based on your rules
• Multiple data entry forms interfacing to multiple data sheets

I am very happy to discuss any specific requirements prior to an hourlie purchase, or to discuss any other requirements for MS Excel solutions.

I will build this to be compatible with MS Excel 2010 and newer.

See main portfolio for full sample of work

What the Seller needs to start the work

- Data fields to be included in the form
- Any logos/ color scheme preferences
- Validation requirements for entries , e.g letters only, numbers only.
- Description of requirements for the summary charts
- Copy of your workbook, if you require that I interface to an existing worksheet.