Excel Enthusiasts

A weekly blog on all things that are cool in Excel. Material ranges from topics for neophytes to advanced subjects. All ranges of classes at http://www.continuingeducationgroup.net/

Thursday, May 26, 2011

COUNTIF and CONCATENATION Revisited

›

Dear Readers, It has been a rough week for me. My one true hero since childhood, my Uncle Bob, (after whom I was named), passed away. He w...

Wednesday, May 18, 2011

Matching Two Databases

›

Many of us are faced with matching data that is contained in two or more databases. It may be matching customers with product choices, insur...

Thursday, May 12, 2011

Frequency Tables and Histograms

›

Last October, I wrote about the FREQUENCY Function in Excel. This function allows you to investigate how frequent values within particular ...

Thursday, May 5, 2011

Hiding Duplicate Values

›

There are times when you have duplicate data that you want to retain, but for the sake of improved readability, you wish to hide it. One w...

Wednesday, April 27, 2011

›

Most of us are familiar with the simple Filter tool found in the Sort & Filter group on the Data tab. If you apply the filter and use...

Wednesday, April 20, 2011

Watch that Date!

›

Most of us these days have gotten into the habit of using four digits when referring to a year. It is convenient, of course, to use just two...

Wednesday, April 13, 2011

Duplicates Revisited

›

Recently a reader wrote in saying he was combining two large mailing lists and wanted an easy way to remove the duplicates . When it comes t...

‹

›

Home

View web version

About the Blogger

Bob DeLaMartre: Online school founder, eLearning designer, Excel guru, currently teaching and pursuing his Ph.D in education.

View my complete profile