Download File:
Start File: https://excelisfun.net/files/EMT1420StartFile.xlsx
Finished File: https://excelisfun.net/files/EMT1420FinishedFile.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/
See how to connect to an SQL Database, Append an Excel Table to the SQL Imported Data, Group By to add Total Units for each Product, then Sort, Grouping, Indexes and Custom Columns to Rank Total Product Units:
1. (00:14) Introduction of whole project
2. (01:29) Connect to an SQL Database that contains over 7 million records
3. (02:47) Import Excel Table
4. (03:25) Append an Excel Table to the SQL Imported Data
5. (04:06) Group By feature to add Total Units for each Product
6. (05:01) Sort, Grouping, Indexes and Custom Columns to Rank Total Product Units
7. (11:54) Change Data and Refresh
8. (12:30) Summary
Related Videos:
Excel Magic Trick 1417: Excel Functions Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer
Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns