Excel Is Fun

Excel Magic Trick 1183

December 14, 2015 0

Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula DESCRIPTION See how to take a list of menu items with unwanted text after the dash and remove the unwanted text using: (00:08) […]

Dueling Excel

Dueling Excel 54

December 9, 2015 0

Approximate Lookup To Return Multiple Items DESCRIPTION See Mr Excel and excelisfun create solution to do an approximate lookup to return multiple items. See VBA solution and array formula solution. Also see Excel 2010 AGGREGATE […]

Excel VBA

Excel VBA Creating Outlook Emails

December 8, 2015 0

Excel VBA Introduction Part 29 – Creating Outlook Emails 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 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 […]