Inside + Hindsight = Foresight
Howoftenhaveyoulookedbackwiththebenefitofhindsightandwishedyouknewthenwhatyouknownow? Aimedatallfinanceprofessionalsinvolvedinthebudgengandforecasngprocess,thissessiondiscusses howyoucanreducetherisksinyourforward-lookingdecision-makingbyulisingourkitbagofqualitaveand quantaveps,toolsandtechniques. Hands
Hands-on Modelling
Thispraccalsessionprovidesanintroducontothe analysisthatcanbebuiltintoforecasngandbudgeng developedinspreadsheets.Usingsimplestascaltools andanoverviewofsomeofExcel’slile-knownfuncons andfunconalies,thisseminarwillprovideaendees withapragmacapproachtoenhancetheefficiencyand effecvenessoftheirforecasng. Excel base
Excel Base Examples
Thiscoursewillshowparticipantshowtoimproveforecastingtechniques,usingsanitisedreal-worldexamples, toturnhistoricaldataintofuturemanagement information.
Key Benefits
Thissessionwill:
- Provideapraccalunderstandingof Excel’sdataforecasngandcharng funcons
- Quanfytherisksandrewardsof esmangfutureassumponsand outputs
- Exploredifferentforecasngand trendingmethods
- Equipaendeeswithseveralwaysto 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.