This workbook investigates the popularity of training classes within a given period of time, by class days and attendance.

Worksheets

This workbook has the following worksheets:

• By Class Days

• By Attendance

By Class Days Worksheet

This worksheet enables you to investigate the popularity of training classes by ranking them by class days.

Business Questions

Which are the most popular classes by class days?

Which classes could be most profitable?

Parameters

You need to specify values for the following parameters:

• Class From Date

• Class To Date

Headings and Calculations

This worksheet contains the following column:

• Free Seats

  Values in this column are based on the Maximum Attendees minus Student Count. The calculation takes into account the number of canceled internal students as well as the number of canceled external students.

By Attendance Worksheet

This worksheet enables you to analyze the popularity of training classes by ranking them by course attendance.

Business Questions

Which are the most popular classes by attendance?

Which classes are in high demand?

Parameters

You need to specify values for the following parameters:

• Class From Date

• Class To Date

Headings and Calculations

This worksheet contains the following column:

• Free Seats

  Values in this column are based on the Maximum Attendees minus Student Count. The calculation takes into account the number of canceled internal students as well as the number of canceled external students.