Excel Is Fun

Excel Magic Trick 1179

November 23, 2015 0

Calculate Mean, Median and Mode From Data Set DESCRIPTION See how to: (00:30) Mean using AVERAGE function (02:15) Median using MEDIAN function (03:17) Mode using MODE.MULT, SMALL and IFERROR functions

Dueling Excel

Dueling Excel 51

November 18, 2015 0

Extract Dates from Cell With Dates and Words DESCRIPTION See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using two different methods. See the functions: DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, […]

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