Dueling Excel

Dueling Excel 61

January 27, 2016 0

Formula To Report Cell Reference 5 Examples DESCRIPTION See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand […]

Excel VBA

Excel VBA Using Class Modules in Other Projects

January 26, 2016 0

Excel VBA Introduction Part 36 – Using Class Modules in Other Projects DESCRIPTION One small limitation of VBA Class Modules is that, by default, you can only use them in the VBA Project in which […]

Excel Is Fun

Excel Magic Trick 1189

January 25, 2016 0

Extract Color From Description Create Revenue by Color PivotTable, 2nd Take DESCRIPTION See how extract color from description, but only when the color is a single word with a space before and after the word. […]

Dueling Excel

Dueling Excel 60

January 20, 2016 0

Conditional Format High Blood Pressures — 4 Methods DESCRIPTION See Mr Excel and excelisfun create conditional formatting 4 ways: 1) Built-in Greater Than Feature 2) Built-in Greater Than Or Equal To Feature 3) Logical TRUE […]

Excel VBA

Excel VBA Class Modules

January 19, 2016 0

Excel VBA Introduction Part 35 – Class Modules DESCRIPTION Class Modules in VBA allow you to define your own classes of objects. This video explains why that’s a useful and shows you how to go […]

Excel Is Fun

Excel Magic Trick 1188

January 18, 2016 0

SUMIFS with Wildcards to Do Approximate Criteria or “Fuzzy” Criteria DESCRIPTION See how use asterisk wild card to add all the cells that contain the word “Red”. SUMIFS with Wildcards to Do Approximate Criteria or […]

Dueling Excel

Dueling Excel 59

January 13, 2016 0

Custom Lists, Defined Names, PivotTable & COUNTIF Function DESCRIPTION See Mr Excel and excelisfun create Custom Lists, Defined Names, a PivotTable & the COUNTIF Function to create a sorted Frequency Table. WORKBOOKS