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.

Dovednosti: Excel

Zobrazit více: 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

O zaměstnavateli:
( 1 recenze ) Australia

IČ projektu: #12011848

Uděleno uživateli:


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 Více

$150 AUD za 3 dní
(28 recenzí)

11 freelancerů učinili na tento projekt nabídku v průměrné výši $142


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 Více

$250 AUD za 3 dní
(104 recenzí)

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 za 3 dní
(113 recenzí)

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 Více

$66 AUD za 1 den
(114 recenzí)
$111 AUD za 1 den
(12 recenzí)

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 Více

$150 AUD za 3 dní
(8 recenzí)

A proposal has not yet been provided

$133 AUD za 1 den
(4 recenzí)

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]

$155 AUD za 3 dní
(0 recenzí)

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 Více

$115 AUD za 1 den
(0 recenzí)
$155 AUD za 3 dní
(0 recenzí)

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 Více

$30 AUD za 3 dní
(0 recenzí)