Storytelling with data has now surpassed every other form of hotel business communication. From analysts to administrative assistants, Excel is now by far the most popular platform for intelligence discovery and dissemination.
This course is not for Excel beginners. It is for Excel users who know the basics but need to master the process of manipulating tables of data to create advanced reports and analysis. It is the only course available that uses real PMS data to teach Excel tools and techniques.
Specifically designed for hotel professionals who want to master the next level of Excel skills.
Learn how to turn data files or extracts from any hotel system into valuable information. In this unique course you will learn by watching the instructor actually perform every operation step-by-step using PMS/POS data and real-life hotel examples. Learn to extract insights that lead to innovative plans and brilliant decisions. Create reports that impress and get you noticed.
Completing this unique training right now are:
Accounting & Finance Managers | Controllers | Revenue Managers | Auditors
F&B Analysts | Consultants | Sales Managers | Receivables/Purchasing Analysts | Operations Analysts
$249.00 $74.00Add to cart
6 Hours of pre-recorded, on-demand video | Self-Paced | Downloadable Excel Templates
No Time Limit | Lifetime Availability | No exams | Certificate of Completion
Transforming Raw Data – Importing PMS/POS/GL exports – Error Functions – Text Functions – Join and Logic Functions – Date Functions Rounding Functions
Great Spreadsheet Design – Data Validation – Conditional Formatting – Macros Security – Spreadsheet Reports Design Do’s and Don’ts
Granular Analysis of Data – Criteria Functions – Nested Functions – Lookup Functions – Array Formulas – Creating Advanced Formulas
Pivot Tables and Charts – Table Multisort – Multi-dimension and OLAP – Creating Pivot Tables – Pivot Table Calculations – Pivot Charts
Working with Raw Data – Relational Data – Creating Data Tables – Manipulating Data Tables – Excel Table Referencing – The IF function
Bringing PMS/POS Data into Excel – Working across Excel files – Get live data from a database – Get data from the web – Get data from an Excel file – Automating data retrieval
Robert Hernandez is an expert in the field of mathematical Hotel Optimization and Analytics. He has spent the last 17 years building data-driven forecasting and optimization models for companies in over 20 different industries, from tech to tourism. Robert possesses a very unique skill set including cross-disciplinary experience, advanced mathematical and analytics skills, data transformation, industry-specific knowledge and business-process improvement expertise. Robert began his career at the Walt Disney Company in Revenue Planning. Read More+
Sorry to interrupt your reading, but if you give us your email address, whenever we write something useful about Revenue Management, Pricing, Marketing, or Hotel Analytics, you'll receive a notice in your inbox.