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, March 27, 2013

Unique Values

›

There are times when manipulating Unique Values or Items in your database is essential to your analysis. Counting Unique Values F...

Wednesday, March 20, 2013

All Dates are Not Created Equal

›

As anyone who has used our favorite spreadsheet application for a significant amount of time knows, Dates can be occasionally tricky in E...

Wednesday, March 13, 2013

Choose CHOOSE!

›

Whether you are at a restaurant or working on a spreadsheet, having Choices is almost always a Good Thing . As we discussed in this blo...

Wednesday, March 6, 2013

Integrity through Validation

›

Maintaining the integrity of your data is essential in the creation of meaningful reports. The old GIGO adage, “ Garbage In, Garbage Out...

Wednesday, February 27, 2013

Five Quick Solutions!

›

I am reasonably sure that all of us would like to be more productive, especially if it requires no additional effort. Often, this entails...

Wednesday, February 20, 2013

Page Break Control

›

Although most of us would like to have a truly Paperless world, that day hasn’t come yet, and probably won’t for many years. In the mean...

Wednesday, February 13, 2013

The Surprising Ease of Database Functions

›

This week we are going to revisit what is typically referred to as an “ Advanced Excel ” function. The word “ Advanced ” can make it sou...

‹

›

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