Excel Is Fun

Excel Magic Trick 1177

November 12, 2015 0

Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter DESCRIPTION See examples of how to use CONVERT function to convert from one unit to another unit. (00:12) Flash Fill from […]

Dueling Excel

Dueling Excel 050

November 11, 2015 0

#N/A errors SUMIF or AGGREGATE? DESCRIPTION See Mr Excel and excelisfun create formulas to add a column of numbers and ignored the #N/A error: SUMIF function or AGGREGATE function? WORKBOOKS

Excel VBA

Excel VBA Arrays

November 10, 2015 0

Excel VBA Introduction Part 25 – Arrays DESCRIPTION An array is a lot like a variable, only with an array you can store more than one value under the same variable name. This video explains […]

Excel Is Fun

Excel Magic Trick 1176

November 9, 2015 0

CONVERT Function to convert units in Excel DESCRIPTION See examples of how to use CONVERT function to convert from one unit to another unit. (00:11) CONVERT function (00:54) Use drop down list to select from_unit […]

Excel Is Fun

Excel Magic Trick 1175

November 5, 2015 0

Decaying Average in Standards-Based Grading in Excel DESCRIPTION See (00:10) How Decaying Average in Standards-Based Grading works (02:00) Calculating in Excel Method 1: Two formulas that use IF function and Absolute Cell References (04:02) Explaining […]

Dueling Excel

Dueling Excel 048

November 4, 2015 0

Screen Tip & Excel Is Broken DESCRIPTION See Mr Excel and excelisfun show how to break Excel by moving a data validation screen tip. WORKBOOKS