### Dueling Excel 58

January 6, 2016

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales […]

### Excel VBA Creating Add Ins

January 5, 2016

Excel VBA Introduction Part 33 – Creating Add Ins DESCRIPTION Creating an Excel VBA Add-In is a great way to make your custom functions available to other Excel workbooks and VBA projects. This video teaches […]

### Excel Magic Trick 1186

January 4, 2016

Extract Color From Description Field & Create Revenue by Color PivotTable DESCRIPTION See how: (00:09) Problem Setup (01:04) Barry Houdini at Mr Excel Message Board and pmsocho at YouTube (01:23) SEARCH function with a Function […]

January 2, 2016

WORKBOOKS

### Dueling Excel 57

December 30, 2015

Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, […]

### Excel VBA ADO (ActiveX Data Objects) SQL Statements

December 29, 2015

Excel VBA Introduction Part 32 – ADO (ActiveX Data Objects) SQL Statements DESCRIPTION The ADO Command object essentially allows you to write SQL statements directly into your VBA code and execute them on whichever database […]

### Excel Magic Trick 1185

December 28, 2015

Calculate Standard Deviation from Frequency Distribution in Excel DESCRIPTION See how create a formula that uses SUMPRODUCT function to Calculate Standard Deviation From Frequency Distribution in Excel.

### DATEVALUE Function

December 26, 2015

WORKBOOKS

### Dueling Excel 56

December 23, 2015

Copy Formula Down, Have Range Move Across DESCRIPTION See Mr Excel and excelisfun create formulas that can be copied down across the rows and have the range in the function move across the columns. See […]

### Excel VBA ADO (ActiveX Data Objects) Modifying Data with Recordsets

December 22, 2015

Excel VBA Introduction Part 31 – ADO (ActiveX Data Objects) Modifying Data with Recordsets DESCRIPTION We’ve previously looked at how to query a database using ActiveX Data Objects (ADO) to get data from a recordset […]