Explorar las categorías
Explora
Fiverr Pro
Español
$
USD
Parece que este servicio está en espera
I will make your excel worksheets user friendly
Stephen R
Acerca de este Servicio
When a single user creates an Excel worksheet, it can be very 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.
The service offered is to review existing worksheets with the objective of appropriate redesigning and modification to create a more professional Excel worksheet that is:
- logically structured
- automated
- error-free
- user-friendly
The service is divided into 3 categories:
- Basic- creation of flowcharts to describe dataflow
- Standard- recommendations for redesigning the worksheet
- Premium- implementation of the recommendations
Design modifications will include (where appropriate):
- Consistent formatting
- Full use of Cell Styles.
- Creation of Named Ranges and applying formula using Named Ranges rather than A1 notation.
- Automated navigation between flowcharts and Named Ranges.
- Creation of macros (inclusive of forms and classes).
- Identification of whether macros should be collated in addins.
- Creation of Excel structured tables and pivot tables.
The design modifications do not include database integration.
Conoce a Stephen R
Stephen R
- DeAustralia
- Miembro desdemay 2024
Idiomas
Inglés
Stephen Rayward has a diverse science, mathematics, engineering and software development background. Stephen has 40 years experience in Mathematical Modelling, Engineering and development of commercial and research software. He provides courses internationally with the most popular course series: Excel for Professionals. He is the pioneer of Excel Engineering which implies a well structured and logical approach towards using Excel and has published some 20 LinkedIn articles for the Excel Engineering newsletter. Stephen is well-known for his approachability, enthusiasm and considered views.
FAQ
Can I discuss the project before we start?
Absolutely, I will need to discuss issues such as what is the purpose of your Excel worksheet, where do you spend a lot of time doing manual changes, what are the user inputs.
What if I have many interconnected Excel worksheets?
The service is targeted towards a single Excel worksheet and dealing with multiple Excel worksheets as independent of each other. For inter-worksheet management you are referred to my Gig 'I will make your Excel workbook user friendly'.
Can I do a course which explains the Excel Engineering methodology?
Yes, you will need to message me.
I notice you have a gig on Workbook Redesign. How does this worksheet gig fit in with that?
The worksheet gig tidies up individual worksheets. The workbook gig focuses on inter-worksheet management. It is recommended that if you want to apply my methods to a complete workbook you purchase both gigs and start the workbook redesign gig first as this will affect worksheets.
What happens if I have multiple worksheets that are similar in structure? Do I have to pay for each worksheet?
No, I create a template worksheet that will be copied to create multiple worksheets. However, you may have to use the extra service to enable copying of the worksheet and yet retain the data.
