Hire an Excel Expert
$10-30 AUD
Bezahlt bei Lieferung
- Recreate the Excel spreadsheet (shown below).
You are required to:
write relevant formulas for the sections highlighted in yellow
produce THREE graphs from the projections (two that MATCH the examples given and ONE of your choice
analyse the results and graphs as part of your responses to the queries listed
Note: The spreadsheet must demonstrate proficiency in using formulas: SUM, VLOOKUP, MIN, AVERAGE, MAX, INDEX/MATCH, PIVOT TABLE.
- The following layout is a suggestion only. Ensure your spreadsheet looks professional in layout and includes appropriate headings. It should be designed so that a non-technical user can understand it easily without needing verbal explanations.
- SUMMARISE the FORECASTS represented by the two graphs and the Pivot Table e.g. product growth/decline over the three years.
- Change the percentages in the Sensitivity Tables (i.e. Inflation/Deflation rates) to see the impact these have on the graphs and the Pivot Table.
- Produce one NEW graph of your choice that represents the changes (must be different to the other two graphs)
- Explain the impact the changes to percentages have had on the forecasts
, where it says HINT in the pink boxes above…. for the first one you need to use the INDEX/MATCH formula and for the second one you need to use VLOOKUP formula please.
Projekt-ID: #15229393
Über das Projekt
13 Freelancer bieten im Durchschnitt $29 für diesen Job
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. As you could see on my reviews I have experience with excel, formulas and designing then I will provide you all you are requir Mehr
Hi, I am CPA by qualification, having experience of more than 6 years in a reputed MNC as a Financial Analyst, having good knowledge in Accounting and well versed with various Accounting software. Regards Pooja shah
Dear I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas & graphs Relevant Skills Mehr
Hi I have experience in excel using formula (sumif, vlookup, countif, index, match). I understood your requirements. I can recreate the excel spreadsheets as per your requirements. Relevant Skills and Experience Exce Mehr
I have worked on pivot tables before so i can deliver it in 1 day Relevant Skills and Experience Iam proficient in excel and have worked on pivot tables before Proposed Milestones $25 AUD - First ill input the Mehr
I am Very expert In Data Entry Relevant Skills and Experience I am Very expert In Data Entry Stay tuned, I'm still working on this proposal.
Hi,your project descriptions have fully satisfied me that skills required fits my experience since its my daily practices.I'm willing to expertise my professionalism on your project. Relevant Skills and Experience exc Mehr