Excel Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 >>>]