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.

スキル: エクセル

さらに表示: do some advanced excel work for a financial spreadsheet, financial data excel spreadsheet, project financial evaluation excel spreadsheet, copying pasting excel spreadsheet excel spreadsheet, bank statement spreadsheet excel, copy paste spreadsheet excel websites, copy excel spreadsheet excel spreadsheet, copy pdf spreadsheet excel, copy spreadsheet excel, evaluation spreadsheet excel, import excel sql server 2005 using nhibernate, excel report mysql data using php, copy browser spreadsheet excel code, putting existing spreadsheet excel, setup voip site using asterisk, upload excel database sql server using, data excel workbook master workbook using vba, word spreadsheet excel, project status spreadsheet excel chart, financial spreadsheet building campaign

プロジェクトID: #12011848

アワード:

ksriniravi

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 もっと

$150 AUD 3日以内
(28レビュー)
4.5

この仕事に、11人のフリーランサーが、平均$142で入札しています。

Webxpert4u

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 もっと

$250 AUD 3日以内
(104件のレビュー)
6.7
P0L

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日以内
(113件のレビュー)
6.3
rengrish

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 もっと

$66 AUD 1日以内
(114件のレビュー)
5.7
$111 AUD 1日以内
(12件のレビュー)
3.8
AsadNisar77

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 もっと

$150 AUD 3日以内
(8件のレビュー)
3.5
ashoksharma1

A proposal has not yet been provided

$133 AUD 1日以内
(4件のレビュー)
3.0
RaviS1984

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 もっと

$30 AUD 3日以内
(0件のレビュー)
0.0
$155 AUD 3日以内
(0件のレビュー)
0.0
ostashek

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 もっと

$115 AUD 1日以内
(0件のレビュー)
0.0
daringlion

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日以内
(0件のレビュー)
0.0