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 1359

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