### Highline Excel 2013 Class Video 42

June 30, 2017

DESCRIPTION Topics in this video: 1. Save Chart As Template WORKBOOKS

### Excel Magic Trick 1302

June 29, 2017

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 148

June 28, 2017

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 Magic Trick 1301

June 26, 2017

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

### Highline Excel 2013 Class Video 41

June 23, 2017

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 147

June 21, 2017

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

### Highline Excel 2013 Class Video 40

June 16, 2017

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 146

June 14, 2017

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

### Highline Excel 2013 Class Video 39

June 9, 2017

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 145

June 7, 2017

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