Identifier: 52409829

Duration:

Subscription Period: 365 Days

Language: English

Cost: AUD 62.00

 

Action

Add To Cart

Overview

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

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.

loading...