Setup Excel Spreadsheet for Financial Projections

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.

Készségek: Excel

További információ: financial data excel spreadsheet, bank statement spreadsheet excel, copy pdf spreadsheet excel, copy spreadsheet excel, evaluation spreadsheet excel, putting existing spreadsheet excel, word spreadsheet excel, financial spreadsheet building campaign

A munkaadóról:
( 1 értékelés ) Australia

Projektazonosító: #12011848



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 Bővebben

$150 AUD 3 napon belül
(28 értékelés)

11 szabadúszó tett, átlagosan $142 összegű árajánlatot erre a projektre.


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 Bővebben

$250 AUD 3 napon belül
(104 értékelé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.

$250 AUD 3 napon belül
(113 értékelés)

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 Bővebben

$66 AUD 1 napon belül
(114 értékelés)
$111 AUD 1 napon belül
(12 értékelés)

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 Bővebben

$150 AUD 3 napon belül
(8 értékelés)

A proposal has not yet been provided

$133 AUD 1 napon belül
(4 értékelés)

I have a good knowledge on this field and I can give my best so you can trust me and give me the job.Thanks

$155 AUD 3 napon belül
(0 értékelés)

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 Bővebben

$115 AUD 1 napon belül
(0 értékelés)
$155 AUD 3 napon belül
(0 értékelés)

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 Bővebben

$30 AUD 3 napon belül
(0 értékelés)