Excel Is Fun

Excel Magic Trick 1351

January 14, 2018 0

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

Excel Is Fun

Excel Magic Trick 1349

January 8, 2018 0

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

Excel Is Fun

Excel Magic Trick 1347

January 2, 2018 0

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