Excel Is Fun

Excel Magic Trick 1340

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1339

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1338

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1337

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1336

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1335

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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1334

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1333

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1332

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1331

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 [Read More >>>]