I have a small business, that gives me the sales for each day of the week. I want an excel spreadsheet that will enable me to use this information more effectively.
Currently I have three years of sales data, and I want to be able to have it setup so that this information can be used to show weekly comparisons, daily comparisons, YTD figures etc, as well as things like a 6 week average per day of the week.
I already have made a sheet that does this myself, but it is not done efficiently and involves lots of long-winding ways of calculating information etc. I need someone who can streamline this sheet, and make it easy to put in future data as well.
The sheet I am using now is attached, as you can see, it mostly works, but is not high quality, especially when presenting to my boss, and want it a bit simpler to use and update. At the moment I manually put the weekly data into the "data" tab and it spits out the rest, but thinks like the graphs don't update without a lot of work every 12 months.
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 Mai multe
11 freelancers are bidding on average $142 for this job
Hello, I can easily create excel sheet to maintain your financails Projections. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside Mai multe
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 have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. Please ping back to discuss the requirements , so that I can propose solution. Why i should be Hired ? I have very Mai multe
Hi Dear Client… I just read your project descriptions and understood all of your requirements. I just read your project descriptions and felt confident to do your work perfectly. I am an experienced freelancer and a Mai multe
I have a good knowledge on this field and I can give my best so you can trust me and give me the [url removed, login to view]
Hello, I am an Excel guru. I will help you with this in a fast and accurate manner. In fact I will also give you some hints on how you could improve this reporting, make it more appealing visually, etc. And of cours Mai multe
Hello, I have been in the field of Data Analytics for more than 8 years with solid Analytics experience of more than 9 years. I have deep understanding of Data Analytics and an Economics degree from a premier Universit Mai multe