CHAR – Master Excel

Excel Magic Trick 1474

DESCRIPTION Learn about how to create a Twinkling Christmas Tree with a Star on Top in Excel using the RAND and CHAR functions, the Conditional Formatting Scales and Conditional Formatting Icons. WORKBOOKS

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 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 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 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 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 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 2013 Power Query 03

DESCRIPTION See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Power Query 1 Step Method, and then make an amazing Pivot Chart with [Read More >>>]