Please note javascript is required for full website functionality.

Introduction to Forecasting

Inside + Hindsight = Foresight

Howoftenhaveyoulookedbackwiththebenefitofhindsightandwishedyouknewthenwhatyouknownow? Aimedatallfinanceprofessionalsinvolvedinthebudgengandforecasngprocess,thissessiondiscusses howyoucanreducetherisksinyourforward-lookingdecision-makingbyulisingourkitbagofqualitaveand quantaveps,toolsandtechniques. Hands

Hands-on Modelling

Thispraccalsessionprovidesanintroducontothe analysisthatcanbebuiltintoforecasngandbudgeng developedinspreadsheets.Usingsimplestascaltools andanoverviewofsomeofExcel’sli­le-knownfuncons andfunconalies,thisseminarwillprovidea­endees withapragmacapproachtoenhancetheefficiencyand effecvenessoftheirforecasng. Excel base

Excel Base Examples

Thiscoursewillshowparticipantshowtoimproveforecastingtechniques,usingsanitisedreal-worldexamples, toturnhistoricaldataintofuturemanagement information. 

Key Benefits

Thissessionwill:

  • Provideapraccalunderstandingof Excel’sdataforecasngandcharng funcons
  • Quanfytherisksandrewardsof esmangfutureassumponsand outputs
  • Exploredifferentforecasngand trendingmethods
  • Equipa­endeeswithseveralwaysto confirmandopmisekeyoutputs. Programm

Programme Outline

  • Createformulabaseddataforecasts
  • Regressionanalysis
  • Biasanderroresmaon
  • Scenariomodelling
  • Creangawaterfallchart
  • Creangatornado(sensivity)chart
  • Calculatingandgraphingmoving averages
  • Definingandsolvingproblems:e.g. GoalSeekversusSolver.

Who Should Attend

ThissessionwouldsuitexperiencedExcelusers,financialanalysts,managementaccountantsandother professionalswhohavevestedinterestsinforecastingtrendsatthestrategic,tactical,operationaland planninglevels. 

Newsletter