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/

Monday, April 27, 2009

Concatenation & Email

›

Having a spreadsheet of employee names is great, but what if you want to use your data for sending emails? Concatenation to the Rescue! Le...

Monday, April 20, 2009

“Watching the Action”

›

Keeping an eye on the values of certain Excel cells can be problematical if you are working with a large spreadsheet (or multiple spreadshe...

Monday, April 13, 2009

MCAS in Excel 2007

›

Education and certifications are good hedges against being downsized in these recessionary times. Microsoft has a focused recognition prog...

Monday, April 6, 2009

Moving or Copying a Worksheet

›

This is a simple tip that you will probably find very handy. If you ever find the need to relocate or copy a worksheet into another workbook...

Monday, March 30, 2009

Validation with a Named Range

›

Using a list with the Validation tool in Excel is a useful way of maintaining consistency in a spreadsheet. Combining it with a Named Rang...

Wednesday, March 25, 2009

Freeze Panes

›

This is a very simple, but highly useful Excel maneuver. If you have a long list of data and you want to keep the headings on the screen , ...

Friday, March 20, 2009

Find What You Want Where You Want

›

If you work with large amounts of data, you probably find yourself in need of searching for specific items in specific regions of your Excel...

‹

›

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