Excel - Intermediate skills

Excel - Intermediate skills

Closed - This job posting has been filled.

Job Description

Overview:

Our client is a quick service restaurant concept that would like to have their various menu items categorized.



Object Challenge:

Our client is a franchisor and as a result had a lot of different franchisee’s that program their own Point of Sales systems. As a result, the naming convention and programming methods are not consistent.



Project:

We have broken up the data sources into over 200 different districts. Each district will have a set of product names along with the average retail price of the items



We will provide you with 10 districts at a time – and we believe each district will take no longer than 10 minutes to complete



We will also provide a master list that will tell you what menu item is being promoted in that district



--- That is the item that we need to find



Tasks:

1) find item to look up in Mast Item List Excel File

2) In Excel select a cell…then select the Data tab…the ‘Filter’

3) Then on the drop down arrow located in row 1 you will see an option for ‘Text Filters’ …select and then you can filter the items by searching for the name…or mostly a subset of the text



4) for example…if I’m looking for an item called ‘RIP’ N’ I might search for items the following ways in the ‘Text Filter’

a) ‘RIP’

b) ‘RIPN’

c) ‘RIP ‘N’

d ) rpn



5) If you do not find the item(s) that is OK…please make a note in the ‘Overview’ sheet and just indicate you have not found the item – we will go back to the client and as for more clarification…and then you will get it back once we have more info.

Open Attachment

Other open jobs by this client