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 Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel.
I can complete your work to your fullest satisfaction. Looking forward to hearing a positive response from you.
Thanks in advance!
Have a Great Day!
Srinivasan Krishnamoorthi
$150 AUD w 3 dni
5,0 (28 opinii)
4,5
4,5
11 freelancerzy składają oferty o średniej wysokości $142 AUD dla tej pracy
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 good experience
100% accurate solution
100% Time compliance
Good Communication
I am sincere,honest and hardworking independent freelancer.
I give more importance to the job than $.
Please let me know your email id for ease of communication .
Thank You.
Regards,
Rishi
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 course, I will do that for you too.
Please stop wasting your time looking for the right, please hire me, and let's get it done!
Thanks,
Vlad.
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 University in India. I recently started freelancing as a hobby to gain more experience. However I take my job very seriously. Hope to work with you and gain some valuable experience. I am also an expert on MS Excel and VBA.
Regards,
Ravi