Automate Management Report Generation - Excel to PPT for Graphs and Financial Analysis - repost
$30-250 CAD
Zamknięte
Opublikowano ponad 10 lat temu
$30-250 CAD
Płatne 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.
Hi, I can do it. Please send a sample excel file with master raw data and all charts you need with detail description how do you like to filter required data for a certain chart. I will check and possible can provide a demo. What is your office version?
Best regards,
Cuong
I can jump on this and get it done straight away for you. I am new to Freelancer and looking for the opportunity from you to start. I am having more than 10 years of experience in analytic and excel. I can complete your work on or less said time. Looking forward for your response. Thank you.