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 >>>]
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 >>>]
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 >>>]
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 >>>]
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
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 >>>]
DESCRIPTION See how to rank values in Power Query using an Index, the Group By feature and MIN Function. WORKBOOKS
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
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 >>>]
DESCRIPTION See how to get help for Power Query functions WORKBOOKS
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.