Excel Is Fun

Excel Magic Trick 1200

April 11, 2016 0

Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) DESCRIPTION See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons […]

Dueling Excel

Dueling Excel 55

December 16, 2015 0

Calculate Grade & Exclude Scores When Student Is Absent DESCRIPTION See Mr Excel and excelisfun use SUMPRODUCT, ISNUMBER, and SUMIF functions to calculate a grade where excused absences are considered in final grade. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1155

August 27, 2015 0

IF Function: Checking For Empty Cells (5 Methods) DESCRIPTION IF Function: Checking For Empty Cell & Zero Length Text Strings: (00:08) Problem Setup (00:56) IF function logical test using Zero Length Text String (checks for […]

Dueling Excel

Dueling Excel 025

May 27, 2015 0

Extract Records NOT Swim or Ski (Filter or Formula?) DESCRIPTION See Mr Excel and excelisfun extract records from database that are NOT Swim or Ski with Filter, Advanced Filter, or Formula using ISNUMBER, LOOKUP and […]

Excel Is Fun

Excel Magic Trick 1120

April 20, 2015 0

DESCRIPTION See how to create a Logical Formula that will check whether an item in in all three lists using 2 MATCH functions and the ISNUMBER function. WORKBOOKS

Dueling Excel

Dueling Excel 018

March 18, 2015 0

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

Excel Is Fun

Excel Magic Trick 1110

March 8, 2015 0

DESCRIPTION See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1109

March 7, 2015 0

DESCRIPTION See how to Compare Two Lists and Extract Records with Excel Advanced Filter: 1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area […]

Excel Is Fun

Excel Magic Trick 1108

March 6, 2015 0

DESCRIPTION See how to Compare Two Lists and Extract Records: 1. ISNA and MATCH function with Filter to extract items in list 2 that are NOT in List 1. 2. ISNUMBER and MATCH function with […]

Excel Is Fun

Highline Excel 2013 Class Video 15

February 14, 2015 0

DESCRIPTION Topics in this video: (00:33) IF Function to deliver numbers. (01:37) IF Function to deliver text. (03:19) IF Function to deliver formulas. (05:19) IF Function to deliver functions. (07:51) Nested IFs. (10:24) Null Text […]