Excel Magic Trick 1457 Part 2: Regional Settings & Text or Number Date / Times in SUMIFS Function

About this tutorial: Video duration: 3:21 Download File: Entire page with all Excel Files for All Videos: In the English United States Regional Settings, SUMIFS seems to be recognizing Text and Number Dates as equivalent Criteria. But when we change the Reginal Settings, SUMIFS correctly interprets Text Dates and Number Dates as different. This Tip […]

4 Super Cool Tricks for MS Excel | Excel Magic Trick Part 13

About this tutorial: Video duration: 11:23 Doston is video me maine apko microsoft #Excel ki 4 #MagicalTricks ke baare me bataya hai jo apke liye bahut hi jyada useful hogi. Hope aap sabhi ko hamara ye video pasand aayega. ❤Show your LOVE by “ LIKE COMMENT & SHARE this video ” ❤Don’t forget to “SUBSCRIBE […]

Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard

About this tutorial: Video duration: 15:23 Download File: See how to use Power BI Desktop to Import Multiple Excel Files & Build Dashboard 1. (00:01) Introduction 2. (01:40) Download Files 3. (01:59) Download Power BI Desktop. Why would we need to do this if we have Excel? 4. (03:09) Import and transform many Excel Files […]

Excel Magic Trick 1315: Create A Unique Sorted List with Power Query

About this tutorial: Video duration: 4:16 Download File: See how to create a unique sorted list with Power Query.

Bestway to Unstack Excel Data from One Column to Multiple Column || MS Excel 2016 || My Live Support

About this tutorial: Video duration: 6:28 Download Practice File – Doston is video me maine apko bataya hai ki kis tarah aap #Excel me 1 Column me diye gaye #data ko #Multiple_Column me lekar ja sakte hai excel ki ek simple trick ka use karke. Hope apko video pasand aayega. ❤Show your LOVE by “ […]

Turn on Power View in Excel 2013 / 2016 for Windows (Excel Magic Trick 1362)

About this tutorial: Video duration: 2:24 Download File: See how to: 1. File, Options, Add-ins, Manage: select “Com Add-ins”, Click Go, Check Power View, OK 2. Right-click any Ribbon Tab, “Customize the Ribbon”, Add Group, Rename Group 3. With Group Selected, from Choose commands from dropdown select “Commands not in the Ribbon” 4. Select “Insert […]

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 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?

About this tutorial: Video duration: 11:35 Download File: 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 Model to store the data. 1. (00:18) Introduction & Look at Text Files […]

Import Power Pivot Data Model into Power BI Desktop (Excel Magic Trick 1365)

About this tutorial: Video duration: 3:36 Download File: See how to import an Excel Power Pivot Data Model with tables, relationships and DAX Measures into Power BI Desktop using the File (Upper Left icon), Import, Excel Workbook option in Power BI Desktop. Incoming search terms:mike girvin from power query to power bi magic trick

Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot

About this tutorial: Video duration: 7:5 Download File: Start File: Finished File: Entire page with all Excel Files for All Videos: 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 […]

Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform

About this tutorial: Video duration: 29:48 Download File: 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: 1. (00:18) Introduction to Append Multiple Workbooks and Merge Multiple Workbooks 2. (01:58) Append Multiple Workbooks into a single […]

Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR

About this tutorial: Video duration: 9:45 See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate of Return of Cash Flows that occur at irregular date intervals. See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate […]

Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error

About this tutorial: Video duration: 1:43 Download File: 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 1349: Power Query with Input Variables from Excel Sheet to Extract Records

About this tutorial: Video duration: 18:2 Download File: See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: 1. (00:15) Introduction including Preview of Finished Solution and Preview of steps necessary to accomplish this goal. 2. (02:00) Import […]

Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?

About this tutorial: Video duration: 15:52 Download File: See how to use VLOOKUP when there are multiple Lookup Tables with these methods: 1. (00:15) Problem Set up 2. (01:48) IF Function 3. (05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube) 4. (08:47) SWITCH Function (Excel 2016 Insider Program) 5. (11:26) Names […]

Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?

About this tutorial: Video duration: 29:29 Download File: See how to calculate Average of Customer Total Sales by Product using Excel Formulas, Excel Array Formulas and DAX Measures in Excel Power Pivot: 1. (00:15) Introduction 2. (01:08) 2 Step Solution with SUMIFS and AVERAGEIF functions. 3. (07:21) 2 SUMIFS Array Formula 4. (11:26) FREQUENCY Array […]

Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better.

About this tutorial: Video duration: 11:22 Download File: Learn about the difference between Explicit and Implicit DAX Measures: 1. (00:10) Introduction to Explicit and Implicit DAX Measures 2. (01:33) Create Implicit Measures and see these six problems: 1) Number Field will use SUM Function, 2) Text Field uses COUNT, 3) You can’t add Number Formatting […]

Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?

About this tutorial: Video duration: 30:37 Download File: See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: 1. (00:16) Problem Introduction 2. (03:17) Excel Array Formula Solution using AVERAGE, IF and […]

Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date

About this tutorial: Video duration: 13:3 Download Excel File: Entire page with all Excel Files for All Videos: In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. In this video […]

Excel Magic Trick 1384: Import Excel Table or Sheet in Power Query or Power BI?

About this tutorial: Video duration: 4: Download File: Compare and Contract importing a Proper Data Set from either an Excel Sheet or an Excel Table using the Excel Table feature. See that the Excel Table is more robust because it will exclude data on a sheet that is outside the Excel Table. Question: Why do […]