### Excel Magic Trick 1340

October 20, 2017

DESCRIPTION See how to create expandable range in an Excel Table as part of a COUNTIFS formula that calculates a running count of names as there are entered into the table: (00:12) Introduction (00:35) Example […]

### Excel Magic Trick 1339

October 19, 2017

DESCRIPTION See how to use a Formula, Power Query, or Custom List to create the Alphabet A – Z: (00:14) Introduction (00:26) What are ASCII Characters? (00:26) Formula with ROWS and CHAR functions, and ASCII […]

### Excel Magic Trick 1338

October 18, 2017

DESCRIPTION See 2 Examples of how to use Power Query to Convert 12 Individual Cross Tabulated Tables into One Proper Data Set: (00:15) Introduction (01:14) Example 1: Start with 12 Cross Tabulated Excel Tables (Tables […]

### Excel Magic Trick 1337

October 17, 2017

DESCRIPTION If you try to make X-Y Scatter Chart from PivotTable is will NOT work!!!!! See how to use Power Query to create the same output as a PivotTable in order to make an X-Y […]

### Excel Magic Trick 1336

October 16, 2017

DESCRIPTION See how to use Import 10 Text Files and Append (combine) then into a single Proper Data Set before making a PivotTable Report. Compare and Contrast whether we should use Connection Only or Data […]

### Excel Magic Trick 1335

October 13, 2017

DESCRIPTION In Power Query see how to use deal with the Refresh Error Message: We couldn’t refresh the connection. Here is the error message we got: [DataSource.NotFound] File or Folder: We couldn’t find the folder. […]

### Excel Magic Trick 1334

October 12, 2017

DESCRIPTION See how to use Power Query (Get & Transform) and a set of Formulas to create a report that Adds Total Units for Each Product, Finds Max Units Sold for Each Product, and Lists […]

### Excel Magic Trick 1333

October 11, 2017

DESCRIPTION Learn about Banker’s Rounding or Gaussian Rounding: (00:15) What is Banker’s Rounding? (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding) (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and […]

### Excel Magic Trick 1332

October 10, 2017

DESCRIPTION See how to use Power BI Desktop to Import Multiple Excel Files & Build Dashboard (00:01) Introduction (01:40) Download Files (01:59) Download Power BI Desktop. Why would we need to do this if we […]

### Excel Magic Trick 1331

October 9, 2017

DESCRIPTION See how to use Power Query (Get & Transform) to import multiple Excel Workbook Files with Multiple Excel Sheets into a single Excel File in two different situations: (00:18) Introduction to Append Multiple Workbooks […]