Excel Is Fun

Excel Magic Trick 1302

June 29, 2017 0

DESCRIPTION Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel […]

Dueling Excel

Dueling Excel 148

June 28, 2017 0

DESCRIPTION See Mr Excel and excelisfun create a Formula To Deliver TRUE When 3 Out 4 Tests Are Met 1. Boolean Formula with 4 Logical Tests (See Formula Evaluator) 2. SUM function with 4 Logical […]

Excel Is Fun

Excel Magic Trick 1301

June 26, 2017 0

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between […]

Excel Is Fun

Highline Excel 2013 Class Video 41

June 23, 2017 0

DESCRIPTION Topics in this video: 1. What do Charts do? Visually portray Quantitative data (number data). Give a quick impression of the number data. Create a picture that can communicate more quickly than just the […]

Dueling Excel

Dueling Excel 147

June 21, 2017 0

DESCRIPTION See Mr Excel and excelisfun Avoid Sheet References From Current Sheet in a formula: 1. View, Arrange Vertically 2. Use Function Argument Dialog Box (Zack Barresse trick) WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 40

June 16, 2017 0

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: […]

Dueling Excel

Dueling Excel 146

June 14, 2017 0

DESCRIPTION Excel Truel: This is a simple Excel task: multiplying, but for a kid, its seems amazing! See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin try to multiply in Excel. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 39

June 9, 2017 0

DESCRIPTION Topics in this video: 1. Import Commas Delimited Data From Word Document with Copy and Paste then do Text To Columns. 2. Import CSV File and Txt File. 3. Import Proper Data Set into […]

Dueling Excel

Dueling Excel 145

June 7, 2017 0

DESCRIPTION See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates: 1. Text To Columns 2. Formula with DATE, LEFT, RIGHT, MID functions 3. Flash Fill 4. Text Function with custom Number Format 0000\/00\/00 WORKBOOKS