Excel - Intermediate skills

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


Hours to be determined
Less than 1 week

Intermediate Level

Start Date

December 24, 2013



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.


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


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.52) 39 reviews

United States
Charlotte 03:23 AM

132 Jobs Posted
38% Hire Rate, 1 Open Job

$7,204 Total Spent
63 Hires, 13 Active

$17.31/hr Avg Hourly Rate Paid
341 Hours

Member Since Feb 18, 2013