Dueling Excel

Dueling Excel 58

January 6, 2016 0

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

Excel VBA Creating Add Ins

January 5, 2016 0

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 Is Fun

Excel Magic Trick 1186

January 4, 2016 0

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

Dueling Excel

Dueling Excel 57

December 30, 2015 0

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

Excel VBA ADO (ActiveX Data Objects) SQL Statements

December 29, 2015 0

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 Is Fun

Excel Magic Trick 1185

December 28, 2015 0

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.

Dueling Excel

Dueling Excel 56

December 23, 2015 0

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