Create Excel Pivot Table and Chart
$10-30 USD
Pagado a la entrega
I have raw data that I get from our phone system. I would like to be able to display it to show the number of inbound calls we get each week. I think the correct way to do this is with a Pivot Table, but it doesn’t have to be done that way. The resulting Excel file will be one where I can use the “Change Data Source” and point it to any of the output files from our phone system and have it generate the table and chart shown as a sample screenshot attached. It does not have to be EXACTLY like my example, but this is the information I want to show.
NOTES ABOUT THE DESIRED EXCEL TABLE AND CHART (see [login to view URL]):
-The parts highlighted in Red must be included, I don’t care if the other columns are there or not.
-The data source may be one day or it may be a few years worth of data, the Excel table/chart that you build must be able to react properly to any quantity of data. You can set a limit of 3 years if that helps.
-For this purpose of this, weeks ENDS on Sunday. I have looked at the WEEKNUM function in Excel and this is possible.
-Even if a week has less than a full week’s of days, it should still be shown.
-Please use the week ending date on the chart’s X axis as I have shown in the screen shot (not week numbers).
-Weeks should be sorted Oldest to Newest (top to bottom in the table) and (Left to Right in the chart).
-Please include a trend line (shown in light blue on my sample).
NOTES ABOUT THE DATA FILES:
-FORMAT: They come from the phone system as CSV files. I would prefer to use them as CSV, but it doesn’t seem that Pivot Tables can use CSVs as a data source. If you can make it work with CSVs that is great, but if not, you can assume that I will open the CSV and save it as an XLSX. I will not make any other changes to the source data.
-FILTER: Only include records/rows that have they “Type” (column C) is equal to “Inbound Call”. If they are blank or say something else, do NOT include that row.
-FILTER: You should only include records/rows were the “Minutes” (column B) is greater than “1” (do not include 1).
-SAMPLES: I have attached 3 sample data files. One with 3 days of data, one with 2 months of data and one with 12 months of data. I have left these in the CSV format.
END.
Nº del proyecto: #13428483
Sobre el proyecto
Adjudicado a:
Hi there - My name is Manuel. I’ve read your brief and can see that you’d like to have an Excel file to analyze inbound calls. I am new in Freelancing, but I have more than 10 years designing Excel for data analysis on Más
38 freelancers están ofertando un promedio de $37 por este trabajo
Hi I am Excel Expert and VBA Programmer (for macros) I can create for you desirable worksheet If interested, contact me Thanks & Regards
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Más
Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this project. I handle microsoft excel very well and I can do this for you. I handle pivot tables and charts. Please contact me by chat Más
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I ha Más
I am much experience in Excel and SPSS data analysis, power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. I have Más
Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Más
Hello! Please send to me more details about this project and i'm ready to start work right now. Select me please.
My Pleasure to do your project. willing to start as soon as possible...i am a data encoder thats why i think i like working with sharp deadline but high quality data...
Dear Hiring Manager, I want to do your job/project now, let's start immediately. I have read the job description. I've been working in a BPO company for more than 13 years now. My job there honed my skills to be Más
I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interacti Más
Hi, I think I can help you in this project. I have 20 years in the development of Ms. Excel spreadsheets, including pivot tables, macros and VBA programming. I'll be glad to help. Best regards, José M.
-Expertise in Excel work. -High quality formating and 100% error free work can be expected. -Quick turn around time
Hello, My name is Alex and I am an experienced user Excel. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely ca Más
I have worked with Pivot Tables for more than 10 years and have even taught others. I can complete your project within 1-2 days max.
Your proposal is your first (and perhaps only) chance to make a good first impression to the employer!