MS Excel 365 Quick Assistance
Budget: $10 – $30 AUD
I am in immediate need of a proficient MS Excel expert with deep knowledge of Excel 365. The task at hand is quite specific:
- Create a auto generated text string part number (Col C) based on selected matrices (Col D-AA), Yes in field
- build the part number string from the text in the headings ColD3,AA3
- add a "+" between each selected option in the generated string (Col C)
- sample file included for task at hand
- if the options column is populated with "Yes" then add the text option to the generated string part number. two examples are in the sample supplied
- add drop down box per cell in the options matrix for "Yes" or blank.
The professional for this role ought to possess a substantial understanding of data manipulation and expertise in Excel string functions. The task requires promptness and efficiency since I am looking to have this completed as soon as possible. Your ability to deliver accurate work swiftly will be highly appreciated.
Ideal Skills:
- Expertise in MS Excel 365
- Proficient at handling string functions
- Quick and efficient
- Detail orientated
- Strong analytical skills
- Good communication skills
- Create a auto generated text string part number (Col C) based on selected matrices (Col D-AA), Yes in field
- build the part number string from the text in the headings ColD3,AA3
- add a "+" between each selected option in the generated string (Col C)
- sample file included for task at hand
- if the options column is populated with "Yes" then add the text option to the generated string part number. two examples are in the sample supplied
- add drop down box per cell in the options matrix for "Yes" or blank.
The professional for this role ought to possess a substantial understanding of data manipulation and expertise in Excel string functions. The task requires promptness and efficiency since I am looking to have this completed as soon as possible. Your ability to deliver accurate work swiftly will be highly appreciated.
Ideal Skills:
- Expertise in MS Excel 365
- Proficient at handling string functions
- Quick and efficient
- Detail orientated
- Strong analytical skills
- Good communication skills