Excel - Intermediate skills

Closed - This job posting has been filled and work has been completed.
Admin Support Data Entry Posted 1 year ago

Hourly Job

As Needed
Less than 1 week
$$

Intermediate Level

I am looking for a mix of experience and value

Details

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.


About the Client

(4.59) 22 reviews

United States
Charlotte 05:49 AM

105 Jobs Posted
35% Hire Rate, 3 Open Jobs

$5,295 Total Spent
43 Hires, 12 Active

$17.55/hr Avg Hourly Rate Paid
285 Hours

Member Since Feb 18, 2013