Count Number Products Battle: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533

Download Excel Start Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1533Start.xlsx
Download Excel Finished Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1533Finished.xlsx In this video compare five methods to count how many products are in a column.
Topic:
(00:05) Introduction
1. (01:25) Excel Spreadsheet Function: COUNTIFS
2. (03:23) Excel Standard PivotTable
3. (04:47) Power Query: Group By feature
4. (07:23) DAX Functional Language of Excel Power Pivot & Power BI DAX: COUNTROWS
5. (11:08) Office 365 Dynamic Array Functions: UNIQUE & COUNTIFS
(14:40) Summary
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *