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 26, 2013

Excel Lists for Email

›

This topic came up again in one of my Excel classes this week and, considering how incredibly useful it can be to so many of us, I thought...

Thursday, September 19, 2013

INDEX + MATCH = INFORMATION

›

There are many ways to look up information in tables and databases. Excel provides us with functions such as VLOOKUP , DSUM , DGET , SUMP...

Thursday, September 12, 2013

Indirectly to the Point

›

Using Named Ranges in your work in Excel is a highly recommended Best Practice . A problem may arise when trying to refer a Named Range...

Thursday, September 5, 2013

Spreadsheets: The Big Three

›

Spreadsheet applications have been around for quite a long time and, as is typical of technical evolution, the strong have survived while...

Thursday, August 29, 2013

Handling Duplicate Data

›

Handling Duplicate Data is well-known to be a Vexing Problem for many Excel users. There are tools within Excel that simply delete a...

1 comment:

Wednesday, August 21, 2013

Why to Use AutoCorrect...

›

“I Haven’t Got Time to Save Time”. You may not have ever heard or said these words, but the fact is that many people conduct their profe...

Tuesday, August 13, 2013

Embedding Excel in Other Programs

›

We all agree that Excel is the Quintessential Tool for crunching numbers and developing corporate information. There are times, however,...

‹

›

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