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, August 26, 2010

More Cool Excel Shortcuts

›

Back in April, I posted my own personal Top Ten Best Excel Shortcuts in reverse order (ala Letterman’s Top Ten …). Here is an additional...

Thursday, August 19, 2010

Spiff Your List with Conditional Formatting Icons

›

Many of us use Excel to keep Lists of Stuff. It may be as simple as a grocery list or as complex as a due-diligence list for a corporate m...

Thursday, August 12, 2010

Indirect and Validation

›

Interactive reports are powerful tools that can provide the user with multiple sets of information in a One-Stop, Professional Format . T...

Thursday, August 5, 2010

Troubleshooting Formulas

›

Let’s face it, problems happen in Excel. One of the most common issues, of course, involves the use of formulas. The problem is that (this...

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

‹

›

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