WelcomeWelcometothisdelegateinformationguidefortheIntroductiontoRiskManagementWorkshop.Thispackcontainstheinformationwetalkaboutduringthesessionitcanbeusedasareferenceguideasweprogressthroughthesession.ThecontentsofthissessionaredetailedbelowContentsSessionobjectives2TheRiskManagementActionPlan2Whatneedstocoveredintheplan2BasicExcelCommands-AutoFilter3BasicExcelCommands-Header&Footer5BasicExcelCommands-Moving©ingData(Cut&Paste)7PleasealsoseetheexampleRiskManagementActionPlanSessionfour,RISKMANAGEMENTActionPlanBytheendofthissessionyouwillbeableto:-DescribewhattheplanisandwhyweuseitExplainatleastthreebasicexcelcommandstocustomiseyourplanDefinebothgoodandbadentriesintotheplanandexplainwhythatisExplainhowyouusetheplantoprepareforyourRISKMANAGEMENTmeetingsatHotel,AGMandDOOlevelTheRiskManagementActionPlanTheRISKMANAGEMENTActionPlanisanExcelWorkbookdesignedtohousealltheRISKMANAGEMENTissuesinyourhotel.ItisaworkingdocumentandisusedbytheRISKMANAGEMENTcommitteemonthlywhentheyreview:-NewissuesbeingaddedtotheplanProgressoncompletionofactionpointsCompletedactionpointsItisalsousedbytheRegionalteamtoEnsureRISKMANAGEMENTissuesarebeingaddressed(RISKMANAGEMENTCalendarpoints)TrackprogressoncompletionofItemsIdentifycommonthemesIdentifycommontrainingneedsEnsurefundsarebudgetedtoaddressemergingrisksTheRISKMANAGEMENTactionPlanwill:-Haveuniqueidentificationnumbersallocatedtoeachissue/riskHaveallRISKMANAGEMENTissues/risksthehotelfaceslistedHaveissues/riskscorrectlyratedHaveissuescorrectlydatedHaveissuescorrectlycategorisedbyrisktypeHavedeadlinessetwhichreflecttheriskratingHavenamedindividualsallocatedforeachactionEnsurethatthePlannedActionsadequatelyaddresstheissues/risksAssistinensuringallDepartmentstakeresponsibilityfortheirissuesEnsureoperationalissuesareaddressedeffectivelybythehotelAssistinraisingownerissueseffectivelywiththeOwnersAssistinensuringownersfacetheirresponsibilitiesHaveCapital/P&LissuesidentifiedwithactionHavecompletedactionssuitablyarchivedBeusedbyAreaandRegionalrepresentatives?CustomisingyourActionPlanbyusingbasicexcelcommandsAboutfilteringFilteringisaquickandeasywaytofindandworkwithasubsetofdatainalist.Afilteredlistdisplaysonlytherowsthatmeetthecriteriayouspecifyforacolumn.MicrosoftExcelprovidestwocommandsforfilteringlists:1 AutoFilter,whichincludesfilterbyselection,forsimplecriteriaAdvaneedFilter,formorecomplexcriteriaWhenExcelfiltersrows,youcanedit,format,chart,andprintyourlistsubsetwithoutrearrangingormovingit.AutoFilterFig1Fig2BelowwecanseewehaveselectedcolumnGareasinthehotelfromthedropdownboxwehavechosenPublicAreas,nowExcelhidesallotherrowsandonlyshowsusthePublicAreainformation.ThiscanberepeatedbyalltheareasintheHotel,soeachdepartmentheadcanreceivehisorherownlistofactionpoints.Youcanfilteronecolumnheadingfromeachcolumn.ForexampleyoucouldchoosetoseeonlyCapexissuesintheKitchenoronlyitemswithariskratingof6etc.Toreturntothefulllistsimplygotodata,filter,andautofilterswitchingthefiltercommandoff.YoucanseeiftheautofiltercommandisonbyaticktotheleftofthewordsAutoFilterinthepickbox.Ifthereisnotickthecommandisswitchedoff.AboutheadersandfootersHeadersandfootersareareasinthetopandbottommarginsofeachpageinadocument.Youcaninserttextorgraphicsinheadersandfootersforexample,pagenumbers,theHeaderandFooterontheViewHeaderandFooterontheViewdate,acompanylogo,thedocumentstitleorfilename,ortheauthorsnamethatareprintedatthetoporbottomofeachpageinadocument.Youcanworkintheheaderandfooterareasbyclickingmenu.SeeFig3Fig3Fig3AboutPrintareaOntheViewmenu,clickPageBreakPreview.1 Selecttheareayouwanttoprint.2 OntheFilemenu,pointtoPrintArea,andthenclickSetPrintArea.SeeFig4Whenyousavethedocument,yourprintareaselectionisalsosaved.Fig4AboutmovingandcopyingdataWhenyoucopyacellbydraggingorbyclickingCutorCopy,andPaste,MicrosoftExcelcopiestheentirecell,includingformulasandtheirresultingvalues,comments,andcellformats.TherearenohiddencellsintheRISKMANAGEMENTactionplan.However,iftheselectedcopyareaincludeshiddencells,Excelalsocopiesthehiddencells.Ifthepasteareacontainshiddenrowsorcolumns,youmightneedtounhidethepasteareatoseeallofthecopiedcells.OnceanactionpointhasbeencompletedyouCuttheentirerowfromtheActionPlansheettothecompletedactionssheet,clickingontherownumbertotheleftofthecolumnAensurestheentirerowisselected-seeFig5Fig5NowthattherowhasbeenselectedgototheCompletedActionsPointssheet,selecttherowyouwishtopastetheinformationintoandclickpaste,seeFig6Fig6