Excel Is Fun

Excel Magic Trick 1366

DESCRIPTION Full Lesson on Power BI Desktop to build Product Analysis for Gross Profit with Average, Standard Deviation, Coefficient of Variation and Histogram Calculations and Visualizations: (00:04) Files to download (00:12) Introduction (04:42) Import Related [Read More >>>]

Excel Is Fun

Excel Magic Trick 1360

DESCRIPTION See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1358

DESCRIPTION See an example of how to invoke Query Dependencies View in Power Query (Get & Transform) WORKBOOKS

Excel Is Fun

Excel Magic Trick 1357

DESCRIPTION Goal: Unpivot and Clean Cross Tabulated Tables in multiple Excel Workbook Files and Create a Single Proper Data Set. Create a Power Query Function to repeatedly perform the Clean & Transform Task across many [Read More >>>]

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