Excel Is Fun

Highline Excel 2013 Class Video 30

April 7, 2017 0

Custom Number Formatting & Text Functions, (33 Examples) DESCRIPTION Topics in this video: 1. 23 Examples of Custom Number Formatting. 2. Custom Number Formatting For Unit Price for Invoice. 3. Three TEXT function examples for […]

Excel Is Fun

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

Dueling Excel

Dueling Excel 136

April 5, 2017 0

DESCRIPTION Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP? See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale: 1. VBA with […]

Excel Is Fun

Excel Magic Trick 1284

April 3, 2017 0

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #16

April 1, 2017 0

DESCRIPTION Discover how to apply mixed absolute cell references to quickly complete a table of calculations in Microsoft Excel (applicable to all versions of Excel).

Excel Is Fun

Highline Excel 2013 Class Video 29

March 31, 2017 0

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

Excel Is Fun

Excel Magic Trick 1283

March 30, 2017 0

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

Dueling Excel

Dueling Excel 135

March 29, 2017 0

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

Excel Is Fun

Excel Magic Trick 1282

March 27, 2017 0

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