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/

Wednesday, June 29, 2011

Cleaning Up Your Data

›

If you ever have had problems downloading useable data into Excel from another software source, you may have wondered how to clean it up. Th...

Thursday, June 23, 2011

Using the CONVERT Function

›

The CONVERT function is one of those obscure little tools in Excel that can come in very handy. For example, let’s say you want to conver...

Thursday, June 16, 2011

Paste Special is Special!

›

Paste Special is one of those Excel tools that once you discover what you can do with it, you wonder how you ever lived without it. To find...

Thursday, June 9, 2011

Trendline Before and After

›

Charts are, of course, a wonderful way to communicate information in your Excel Worksheet. A well-designed chart can immediately translat...

Thursday, June 2, 2011

Top Ten Favorite Shortcuts for 2011

›

Every year or so, I like to access what my Current Favorite Excel Keyboard Shortcuts are. This changes over time as I learn new tricks and ...

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...

‹

›

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