### Dates & Times

November 29, 2015

WORKBOOKS

### Delete Row if Cell is Blank

November 26, 2015

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 52

November 25, 2015

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 Creating Word Documents

November 24, 2015

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 Magic Trick 1179

November 23, 2015

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

### ROMAN, ARABIC Functions

November 22, 2015

WORKBOOKS

### AGGREGATE Function

November 21, 2015

WORKBOOKS

### CONVERT Function

November 20, 2015

WORKBOOKS

### Dueling Excel 51

November 18, 2015

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 Constants and Enumerations

November 17, 2015

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