Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).

About this tutorial: Video duration: 5:46 Download Excel Start Files: Entire page with all Excel Files for All Videos: In this video learn how to extract sales records based by day with a formula. Learn about the New Office 365 Dynamic Array Functions: FILTER, SORT and UNIQUE. Compare and contrast this new method to the […]

Excel Union Operator For Aggregate, Statistical & Finance Functions – Excel Magic Trick 1569

About this tutorial: Video duration: 2:40 Download Excel File: In this video learn about how to use the Union Operator in standard Aggregate functions, like SUM and AVERAGE and how to use it inside of parentheses inside Statistical and Finance Functions. Related Videos: Excel Union Operator For Aggregate, Statistical & Finance Functions – Excel Magic […]

Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?

About this tutorial: Video duration: 5:26 Download Excel File: Entire page with all Excel Files for All Videos: In this video see how to count values that are greater than a hurdle when the values in in noncontiguous cells (cells not next to each other). See an Array Formula that uses SUMPRODUCT and CHOOSE and […]

Dynamic Array & Old Array Formulas to Create Student Classes Report – Excel Magic Trick 1608

About this tutorial: Video duration: 7:48 Download Excel File: Learn how to create a report that shows each student by quarter with a list of classes in a single cell. See many of the new Excel 365 Functions like: SORTBY, UNIQUE, FILTER, TEXTJOIN and the ROWS Function. See how we can combine Spilled Arrays formulas […]

Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values

About this tutorial: Video duration: 9:49 Download Files: Entire page with all Excel Files for All Videos: In this video see how to color a row with conditional formatting using an Array Formula & the MATCH Function that will lookup Two Lookup Values in a corresponding Table.

DAX Measure & Data Model PivotTable – List Student Classes in Single Cell –- Excel Magic Trick 1607

About this tutorial: Video duration: 4:22 Download Excel Start File: Download Excel Finished File: Learn how to create a report that shows each student by quarter with a list of classes in a single cell. Learn how to create a Data Model PivotTable and a DAX Measure that uses the DAX Function CONCATENATEX using the […]

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

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

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

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.

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

Importing from outlook express into Thunderbird using NVDA

About this tutorial: Video duration: 5:34 This is a titorial on how to import outlook express to mozilla Thunderbird using NVDA. see below for various links. Donate to my Patreon at twitter: blog link. facebook video game writings: Xbox Live: PSN ID: weirdwriter Help us caption & translate this video!

integrated gate commutated thyristor (IGCT) (Version 1.0)

About this tutorial: Video duration: 3:11 Visit: Install android app: ★Full Playlist : playlist include: AC adapter motor power plugs and sockets AC DC receiver design Active filter noise control pixel sensor rectification Active reactive apparent Actuator Adjustable speed drive Advantages Disadvantages of Permanent Magnet Brushless DC PMBLDC Motor Variable Frequency Drive VFD Altair Alternating […]

Q factor

About this tutorial: Video duration: 1:9 Visit: Install android app: ★Full Playlist : playlist include: AC adapter motor power plugs and sockets AC DC receiver design Active filter noise control pixel sensor rectification Active reactive apparent Actuator Adjustable speed drive Advantages Disadvantages of Permanent Magnet Brushless DC PMBLDC Motor Variable Frequency Drive VFD Altair Alternating […]

Push–pull converter (Version 1.0) (electronics2electrical.com)

About this tutorial: Video duration: 2:2 Visit: Install android app: ★Full Playlist : playlist include: AC adapter motor power plugs and sockets AC DC receiver design Active filter noise control pixel sensor rectification Active reactive apparent Actuator Adjustable speed drive Advantages Disadvantages of Permanent Magnet Brushless DC PMBLDC Motor Variable Frequency Drive VFD Altair Alternating […]

Four Quadrant Operation Of DC Motor (Version 1.0)

About this tutorial: Video duration: 2:17 Visit: Install android app: ★Full Playlist : playlist include: AC adapter motor power plugs and sockets AC DC receiver design Active filter noise control pixel sensor rectification Active reactive apparent Actuator Adjustable speed drive Advantages Disadvantages of Permanent Magnet Brushless DC PMBLDC Motor Variable Frequency Drive VFD Altair Alternating […]

VSI (Voltage Source Inverter)

About this tutorial: Video duration: 2:9 Visit: Install android app: ★Full Playlist : playlist include: AC adapter motor power plugs and sockets AC DC receiver design Active filter noise control pixel sensor rectification Active reactive apparent Actuator Adjustable speed drive Advantages Disadvantages of Permanent Magnet Brushless DC PMBLDC Motor Variable Frequency Drive VFD Altair Alternating […]