Excel Is Fun

Excel Magic Trick 1475

DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1446

DESCRIPTION See how to use Power Query to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight [Read More >>>]

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