Excel Is Fun

Highline Excel 2013 Class Video 37

DESCRIPTION Topics in this video: 1. Advanced Filter: Cross Between Filter and Database Functions. 2. Advanced Filter 3 Areas: Criteria Area Data Set Extract Area: Be sure to keep area below CLEAR!!!! 3. Advanced Filter [Read More >>>]

Excel Is Fun

Excel Magic Trick 1297

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with a Join Array Operation to create the OR Criteria Array that goes into the criteria argument& then the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1296

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with OR Criteria & SUMPRODUCT function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1285

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1275

DESCRIPTION Excel Online Office 365 MAXIFS function Learn how to find the biggest value based on a condition or criteria. New features released in these versions: 1. Office 365 Online Excel OR 2. Office 365 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1190

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 10

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example [Read More >>>]

Excel Is Fun

Excel Magic Trick 1104

DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to [Read More >>>]

Dueling Excel

Dueling Excel 018

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions [Read More >>>]