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, July 29, 2010

DateDif Revisited

›

A little over a year ago, I discussed the obscure DateDif function, and it was a readers’ favorite. As I mentioned in my 2009 post, Microso...

Thursday, July 22, 2010

Dynamic Named Ranges

›

Nearly two years ago, (see my September 15, 2008 post), I wrote about the wisdom of using Named Ranges in Excel. Using a Named Range in a ...

Thursday, July 15, 2010

Importing Problem? Change Text to Numbers!

›

Many of us have occasions where we are importing files that were not created in Excel . Usually this causes no problems, but once in a while...

Thursday, July 8, 2010

Rock and Roll with Your Ctrl Key!

›

This week discussion is on Three Cool Things you can do with your Ctrl Key: #1 - You can make Noncontiguous Selections of cells. Now th...

1 comment:

Thursday, July 1, 2010

Funky Histogram Anti-Chart

›

Charts are tremendous tools that visually represent the often dry data that is contained in a table or database. Sometimes it can be a hass...

2 comments:

Thursday, June 24, 2010

Camera Tool – Just Say Cheese!

›

A picture may be “worth as thousand words”, but sometimes a graphical representation of a chart can use a little support from the source tab...

Thursday, June 17, 2010

Working with the DATE Function

›

Working with dates in Microsoft Excel can be a puzzling and, at times, aggravating experience. Adding days, months, or years to a date can b...

‹

›

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