I will make your excel workbook user friendly

Excel workbooks are often difficult for someone else to use. This is because it can be difficult to navigate, unclear as to what the user can modify, and may be highly manual and include errors.

This gig focuses on the workbook as a whole whereas a separate gig focuses on individual worksheets.

The service offered is to review your workbook with the objective of appropriate redesigning and modification to create a more professional Excel workbook that is:

• logically structured
• automated
• user-friendly.

I.e. identify whether: dataflow can be simplified and created macros can enable automation.

The service is divided into 3 categories:

• Basic - creation of flowcharts to describe dataflow
• Standard - recommendations for redesigning the workbook
• Premium - implementation of the recommendations

Design modifications will focus on inter-worksheet linkage (where appropriate):

1. Use of Cell Styles
2. Creation of Named Ranges and modifying formula using Named Ranges
3. Automated navigation between flowcharts and worksheets
4. Creation of macros (inclusive of forms and classes)
5. Creation of ribbon commands for macros
6. Collate macros into addins
7. Database integration.