Excel Is Fun

Excel Magic Trick 1242

DESCRIPTION Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1226

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) [Read More >>>]

Dueling Excel

Dueling Excel 98

Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr [Read More >>>]

Excel Is Fun

Excel Magic Trick 1221

Dynamic Chart to Plot Daily Changes in Meter Readings DESCRIPTION Learn how to create a dynamic chart that updates when daily meter readings are entered into a table (00:10) Problem Setup (00:50) IF function and [Read More >>>]

Dueling Excel

Dueling Excel 87

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1200

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

Dueling Excel

Dueling Excel 55

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

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 [Read More >>>]