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

Power Query – Filter Table Based on Distinct NOT Conditions from List – Excel Magic Trick 1592

About this tutorial: Video duration: 9:18 Download Excel File: Learn how to filter imported data using Distinct NOT Conditions from List. See a single M Code Power Query Formula using the functions. Table.SelectRows, Text.Split, List.Intersect and List.IsEmpty. This amazing solution comes from Bill Szysz.

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

About this tutorial: Video duration: 7:25 COUNTIFS($A$1:A1,A1) Formula in Power Query? – Excel Magic Trick 1588 Download Excel File: Learn how to create a Power Query Custom Column Formula that has an expandable range, counts based on the row condition and is equivalent to the Excel Worksheet Formula COUNTIFS($A$1:A1,A1). See how to use the Power […]

Visual Basic Net Tutorial with MySql database 18 Insert Image or Photo to MySql Database

About this tutorial: Video duration: 7:39 Visit for source code and video.

4 Ways To Protect Excel Workbooks, Worksheets And Cells

About this tutorial: Video duration: 6:14 $10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: ****************************************************************** In this video tutorial we will learn how to protect an entire workbook , sheets or cells. There are different methods and level of protection. For example: You can protect all the […]

Excel Two Way Lookup with VLOOKUP & MATCH Functions – Excel Magic Trick 1567

About this tutorial: Video duration: 2:40 Download Excel File: In this video learn how to do a Two Way Lookup from a Rectangular Lookup Table using the VLOOKUP and MATCH functions. In our example we need to lookup a product name in the row and a month name in the column and return the intersecting […]

Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard

About this tutorial: Video duration: 21:54 Download files: Learn about: 1) (00:04) Notes about downloading files 2) (00:36) Look at Finished Grade Dashboard 3) (01:10) Look at Text files that we need to import from a folder 4) (02:07) Power Query to Import Text Files (extension “.txt”) from a Folder 5) (06:14) What is a […]

Summarize Survey Results with PivotTable in One Minute – Excel Magic Trick 1577

About this tutorial: Video duration: 1:1 Download Excel File: In this video learn how to create a Survey Result Report in less than one minute with a PivotTable.

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 Intersection Operator, An Excel Party Trick? – Excel Magic Trick 1570

About this tutorial: Video duration: 1:10 Download Excel File: In this video learn how to use the Intersection Operator, which is a space. Learn about the #NULL Error. Related Videos: Excel Union Operator For Aggregate, Statistical & Finance Functions – Excel Magic Trick 1569 Excel Intersection Operator, An Excel Party Trick – Excel Magic Trick […]

DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561)

About this tutorial: Video duration: 11:6 Download Excel File: Download Start Power BI Desktop: Download Finished Power BI Desktop File: Entire page with all Excel Files for All Videos: Learn how to create a DAX Calculated Colum and DAX Measure for Half Year Running Totals in Power BI Desktop or Excel Power Pivot. Topics: 1. […]

How to Apply Conditional Formatting with Excel Slicers

About this tutorial: Video duration: 5:40 How to Apply Conditional Formatting with Excel Slicers For more Excel tips and tricks visit me at In this video I’ll show you how to apply conditional formatting with Excel slicers. Excel slicers are a handy and easy to use filtering system that Excel has built in but you […]

Excel Tricks : Pivot Table Custom Grouping Trick In Excel | Excel Tutorials | MS Excel | dptutorials

About this tutorial: Video duration: 3:22 In this video, let’s learn about one of Excel’s most powerful and creative tool that is called as Pivot Table, when you work with large amounts of data, i.e list type data. Pivot table is great for coming up with quick summary information. Watch this video completely for better […]

Basic Excel Business Analytics #34: Power Query: Import & Merge Multiple Sources Access, Text, Excel

About this tutorial: Video duration: 5:1 Download files: Learn about how to use Power Query to Import & Merge Multiple File Types (Access, Text, and Excel) into one Proper data Set using the Append feature. Power Query Tab, Get External Data. Excel 2016: Data Tab, Get and Transform group. Download Excel File Not: After clicking […]

Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs

About this tutorial: Video duration: 10:18 Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: Download Full Written Notes: Class web page link: Topics in this video: 1. (00:04) Introduction 2. (00:40) Customize QAT 3. (07:36) Show New Ribbon Tabs 4. (09:33) Summary – Conclusion

Excel Basics 8: Default Data Alignment In Excel & How it Can Help

About this tutorial: Video duration: 9:25 Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: Download Full Written Notes: Class web page link: Learn about Default alignment in Excel and how it an help you with Data Entry, formulas and tracking down errors.

Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)

About this tutorial: Video duration: 33:26 Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: Download Full Written Notes: Class web page link: Topics in this video: 1. (00:01) Introduction 2. (01:22) What Excel can do: 1) Calculations, Data Analysis 3. (01:58 and 03:22) What is Data…

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.

Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557)

About this tutorial: Video duration: 1:10 Download Excel File: Entire page with all Excel Files for All Videos: In this video learn how to open a Smart Tag with a Keyboard. Open the Auto Fill Options or Paste Options feature with a Keyboard.

Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas

About this tutorial: Video duration: 44:21 Download Files: In this video learn about Conditional Formatting Topics : 1. (00:16) Introduction 2. (00:43) Built-in Feature: Cell Contains 3. (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. 4. (10:00) Built-in Feature: Below Average 5. (10:55) Logical Formula: Highlight Row (Record) where sales are below […]