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