Take Excel Data and Sort into Categories/Add Statistics
- or -
Post a project like this2885
£10/hr(approx. $13/hr)
- Posted:
- Proposals: 22
- Remote
- #1142393
- Awarded
Lead Generation,Data Analysis,Data Visualization,Dashboard,LinkedIn Leads,Market Research,MS Excel,Google sheets,Web Research,CRM/CMS,Google Ads,PPC
Bay Minette
Excel Expert, Excel Automation, Database Modeling, Financial Modeling, Spreadsheet Design, Excel Customization, Data Parsing Specialist
Kingston
TOP CERT Virtual Assistant, Data Analyst, Proofreader, Excel, Word and PowerPoint Trainer
Swindon
4893917239895968884938752649443720361516342247281422208270
Description
Experience Level: Entry
Description of excel work: I have a basic Excel workbook for support tickets. It has the headings:
Date Status Customer User Device serial number Issue Comments Proposed Action to Resolve Issue Completed Action
I would like to add Category and Subcategory and select from a dropdown list of issues. For example, Hardware, Stolen.
In addition I need a chart or graph to show the total tickets per week/month output to a separate worksheet that updates automatically. For example:
April 2016
Hardware Stolen 10
Software Password 5
It should be easy for me to add/remove new categories or subcategories.
Extra notes:
Date Status Customer User Device serial number Issue Comments Proposed Action to Resolve Issue Completed Action
I would like to add Category and Subcategory and select from a dropdown list of issues. For example, Hardware, Stolen.
In addition I need a chart or graph to show the total tickets per week/month output to a separate worksheet that updates automatically. For example:
April 2016
Hardware Stolen 10
Software Password 5
It should be easy for me to add/remove new categories or subcategories.
Extra notes:
Craig R.
0% (0)Projects Completed
3
Freelancers worked with
3
Projects awarded
100%
Last project
23 Aug 2018
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