Dueling Excel

Dueling Excel 67

March 2, 2016 0

Extract Initials From Full Name: VBA or Formula? DESCRIPTION See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a Formula. See the Functions TRIM, REPLACE, LEFT, and SEARCH. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1194

February 29, 2016 0

VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do? DESCRIPTION See how convert Number lookup_value to Text Number and how to convert Text Number lookup_value to Number to VLOOKUP does not yield #N/A: (00:08) Problem […]

THE RIBBON

The Developer Tab

February 25, 2016 0

The Developer Tab contains a variety of tools that allow you to customize Excel. Of particular importance is the fact that the Developer tab contains tools that allow you to create, access and edit macros. […]

Dueling Excel

Dueling Excel 66

February 24, 2016 0

Slaying Excel Dragons E-Book Available at Mr Excel Web Site! DESCRIPTION See Mr Excel and excelisfun talk about the new book Slaying Excel Dragons by Mike excelisfun Girvin. WORKBOOKS

Tricks & Tips

Display Day Name From A Date

February 23, 2016 0

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how […]

Excel Is Fun

Excel Magic Trick 1193

February 22, 2016 0

Count Distinct Words As They Are Entered In Column: Formula or Excel Table? DESCRIPTION See how calculate a running count for each unique (distinct) text items entered in column using two methods: (00:10) Problem setup […]

Dueling Excel

Dueling Excel 64

February 17, 2016 0

Extract Records With Not Criteria VBA or Filter DESCRIPTION See Mr Excel and excelisfun Extract Records From A Data Set With Not Criteria VBA or Filter. WORKBOOKS

Excel VBA

Excel VBA Dictionaries

February 16, 2016 0

Excel VBA Introduction Part 39 – Dictionaries DESCRIPTION The Dictionary class is similar to the Collection class in that it allows you to store a custom collection of objects. This video teaches you how to […]