This simple Excel trick saves me hours on MIS reports 💡

Give it a try 👉 https://chandoo.org/wp/mandatory-trainings-are-we-doing-them-data-analysis-challenge-002/

Ever wondered how actual data analysis work looks like? In this video, let me show you behind curtains scenes of the kind of questions I get and how I answer them with Excel.

We are looking at two sets of data - training data & employee data and finding answers to questions about compliance.
Specifically,
1) How many employees have completed all mandatory trainings?
2) How many have done at least one mandatory training?
3) Who have not attempted any mandatory trainings?
4) Department-wise report

Learn how to use simple Excel formulas like COUNTIFS to elegantly answer business questions like this for MIS reports, dashboards and data analysis work.