Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552

About this tutorial: Video duration: 22:45 Download Excel Finished Files: Entire page with all Excel Files for All Videos: In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure. Learn about the Table.Sort […]

Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?

About this tutorial: Video duration: 7:35 Download Excel File: See how to find the min digit from a cell that contains a number with many digits: 1. Create a formula element that can extract characters from a cell (digits from a number in a cell) that uses the LEN, INDIRECT and MID functions with a […]

Excel Magic Trick 1005: Lookup nth Duplicate When Column With Lookup Value Is Not Sorted

About this tutorial: Video duration: 7:50 Download Excel File: See a formula that will Lookup nth Duplicate When Column With Lookup Value Is NOT Sorted and return a value from a different column. See two array formulas: 1. INDEX, SMALL, IF, ROW and ROWS functions in a lookup formula that requires Ctrl + Shift + […]

The Aggregate Function in Excel 2010

About this tutorial: Video duration: 4:41 Learn how to use some of the new Aggregate function’s 19 calculations and options to create a result that can exclude hidden rows, filtered rows, and cell errors. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and […]

Use the DSUM Function to show Sales Totals in your Microsoft Access Databases

In this tutorial, I will teach you how to use the aggregate function DSUM in Microsoft Access to add up all of the sales from the last 30 days and put that total in a text box on your Main Menu form for quick reference. DSUM is very similar to the DLOOKUP function that I’ve […]