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

Option Buttons

›

In the old Clint Eastwood movie, Magnum Force , Harry Callahan used the line, “ A man’s got to know his limitations ”. That may be so, bu...

Wednesday, December 22, 2010

A Little Excel Magic

›

Some shortcuts and tips can often appear Magical! Here are a few of my current favorites: Select Noncontiguous Cells If you want to sel...

Thursday, December 16, 2010

Concatenation Revisited

›

This is one of my favorite time savers. I teach Excel, and I have had classes as large as 200 students. Since I believe strongly in freque...

Thursday, December 9, 2010

Using the RAND Function

›

A very interesting and at times very useful function in Excel is the RAND function. This function returns a Random Number that is gre ate...

1 comment:

Thursday, December 2, 2010

Choosy Moms Use “Choose”

›

Having a Choice is (as Martha Stewart would say) “ a good thing ”. Nested IF functions can be very useful, but they have limitations (the ...

Thursday, November 25, 2010

Scatterplots and the Coefficient of Determination

›

One of my favorite charts and accompanying functions are Scatterplot (XY) Chart and the Coefficient of Determination function. ...

1 comment:

Thursday, November 18, 2010

Excel Easter Eggs

›

First of all, I want to congratulate the winner of our “ People who use Excel are Cool ” Contest that was announced two weeks ago. Gordon ...

‹

›

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