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 ChocolatesYou 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 – 101CC101 – Cookies vs ChocolatesEAT101 – How to truly savor a chocolateYou 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 departmentGenerate 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 fileClick 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.Need a hint? (click to expand)+Don’t discount countifsConsider helper columnsor even link both tables via relationships so you can pivot your way to answersDon’t struggle, Gain Excel SkillsIf 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 SchoolI 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.