Excel Is Fun

Excel Magic Trick 1402

DESCRIPTION See how to put a check mark in a cell when a number is greater than zero using the IF Function and the CHAR function: (00:11) Introduction (00:41) Insert a Symbol (01:28) Generate full [Read More >>>]

Excel Is Fun

Excel Magic Trick 1377

DESCRIPTION See how to create a formula to list incomplete / missing student assignments: (00:11) Introduction (01:14) Formula to count missing assignments for a particular student using: 1) INDEX & MATCH functions to lookup a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1343

DESCRIPTION See Three methods for creating Chart Labels that have two lines: (00:10) Introduction (00:48) Basics of Text Formula and Join Operator, Ampersand. (01:35) Access Select Data dialog box to edit references in an Excel [Read More >>>]

Excel Is Fun

Excel Magic Trick 1339

DESCRIPTION See how to use a Formula, Power Query, or Custom List to create the Alphabet A – Z: (00:14) Introduction (00:26) What are ASCII Characters? (00:26) Formula with ROWS and CHAR functions, and ASCII [Read More >>>]

Dueling Excel

Dueling Excel 014

DESCRIPTION See Mr Excel and excelisfun create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers. See functions like: SIGN, IF, and [Read More >>>]

Dueling Excel

Dueling Excel 007

DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses a formula with INDEX, IF, [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 46

DESCRIPTION Topics in this video: 1. Formulas for Min and Max values 2. Formulas for Chart Labels 3. COUNTIFS formula to count between upper and lower numbers. BETWEEN Criteria. AND Criteria. 4. Histogram Chart with [Read More >>>]