Excel VBA

Excel VBA Constants and Enumerations

November 17, 2015 0

Excel VBA Introduction Part 26 – Constants and Enumerations DESCRIPTION Constants in VBA are values which don’t change – there are lots of built-in examples and you can also create your own. This video teaches […]

Excel Is Fun

Excel Magic Trick 1178

November 16, 2015 0

Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA? DESCRIPTION From Survey Results, see examples of how to calculate the percentage of No responses given that the response was from a Full Time Faculty in […]

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