Forecasting, Planning & Budgeting Techniques - with Excel (ICAS)

BPP Professional Education
Course summary
6 hours
390 GBP excl. VAT
Edinburgh, Online courses
Next available date: Online delivery option may be available - Please contact provider. - Online courses
Professional Training

Course description

Spreadsheet Skills for Better Forecasting & Budgeting (ICAS)

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.Learn how to enhance forecasting & budgeting practices, as part of the management accounting function (as above). Gain valuable practical guidance and hands-on training.

Suitability - Who should attend?

This course will benefit spreadsheet authors, managers, company advisers and other members of staff from all functional areas needing to further their Excel skills in developing departmental forecasts, plans or budgets. It is open to anyone wishing to gain more practical experience in Excel reporting and making use of statistical data.

Training Course Content

Modern quantitative methods used for forecastingRegression analysisTime series analysisExpected value calculationsPlanning techniquesThe deterministic approachOptimisation using the Solver toolpakThe 'What-if analysis' and 'Scenario Manager'Working with 'Data Tables'Introduction to stochastic planningFunctionsRandom number generatorConditional/ErrorForecast/Slope/InterceptArrayBudgetingProducing budgetsConsolidation optionsAn introduction to Excel dashboardsCreate a simple dashboardTips on how to present overview data on a front

Get Inspired! Watch the Video

About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Forecasting, Planning & Budgeting Techniques - with Excel (ICAS).

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number

Request information

Find out more about this Forecasting, Planning & Budgeting Techniques - with Excel (ICAS) course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here