Intro to Revenue Management

The aim of this course is to develop an understanding of Excel to support Revenue Management strategies and how to apply them in your business. The course covers; excel navigation and functionality, report creation, functions and formulae, pivot reports and macros.

Excel Navigation and Functionality
Delegates will initially explore the functionality of Excel and the key menu’s including:
- Insert (Tables, Charts, Graphs, Headers and Objects)
- Page Layout (Margins, Orientation, Themes)
- Data (Importing and Exporting, Sorting, Filtering, Validation, Cleaning Data)
- View (Screen views, Window Selection)

Report Writing
During this module, delegates understand the basic fundamentals of creating reports. Topics include:
- Sourcing Data
- Report Layouts
- Manipulating data and formatting

Functions and Formulae in Excel
Excel is pre-built with hundreds of formulae making data analysis simple. Topics include:
- Number formatting (Dates, Currencies, Day of Week)
- Lookup Data
- Group data
- IF statements

Pivot Reports and Macros
Delegates will learn how to simplify thousands of pieces of data into useable reports using Pivot Tables and Macros. Topics include:
- Creating Pivot Tables
- Table Options and Formats
- Inserting Formulae
- Charts and Graphs
- Recording and Editing Macros
- Using buttons and boxes

A Case Study
Delegates will be required to demonstrate their new skills by creating a report using data provided.

Who is this course for?

Anyone who uses Excel to analyse data and write reports.

Price
£225 + VAT - 1 day