進行中

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.

スキル: エクセル

さらに表示: 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

採用者について:
( 1件のレビュー ) Australia

プロジェクト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
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
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
$155 AUD 3日以内
(0件のレビュー)
0.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