Excel Is Fun

Excel Magic Trick 1436

DESCRIPTION See how to use Excel 2016 to take a 900,000 row table and a 1,000,000 roe table and combine them into one in order to make a PivotTable Report. See how to use the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1429

DESCRIPTION See how to rank values in Power Query using an Index, the Group By feature and MIN Function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1423

DESCRIPTION Learn about the Power Query Function Number.ToText to use some Excel Custom Number Formatting and Power Query Custom Number Formatting to format numbers and convert then to text. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1422

DESCRIPTION Learn how to use the Power Query user interface and type M Code to quickly take all the items from an invoice and list them in a cell with a delimiter. The Data is [Read More >>>]

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