Forecasting, Planning & Budgeting Techniques With Excel

by Bristol Business College Claim Listing

This one day course offers hands-on training surrounding specific skills in Excel which help enhance forecasting and budgeting practices, as part of the management accounting function.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Bristol Business College Logo

img Duration

1 Day

Course Details

This one day course offers hands-on training surrounding specific skills in Excel which help enhance forecasting and budgeting practices, as part of the management accounting function.

 

Learning outcomes include obtaining a greater understanding of:

  • Forecasting, planning and budgeting as part of the management accounting function
  • Modern quantitative methods used for forecasting
  • ? Regression analysis
  • ? Time series analysis
  • ? Expected value calculations
  • Planning techniques
  • The deterministic approach
  • Optimisation using the Solver toolpak
  • The ‘What-if analysis’ and ‘Scenario Manager’
  • Working with ‘Data Tables’
  • ?Introduction to stochastic planning
  • Functions
  • Random number generator
  • Conditional/Error
  • Forecast/Slope/Intercept
  • Array
  • Budgeting
  • Producing budgets
  • Consolidation options
  • An introduction to Excel dashboards
  • Create a simple dashboard
  • Tips on how to present overview data on a front screen
  • Bristol Branch

    Engineers' House The Promenade Clifton Down, Bristol

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy