Excel Is Fun

Excel Magic Trick 1415

DESCRIPTION See how to use Power Query to Lookup and Return Multiple Items And Join Them In Single Cell. Learn how to Group by Rows and use the Text.Combine Function. Learn how to use the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1414

DESCRIPTION See how to Convert 35 & 100 to 00-035 & 00-100 using Power Query, a Custom Column and the Text.PadStart Power Query Function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1412

DESCRIPTION See how to use Power Query to Merge Two Tables into a Single Table, Load as a Connection Only and then build a PivotTable based on the New Merged Table saved as a connection [Read More >>>]

Excel Is Fun

Excel Magic Trick 1411

DESCRIPTION See how to add the prefix “00-“ to a column of Account Numbers using Transform, Text Column, Format, Add Prefix feature in Power Query (Get and Transform). Convert Number Account Numbers to Text Account [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 23

DESCRIPTION In this video learn about a free download called Power BI Desktop that is a single program that does all that Excel’s Power Query & Power Pivot can do, and more. Comprehensive example of [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 22

DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 21

DESCRIPTION In this video learn about how to import multiple Excel files using Power Query (Get & Transform): (00:15) Introduction (01:32) Files used for Import (02:46) Multiple Excel Workbooks with Multiple Sheets (03:50) Get “City” [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 20

DESCRIPTION In this video learn about: (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including [Read More >>>]

Excel Is Fun

Excel Magic Trick 1392

DESCRIPTION See how to perform Case Sensitive Unique Count with Power Query: (00:15) Introduction and examples of Remove Duplicates ans Data Model PivotTable Disnict Count Function will not perform Case Sensitive Unique Count. (01:34) Case [Read More >>>]

Excel Is Fun

Excel Magic Trick 1386

DESCRIPTION Using Power Query (or Query in Power BI Desktop) see how to Import Big Data Text File & Append to Bottom of Data Model Fact Table. We use Excel Power Pivot Data Model in [Read More >>>]