Automate Management Report Generation - Excel to PPT for Graphs and Financial Analysis

Anulowany Opublikowano Aug 14, 2013 Płatność przy odbiorze
Anulowany Płatność przy odbiorze

I want to be able to export financial data (i.e. Income statement, balance sheet, prior year financials, prior month financials, year to date, production volume data, labour hours data etc) into excel and have it auto generate certain pre-defined graphs. Then I would like this spreadsheet linked to a Powerpoint template, which can simply be updated to reflect the updated financials. This is pretty straightforward, and I actually already do this, but it requires a lot of wasted time modifying cells which could be easily auto populated if I were to setup the spreadsheet correctly with a master data tab that I export the data to.

The part I would need expertise on is:

Allowing me to use multiple pre-defined graphs or even power point templates via an drop down in excel. I.e. Be able to input all the raw data from an export into the spread sheet, but be able to select how I want to see the data, and have a different graph show depending on what i selected.

i.e. Revenue

- Be able to show bar graph with CURRENT MONTH, PRIOR MONTH, PRIOR YEAR MONTH, QUARTER, YTD

OR maybe next month I only want to see the revenue graph with CURRENT MONTH, PRIOR MONTH and 2 MONTHS PRIOR on one chart.

The point is I do not want to have to select the data range and modify the graph every time I want to see different data represented. This is probably a lot more complex.

The key to all of this, is that I want it to be flexible enough that I can input ANY company's financials into the spreadsheet and have it generate graphs and the power point. Then I can make minor changes in the power point as far as what slides I want to include.

Księgowość Excel Projekty graficzne Powerpoint Visual Basic

Numer ID Projektu: #4826563

O projekcie

12 ofert Zdalny projekt Aktywny Aug 16, 2013

12 freelancerów złożyło ofertę za $992 w tym projekcie

javed1705

please check pm

$1315 CAD w ciągu 3 dni
(490 Oceny)
7.7
cgullapalli

Please check PM. I have skill u r looking for.

$888 CAD w ciągu 3 dni
(771 Oceny)
7.8
priyal1997

Dear Sir/Madam. I'm happy to help you on this. Please check PM for more details. Thanks - Priyal

$1000 CAD w ciągu 10 dni
(226 Oceny)
6.8
caabdul

Dear sir, your requirements are a bit complex but I think I can help, thank you

$750 CAD w ciągu 3 dni
(126 Oceny)
6.7
mrbrave

Hi...I have great experience in developing tools to integrate different office applications.

$842 CAD w ciągu 10 dni
(234 Oceny)
6.6
pkcyber

See existing reporting application developed by me in your PMB. We believe we are reporting experts and can give u 100% results in this domain, so you can start this project with confidence on us. Thanks and Keenl Więcej

$1000 CAD w ciągu 3 dni
(32 Oceny)
5.6
dynamiccreator

ready to start with you

$1111 CAD w ciągu 3 dni
(38 Oceny)
5.1
duksmth

I am very interested in your project. Please do check pm for more details.

$750 CAD w ciągu 7 dni
(28 Oceny)
4.6
muhammadusmaneu

I would love to do this project. Hire me.

$1500 CAD w ciągu 7 dni
(25 Oceny)
4.8
jal540

I am a native English speaker (rated English Level 3) in the U.S. with extensive experience in developing custom applications for Excel and other Microsoft Office products.

$1000 CAD w ciągu 21 dni
(14 Oceny)
4.8
drevak

Hi. I am a professional VBA developer and Business Analyst. I can really help you.

$1000 CAD w ciągu 10 dni
(15 Oceny)
4.6
logoDS761

I am very experienced for this job

$750 CAD w ciągu 7 dni
(6 Oceny)
3.3