This simple Excel trick saves me hours on MIS reports ๐Ÿ’ก @chandoo_
This simple Excel trick saves me hours on MIS reports ๐Ÿ’ก  @chandoo_
Uploaded May 2026 | Updated November 2026, 17 hours ago
Give it a try ๐Ÿ‘‰ 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.
This simple Excel trick saves me hours on MIS reports ๐Ÿ’กExcel Trick to Count UNIQUE Values in SecondsHow to automatically extract data from a messy PDF table to ExcelCool Excel Trick to Find Replace Multiple Words in one go ๐Ÿ‘ŒSummarize Filtered Values in Excel - Formula TrickAwesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)The Ultimate Excel Dashboard: Visualize Data Like a ProLearn 80% of DAX in an Hour (with FREE sample file)Learn Excel COPILOT in just 15 minutes and Work Smarter ๐ŸคฏHow to make a Show / Hide SLICER PANEL in Power BI ๐Ÿ’กMake a beautiful and interactive To-Do List with Excel (Easy Tutorial ๐Ÿ‘Œ)Power BI Ecosystem - Explained in 25 minutes
Chandoo |

This simple Excel trick saves me hours on MIS reports ๐Ÿ’ก

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER