Enhancements to an in-house data analysis tool
- or -
Post a project like this961
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 10
- Remote
- #3356333
- Awarded
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Data analyst (IBM SPSS/ R/ RStudio/ Power BI) |Excel Expert (Dashboard/ Macro/ VBA/ Power pivot)
Brisbane
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!
Mumbai
12644632082704722052210990264240630911063284930618586062391456257481
Description
Experience Level: Expert
We have a fairly simple Excel-based tracker of key events inside our company however there are three issues with it currently:
1) Date format of "Date Booked In" field is not being recognized as a date
2) Date format of "Date Booked For" field is being recognized as the incorrect date (it is mistaking the month for the day)
3) Requires a "copy and paste special values" as cannot do a vlookup based on a value which comes from a formula.
This tracker is an interim solution as we build our full analytics suite but nonetheless, it would be good to fix these issues properly as currently the values are having to be corrected manually
1) Date format of "Date Booked In" field is not being recognized as a date
2) Date format of "Date Booked For" field is being recognized as the incorrect date (it is mistaking the month for the day)
3) Requires a "copy and paste special values" as cannot do a vlookup based on a value which comes from a formula.
This tracker is an interim solution as we build our full analytics suite but nonetheless, it would be good to fix these issues properly as currently the values are having to be corrected manually
Thomas W.
100% (7)Projects Completed
4
Freelancers worked with
5
Projects awarded
20%
Last project
15 Sep 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies