
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
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
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 >>>]
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 >>>]
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 >>>]
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 >>>]
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 >>>]
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 >>>]
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 >>>]
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 >>>]
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.