EXERCISE: LEAVE REGISTER

Please purchase the course before starting the lesson.

1.     This is the leave register for a company with the leave taken by each employee over a year period.

a.     Create a pivot table that will show, by employee name the leave type taken, the month taken and how many total days and work days

b.     Sort in descending order based on working days.

2. Create another pivot table with the leave records

a.     Determine the AVERAGE leave taken, split by Annual versus Sick leave, by month to determine if there is a trend.

To see the full course contents click here.

 

Back to: Advanced Excel Course > Pivot Tables