Tricks & Tips

Delete Row if Cell is Blank

November 26, 2015 0

In this example we have a table of data listing each persons sales per quarter. What we want to do is delete the rows that no longer contain a name in column A without having […]

Dueling Excel

Dueling Excel 52

November 25, 2015 0

Lookup Two Criteria: SUMIFS, DGET, or Array Formula? DESCRIPTION See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses […]

Excel VBA

Excel VBA Creating Word Documents

November 24, 2015 0

Excel VBA Introduction Part 27 – Creating Word Documents DESCRIPTION Writing VBA code in Excel doesn’t only allow you to control Excel, you also have access to all of the other Office applications. This video […]

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