### Excel Magic Trick 1356

DESCRIPTION See how to lookup 3 Items & Return to Single Cell with a Cell Helper Column or Power Query: (00:15) Introduction (01:19) Cell Helper Column in Lookup Table solution. Trick thanks to Ian Putt [Read More >>>]

### Excel Magic Trick 1355

DESCRIPTION See how to extract records from a vertical column that contains Parent Names in Bold and Children Names in “Not Bold” and display parent and children records horizontally. Learn about the GET.CELL Excel 4 [Read More >>>]

### Excel Magic Trick 1354

DESCRIPTION See how to use RANK.EQ and COUNTIFS functions to create formula to Rank with Two Criteria / Conditions to Rank Football Teams by Total Wins & Division Wins. WORKBOOKS

### Excel Magic Trick 1353

DESCRIPTION See how to use the Power Query (Get & Transform) Inner Join Merge Feature to Extract Records (Data) from an Excel Table based on Criteria from cells in an Excel sheet (Criteria in a [Read More >>>]

### Excel Magic Trick 1352

DESCRIPTION See how to create a formula that simultaneously looks up 3 item, joins then together in a single cell in order to produce a system code for CompanyName/PlantZipCode/. See 4 formula methods, including timing [Read More >>>]

### Excel Magic Trick 1351

DESCRIPTION Using Power Query (Get & Transform), see how to Import & Merge Text & Excel Files, Clean Data, Add Helper Columns for Company Name and Revenue, and add a Total Row & Slicer for [Read More >>>]

### Excel Magic Trick 1350

DESCRIPTION Learn how to create formulas to make calculations in a Standard PivotTable. See how to Create a PivotTable Report with PivotTable Formulas for Year, Product & Region with Total Cost Of Goods Sold, Total [Read More >>>]

### Excel Magic Trick 1349

DESCRIPTION See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: (00:15) Introduction including Preview of Finished Solution [Read More >>>]

### Excel Magic Trick 1348

DESCRIPTION See how to look up multiple items, retrieve the number associated with the items and add the array of numbers. Examples of SUM Many VLOOKUPs: (00:10) Introduction (01:00) Exact Math Lookup for Adding Multiple [Read More >>>]

### Excel Magic Trick 1347

DESCRIPTION See how to create a Power Query (Get & Transform) Custom Function with a parameter in order to create five Sub Tables, one for each product, each on a new sheet, from a Master [Read More >>>]