This simple Excel trick saves me hours on MIS reports 💡
By Chandoo
Community Score: 50% | 14.2K views | 3w
0 community ratings: null thumbs up, null thumbs down
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.
Tags: chandoo, chandoo.org, Excel, spreadsheets, advanced excel, excel tricks, excel tips, combine two tables in excel, merge two tables in excel, countifs, dynamic array formulas, countifs with spill range
More from Chandoo
- 20 AI Terms Explained in Plain English in 20 minutes 🕓 — Score: 50%
- Learn Advance Excel Formulas in an Hour - FREE Masterclass — Score: 50%
- 5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIs — Score: 50%
- End to End Power Query Data Cleaning Masterclass [FREE Workbook] — Score: 50%
- Here is why I think Excel skills are still relevant in the age of AI — Score: 50%
- How I easily deal with 100s of columns in Excel ~ PRO Trick💡 — Score: 50%