This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or no AI help on this one.

Mandatory Training at Awesome Chocolates

You are the head of L&D department at Awesome Chocolates. As part of employee induction, every new hire at Awesome Chocolates must complete these 3 trainings:

• CM101 – Chocolate Making – 101
• CC101 – Cookies vs Chocolates
• EAT101 – How to truly savor a chocolate

You were given a spreadsheet with 2 tables of data (download it here).

1) All the new joiners since 1 Jan 2026 (table name: staff)

2) All the training done by your staff since 1 Jan 2026 (table name: trainings)

Based on these two tables, please answer below 3 questions.

Question 1: How many employees have completed all the mandatory trainings?

Find out the total number of employees (started on or after 1 Jan 2026) who completed all 3 mandatory trainings? A mandatory training is considered to be completed only if the employee passes the final assessment.

Question 2: How many employees have completed at least one mandatory training?

Find out the total number of employees (started on or after 1 Jan 2026) who completed at least one mandatory training? A mandatory training is considered to be completed only if the employee passes the final assessment.

Question 3: How many employees have not attempted any of the mandatory trainings? Who are they?

Find out the total number of employees (started on or after 1 Jan 2026) who have not attempted at least one mandatory training? List all such employee ids & names. A mandatory training is attempted if the employee starts the course (irrespective of pass / fail).

Bonus Question: List training completion rates by department

Generate a summary table that shows department name, total head count of new starters, how many have done all the mandatory trainings, percentage of completion (done count / headcount).

Post your answers on the homework page or reply back to me with your answers.

All the best ?

Download the sample data file

Click here to download the sample data file. It contains the data, answer key (so you can check if your answer is right or wrong) but not the solution.

Don’t struggle, Gain Excel Skills

If you struggle with solving business questions like this using Excel formulas or pivots, my Excel School program is the perfect fit for you.

It is designed to give you confidence and right skills so you can efficiently solve business problems, build proven Excel solutions and be a rock star at work.

Click here to Check out the program.

Solution & Explanation: in my Excel School

I will be including a quick & elegant solution for these questions along with clear explanation in my Excel School program next week. You can access it along with 20+ hours of amazing spreadsheet skills content when you enroll in the program.

Want more challenges? Check out the homework page.

The post Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Original source: https://chandoo.org/wp/mandatory-trainings-are-we-doing-them-data-analysis-challenge-002/