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 1470

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period by subtracting [Read More >>>]

Excel Is Fun

Office 2016 37

DESCRIPTION Topics in this Video: (00:01) Introduction to Power Query and the examples in this video (02:50) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016 (04:32) Example #1: [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 1441

DESCRIPTION In this video see how to use an Left Anti Join in Power Query to Extract Items in List 1 that are NOT in List 2. WORKBOOKS

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