Download Excel File: https://excelisfun.net/files/EMT1847-...
Learn about how to count assembly line station times that are under 10 seconds using PivotTable, COUNTIFS function, GROUPBY function and Power Query.
Topics:
1. (00:00) Introduction
2. (00:06) Counting Assembly Line Post Times Less Than 10 Seconds
3. (00:43) COUNTIFS
4. (01:54) PivotTable with Helper Column
5. (02:57) GROUPBY Array Function
6. (04:05) Power Query
7. (05:22) Summary
8. (05:35) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #countifs #groupby #pivottable #powerquery #powerquerytutorial