This course is designed to provide skills necessary to cover data analysis, reporting and communication of revenue results using Excel. The workshop covers how to create formulas and how to analyze data using Excel toolbox functions, graphs and Pivot tables, and explores use of different functions to support data analysis and decision making in forecasting and rate selection. Communication of revenue results is supported through conditional formatting, graphs and dynamic tables.
Usage of Excel for Revenue Managers
Some Common & Basic Functions
Conditional & Logical Functions
Managers and Executives in Rooms Division, Sales and Marketing and General Management with the responsibility of optimizing revenues and integrating it throughout the company
Hotel professionals looking at improving their revenue management and distribution knowledge and skills