《IHG酒店集团风险管理计划》由会员分享，可在线阅读，更多相关《IHG酒店集团风险管理计划（9页珍藏版）》请在金锄头文库上搜索。
1、WelcomeWelcometothisdelegateinformationguidefortheIntroductiontoRiskManagementWorkshop.Thispackcontainstheinformationwetalkaboutduringthesessionitcanbeusedasareferenceguideasweprogressthroughthesession.ThecontentsofthissessionaredetailedbelowContentsSessionobjectives2TheRiskManagementActionPlan2What
2、needstocoveredintheplan2BasicExcelCommands-AutoFilter3BasicExcelCommands-Header&Footer5BasicExcelCommands-Moving©ingData(Cut&Paste)7PleasealsoseetheexampleRiskManagementActionPlanSessionfour,RISKMANAGEMENTActionPlanBytheendofthissessionyouwillbeableto:-DescribewhattheplanisandwhyweuseitExplainat
3、leastthreebasicexcelcommandstocustomiseyourplanDefinebothgoodandbadentriesintotheplanandexplainwhythatisExplainhowyouusetheplantoprepareforyourRISKMANAGEMENTmeetingsatHotel,AGMandDOOlevelTheRiskManagementActionPlanTheRISKMANAGEMENTActionPlanisanExcelWorkbookdesignedtohousealltheRISKMANAGEMENTissuesi
4、nyourhotel.ItisaworkingdocumentandisusedbytheRISKMANAGEMENTcommitteemonthlywhentheyreview:-NewissuesbeingaddedtotheplanProgressoncompletionofactionpointsCompletedactionpointsItisalsousedbytheRegionalteamtoEnsureRISKMANAGEMENTissuesarebeingaddressed(RISKMANAGEMENTCalendarpoints)Trackprogressoncomplet
5、ionofItemsIdentifycommonthemesIdentifycommontrainingneedsEnsurefundsarebudgetedtoaddressemergingrisksTheRISKMANAGEMENTactionPlanwill:-Haveuniqueidentificationnumbersallocatedtoeachissue/riskHaveallRISKMANAGEMENTissues/risksthehotelfaceslistedHaveissues/riskscorrectlyratedHaveissuescorrectlydatedHave
6、issuescorrectlycategorisedbyrisktypeHavedeadlinessetwhichreflecttheriskratingHavenamedindividualsallocatedforeachactionEnsurethatthePlannedActionsadequatelyaddresstheissues/risksAssistinensuringallDepartmentstakeresponsibilityfortheirissuesEnsureoperationalissuesareaddressedeffectivelybythehotelAssi
7、stinraisingownerissueseffectivelywiththeOwnersAssistinensuringownersfacetheirresponsibilitiesHaveCapital/P&LissuesidentifiedwithactionHavecompletedactionssuitablyarchivedBeusedbyAreaandRegionalrepresentatives?CustomisingyourActionPlanbyusingbasicexcelcommandsAboutfilteringFilteringisaquickandeasyway
8、tofindandworkwithasubsetofdatainalist.Afilteredlistdisplaysonlytherowsthatmeetthecriteriayouspecifyforacolumn.MicrosoftExcelprovidestwocommandsforfilteringlists:1 AutoFilter,whichincludesfilterbyselection,forsimplecriteriaAdvaneedFilter,formorecomplexcriteriaWhenExcelfiltersrows,youcanedit,format,ch
9、art,andprintyourlistsubsetwithoutrearrangingormovingit.AutoFilterFig1Fig2BelowwecanseewehaveselectedcolumnGareasinthehotelfromthedropdownboxwehavechosenPublicAreas,nowExcelhidesallotherrowsandonlyshowsusthePublicAreainformation.ThiscanberepeatedbyalltheareasintheHotel,soeachdepartmentheadcanreceiveh
10、isorherownlistofactionpoints.Youcanfilteronecolumnheadingfromeachcolumn.ForexampleyoucouldchoosetoseeonlyCapexissuesintheKitchenoronlyitemswithariskratingof6etc.Toreturntothefulllistsimplygotodata,filter,andautofilterswitchingthefiltercommandoff.Youcanseeiftheautofiltercommandisonbyaticktotheleftoft
11、hewordsAutoFilterinthepickbox.Ifthereisnotickthecommandisswitchedoff.AboutheadersandfootersHeadersandfootersareareasinthetopandbottommarginsofeachpageinadocument.Youcaninserttextorgraphicsinheadersandfootersforexample,pagenumbers,theHeaderandFooterontheViewHeaderandFooterontheViewdate,acompanylogo,t
12、hedocumentstitleorfilename,ortheauthorsnamethatareprintedatthetoporbottomofeachpageinadocument.Youcanworkintheheaderandfooterareasbyclickingmenu.SeeFig3Fig3Fig3AboutPrintareaOntheViewmenu,clickPageBreakPreview.1 Selecttheareayouwanttoprint.2 OntheFilemenu,pointtoPrintArea,andthenclickSetPrintArea.Se
13、eFig4Whenyousavethedocument,yourprintareaselectionisalsosaved.Fig4AboutmovingandcopyingdataWhenyoucopyacellbydraggingorbyclickingCutorCopy,andPaste,MicrosoftExcelcopiestheentirecell,includingformulasandtheirresultingvalues,comments,andcellformats.TherearenohiddencellsintheRISKMANAGEMENTactionplan.Ho
14、wever,iftheselectedcopyareaincludeshiddencells,Excelalsocopiesthehiddencells.Ifthepasteareacontainshiddenrowsorcolumns,youmightneedtounhidethepasteareatoseeallofthecopiedcells.OnceanactionpointhasbeencompletedyouCuttheentirerowfromtheActionPlansheettothecompletedactionssheet,clickingontherownumbertotheleftofthecolumnAensurestheentirerowisselected-seeFig5Fig5NowthattherowhasbeenselectedgototheCompletedActionsPointssheet,selecttherowyouwishtopastetheinformationintoandclickpaste,seeFig6Fig6
