Convert Excel into Pivot Table with Forecasts and Annual/Monthly/Daily Comparisons, Etc.
$30-250 USD
着払い
PLEASE READ FIRST.
ADVANCED EXPERTS ONLY
THIS PROJECT IS CONFIDENTIAL.
The attached Excel sheet provides a sample of the data entered into by employees of a restaurant. The attached sheet is blank, but the formulas and appearance are there for reference.
The data includes daily sales, inventory, ledger balance, number of transactions, etc. Please note that the calculations that the sheets produce is accurate. You will need to look at the formulas to understand how each field is calculated.
There are areas within the sheet that can be improved. We are only looking for someone to take that data, improve the functionality of the sheet, and present the data in a more usable form (on another sheet within the Workbook), such as with graphs, charts, etc.
We are looking for an expert to do this.
Potential areas of improvement (though I will ask that you provide additional suggestions):
1)The dates on the sheet end on 12/31/25 through the Subtotals function. This will need to be extended many years into the future.
2) The data is not currently charted or graphed in any way. Forecasts, an easy way to compare this month with the prior month, this month with the same month last year, or this day to the same day last year, etc. would be useful.
3) The chart is a little slow, which may be from the use of Subtotals.
4) Other areas of improvement that you identify.
5) It would be helpful to compare data between the two locations.
6) Filter the data, subtotal by various ranges and compare.
7) Generate reports based on the data.
8) Easily see % growth or decline in each of the categories.
9) Etc.
There are two locations, one location has about 6 years of data and the other has 3 years of data. I will provide the sheets with the fields completed upon project acceptance. I will also provide explanation for each column as needed.
This will likely be an ongoing project, as we find more uses for the Workbook.
Finally, the work must be clear and well documented.
プロジェクトID: #21337815
プロジェクトについて
アワード:
I am postgraduate (MBA) in finance with more than 6 years of experience in financial modeling, dynamic dashboards, graphs & charts, MIS reports, advanced excel based tools, VBA automation, google scripting and data pr もっと
50人のフリーランサーが、平均$164 で、この仕事に入札しています。
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl もっと
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.
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many もっと
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje もっと
Hi, I have understand the project requirement & interested to update current data file with dynamic report, chart and pivot as required for this project. Please send a message so we can discuss more & start the project もっと
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on もっと
Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with the visuals you are looking for. Most probably the solution that may fit your requirements will be a Power BI dashboard. Ple もっと
--- READ TO WORK -- Same field i have experiences.............................................................................
Hi Good Day! A serious freelancer here. I've done a lot of work like this one before. I suggest to create a automated tool using VBA macro to make it more efficient and use this tool for long term. I can help you wit もっと
Hi there. I have read and understood your project requirements. I understand that your need to create a pivot table with future projections. I am proficient in excel and VBA to deliver this work in two days. I am avail もっと
Hi, i am a data analyst expert using EXCEL for portfolio management and other applications. I understand your requirements for analysis and report. Will do it neatly in consultation with you
Hi there, I would like to discuss possible improvements and ask a few questions regarding this sheet. I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel repor もっと
HI! Im able to work in a draft version. Its important to keep it simple (i know restaurant Business), Sugestion, shoul add sales /Dept. in case your final sales report it. REgards, Emiliano I am a entrepenour ( ex- もっと
Hello, I have very good knowledge of MS Excel such as formulas (sumifs, vlookup, and, average, concatenate, countifs, iserror, match, min, max, mid, left, offset and many more), charts, data analysis, calculation, diff もっと
Hi, I am ready to start right away. I have done many similar projects like this and have vast experience of working with formulas and pivot charts.. I have reviewed your job description as well and very confident to ha もっと
1)The dates on the sheet end on 12/31/25 through the Subtotals function. This will need to be extended many years into the future. 2) The data is not currently charted or graphed in any way. Forecasts, an easy way to c もっと