Excel Is Fun

Excel Magic Trick 1182

December 7, 2015 0

COUNTIFS and Wildcards to Count When There are 4 or More Characters DESCRIPTION See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz […]

Dueling Excel

Dueling Excel 53

December 2, 2015 0

Extract State When Text String Has Varying Number of Commas DESCRIPTION See Mr Excel and excelisfun show how to do a VBA and an array formula method to extract State data from a column of […]

Excel VBA

Excel VBA Creating PowerPoint Presentations

December 1, 2015 0

Excel VBA Introduction Part 28 – Creating PowerPoint Presentations 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 1181

November 30, 2015 0

Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT DESCRIPTION See how to: (00:08) Count numbers with 4 or more characters using COUNTIFS function. See that COUNTIFS requires Comparative Operators in Double […]

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