Excel Is Fun

Highline Excel 2013 Class Video 29

Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example) DESCRIPTION Topics in this video: 1. Extract First Name. 2. Extract Last Name. 3. Formulas or Flash Fill?. 4. Extract First and Last Initial. 5. Flash [Read More >>>]

Excel Is Fun

Excel Magic Trick 1283

MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria DESCRIPTION Learn how to use the MINIFS & MAXIFS functions to find the Minimum and Maximum values in a column based on [Read More >>>]

Dueling Excel

Dueling Excel 135

DESCRIPTION From Text to Math: VBA or Excel 4 Macro Function: EVALUATION See Mr Excel and excelisfun use two methods to convert a text string to a match expression that can calculate the correct answer: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1282

Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function DESCRIPTION See how to use the amazing new Excel 2016 function TEXTJOIN to Find Multiple Lookup Values In First Colum AND return Multiple Items [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 28

Excel Data Validation: List, Date, Time, Custom (22 Examples) DESCRIPTION Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit. 2. Create an Input Message for your [Read More >>>]

Excel Is Fun

Excel Magic Trick 1281

TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items) DESCRIPTION Learn about the new Excel 2016 functions TEXTJOIN and CONCAT. Compare and contrast these newer functions to the older methods of using [Read More >>>]

Dueling Excel

Dueling Excel 134

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to [Read More >>>]

Excel Features

Using Excel AutoComplete

When you type the first few letter of an entry into a cell Excel can complete the entry automatically using an option known as AutoComplete. It does this by building a list based on the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1280

How To Get Latest Excel Updates for Insider Program: Office 365 DESCRIPTION Learn how to download the Insider Program Version of Excel 2016 so you can get new periodic updates with new features such as [Read More >>>]