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, September 30, 2010

Hide and Seek

›

“ Keeping Things Simple ” is almost always a good thing. Hiding a worksheet is one way of keeping your workbook tidy, and also can serve to...

Thursday, September 23, 2010

MATCH and INDEX = POWER!

›

You say you like using the VLOOKUP function, but would like something a bit more versatile and powerful? Look no further than the MATCH an...

Thursday, September 16, 2010

Three Ifs

›

“ If ” functions can really help you make sense of your data. Here are my three favorites: COUNTIF: =Countif(Range, Criteria) For the Cri...

Thursday, September 9, 2010

Scrolling, Scrolling, Scrolling!

›

If you have a spreadsheet that needs incremental updates of the numbers in certain cells, clicking on the cells and typing in the subsequen...

Friday, September 3, 2010

Double-Click is Our Friend!

›

Double-clicking is a powerful tool that can save you many hours of work. Try any or all of the following six techniques and see if you do n...

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

‹

›

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