IHG酒店集团风险管理计划

1、文档来源为 :从网络收集整理 .word 版本可编辑 .欢迎下载支持 .WelcomeWelcome to this delegate information guide for the Introduction to Risk Management Workshop.This pack contains the information we talk about during the session it can be used as a reference guide as we progress through the session.The contents of this sessi

2、on are detailed belowContentsPageSession objectives2The Risk Management Action Plan2What needs to covered in the plan2Basic Excel CommandsAuto Filter3Basic Excel CommandsHeader & Footer5Basic Excel Commands Moving & copying Data (Cut & Paste)7Please also see the example Risk Management Action Plan1文

3、档来源为 :从网络收集整理 .word 版本可编辑 .欢迎下载支持 .Session four, RISK MANAGEMENT Action PlanBy the end of this session you will be able to:-Describe what the plan is and why we use itExplain at least three basic excel commands to customise your plan Define both good and bad entries into the plan and explain why tha

4、t isExplain how you use the plan to prepare for your RISK MANAGEMENT meetings at Hotel, AGM and DOO levelThe Risk Management Action PlanThe RISK MANAGEMENT Action Plan is an Excel Workbook designed to house all the RISK MANAGEMENT issues in your hotel. It is a working document and is used by the RIS

5、K MANAGEMENT committee monthly when they review :-New issues being added to the planProgress on completion of action pointsCompleted action pointsIt is also used by the Regional team toEnsure RISK MANAGEMENT issues are being addressed (RISK MANAGEMENT Calendar points)Track progress on completion of

6、ItemsIdentify common themesIdentify common training needsEnsure funds are budgeted to address emerging risksThe RISK MANAGEMENT action Plan will :-Have unique identification numbers allocated to each issue / riskHave all RISK MANAGEMENT issues / risks the hotel faces listedHave issues / risks correc

7、tly ratedHave issues correctly datedHave issues correctly categorised by risk typeHave deadlines set which reflect the risk ratingHave named individuals allocated for each actionEnsure that the Planned Actions adequately address the issues / risksAssist in ensuring all Departments take responsibilit

8、y for their issuesEnsure operational issues are addressed effectively by the hotelAssist in raising owner issues effectively with the OwnersAssist in ensuring owners face their responsibilitiesHave Capital / P&L issues identified with actionHave completed actions suitably archivedBe used by Area and

9、 Regional representatives?2文档来源为 :从网络收集整理 .word 版本可编辑 .欢迎下载支持 .Customising your Action Plan by using basic excel commandsAbout filteringFiltering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria you specify for a

10、column. Microsoft Excel provides two commands for filtering lists:1AutoFilter , which includes filter by selection, for simple criteria2Advanced Filter , for more complex criteriaFor our RISK MANAGEMENT Action Plan we will only use the Auto Filter optionSee fig 1Unlike sorting, filtering does not re

11、arrange a list. Filtering temporarily hides rows you do not want displayed. See fig 2When Excel filters rows, you can edit, format, chart, and print your list subset without rearranging or moving it.Auto Filter Fig 13文档来源为 :从网络收集整理 .word 版本可编辑 .欢迎下载支持 .Fig 2Below we can see we have selected column G

12、 areas in the hotel from the drop down box we have chosen Public Areas, now Excel hides all other rows and only shows us the PublicArea information. This can be repeated by all the areas in the Hotel, so each department head can receive his or her own list of action points. You can filter one column

13、 heading fromeach column. For example you could choose to see only Capex issues in the Kitchen or only items with a risk rating of 6 etc.To return to the full list simply go to data, filter, and auto filter switching the filter command off. You can see if the auto filter command is on by a tick to t

14、he left of the words Auto Filter in the pick box. If there is no tick the command is switched off.4文档来源为 :从网络收集整理 .word 版本可编辑 .欢迎下载支持 .About headers and footersHeaders and footers are areas in the top and bottom margins of each page in a document.You can insert text or graphics in headers and footer

15、s for example, page numbers, thedate, a company logo, the documents title or file name, or the authors name that are printed at the top or bottom of each page in a document.You can work in the header and footer areas by clickingHeaderandFooteron theViewmenu. See Fig 3Fig 35文档来源为 :从网络收集整理 .word 版本可编辑

16、 .欢迎下载支持 .About Print area1On the View menu, clickPage Break Preview.Select the area you want to print.3On the File menu, point toPrint Area, and then clickSet Print Area. See Fig 4When you save the document, your print area selection is also saved.Fig 46文档来源为 :从网络收集整理 .word 版本可编辑 .欢迎下载支持 .About mov

17、ing and copying dataWhen you copy a cell by dragging or by clicking copies the entire cell, including formulas formats.Cut or Copy , and Paste , Microsoft Excel and their resulting values, comments, and cellThere are no hidden cells in the RISK MANAGEMENT action plan. However, if the selectedcopy ar

18、ea includes hidden cells, Excel also copies the hidden cells. If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of thecopied cells.Once an action point has been completed youCut the entire row from the Action Plan sheetto the completed actions sheet, clicking on the row number to the left of the column A