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

Excel Is Fun

Excel Magic Trick 1330

DESCRIPTION See how to use the Power Query Function Excel.CurrentWorkbook function to get all Tables in an Excel Workbook into a Single Table (How To Append All Tables in Current Workbook): (00:20) Introduction to Excel.CurrentWorkbook [Read More >>>]

Excel Is Fun

Excel Magic Trick 1329

DESCRIPTION See how to Clean a data set and then add with two criteria using SUMIFS function and Wildcards with the criteria or Power Query and Group By feature: (00:14) Introduction (01:44) SUMIFS function and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1328

DESCRIPTION See how to: (00:17) Introduction to Formulas for Counting and Adding with Case Sensitive Criteria (00:55) Power Query (Get & Transform) and Converting Proper Data Set to an Excel Table (01:38) Excel Filtering is [Read More >>>]