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, July 27, 2016

The Intersect Operator Revisited

›

The Intersect Operator is one of my favorite obscure Excel tools. Although relatively obscure, it is highly useful, as there are many way...

Thursday, July 21, 2016

The Excel Slot Machine

›

Excel users can be a very sensible lot, but Not Everything in Excel needs to be so terribly Serious . In fact, you can take some th...

Thursday, July 14, 2016

Quizzes in Excel

›

Only a very small percentage of Excel users ever get around to exploring Form Controls . This is unfortunate, as they can be instrumenta...

Friday, July 8, 2016

Get & Transform

›

As we have discussed in years past, pulling data from sources outside of Excel is a fact-of-life for many Excel users. Microsoft Query...

Thursday, June 30, 2016

Pivot Tables

›

We just covered Pivot Tables in my current Intermediate Excel Class today, so I decided it would be a good topic for this week’s blog po...

1 comment:

Thursday, June 23, 2016

Wildcards

›

As we all know, there is an abundance of Super Cool tricks in Excel. Even the grandest of Excel masters can occasionally stumble upon a t...

Thursday, June 16, 2016

Instant Information!

›

Although it’s not a very good solution for general reporting, the AutoFilter tool is a quick and easy way for you to display only the de...

1 comment:

‹

›

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