Excel Is Fun

Excel Magic Trick 1360

February 10, 2018 0

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

Excel Is Fun

Excel Magic Trick 1359

February 7, 2018 0

DESCRIPTION Learn about the basics of the VLOOKUP Function and about Time Values in Excel. Topics in this video: (00:12) Introduction to goal of video (01:08) Build Lookup Table with Time Values/Time Categories (8 Equal […]

Excel Is Fun

Excel Magic Trick 1358

February 4, 2018 0

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

Excel Is Fun

Excel Magic Trick 1357

February 1, 2018 0

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

Excel Is Fun

Excel Magic Trick 1356

January 29, 2018 0

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

Excel Is Fun

Excel Magic Trick 1355

January 26, 2018 0

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

Excel Is Fun

Excel Magic Trick 1354

January 23, 2018 0

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

January 20, 2018 0

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

Excel Is Fun

Excel Magic Trick 1352

January 17, 2018 0

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

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