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, February 23, 2012

Names and Better Databases

›

This is one of my Favorite Excel Tricks , and it should be in your arsenal of weapons against Poorly Formatted Data. If you have been ...

Wednesday, February 15, 2012

Scatterplots and COD

›

No , we're not talking Scatterplots and Codfish... As was discussed about back in November of 2010 in this blog, Scatterplot (XY...

Wednesday, February 8, 2012

Custom AutoFilters

›

The AutoFilter is one of those Wonderfully Simple , yet Powerful tools that are readily available to any user of Excel. To find AutoFil...

Wednesday, February 1, 2012

Keyboard Shortcuts: The Final Chapter

›

You say you are a Diehard Keyboard Shortcutist , (yes, I just made up the word, “ Shortcutist ”…), that has mastered most of the typical...

1 comment:

Wednesday, January 25, 2012

Protect Your Work!

›

Well, you probably don’t have a Doberman Pincher to Protect your Excel work, but you have easy-to-access tools that will help you out wit...

Wednesday, January 18, 2012

Solving Power!

›

Microsoft Solver is one of the most Overlooked tools in Excel, and bears occasional review. Although you may not have an immediate need...

Monday, January 9, 2012

Match and Index Revisited

›

Back in 2010, we took a look at the Power of using a table or database combined with the MATCH and INDEX tools in Excel. Due to the lack...

‹

›

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