Learn how to display your data in chart form and then add trend lines using inbuilt analysis to project how data might appear in the future.
Key topics:
- Set up a worksheet to be used with the solver
- The creation of scenarios using the scenario manager
- The setup of a workbook to use goal seek to work out predefined ratios
- A demonstration of how regression analysis can be used with the FORECAST formula to make projections
Learning objectives
- Use the Goal Seek and Data Tables to calculate payment schedules for project based accounting
- Use Excel’s solver tool to calculate expected returns. Excel’s solver algorithm makes the calculations for you while generating a report to show workings
- Use Excel’s Scenario Manager to compare sensitivity analysis to outline the most suitable costing program
- Work through the detailed tasks accompanying the webinar to test your knowledge
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.
