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.
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.
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 Daha Fazla
Bu iş için 54 freelancer ortalamada $163 teklif veriyor
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 Daha Fazla
Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. I have just finished very similar project 6 hours ago. Everyone calls me "PRINCESS of Daha Fazla
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