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, 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...

Tuesday, December 30, 2008

Use Conditional Formatting to Highlight Above-Average Values

›

Highlighting exeptional values can be a useful (and simply-done) analysis tool. Here is an easy way to highlight the Above-Average values in...

Tuesday, December 16, 2008

Right-click Tab Scrolling Buttons

›

Large Excel workbooks will commonly contain a great many worksheets that can be cumbersome to scroll through to find a particular item. A qu...

Tuesday, October 28, 2008

Quick Chart!

›

This has always been one of my favorite easy crowd-pleasers. To make a Quick Chart , simply select your table of date, and press F11. Bamm!...

1 comment:

Sunday, October 19, 2008

Beware: There May be Links in this Workbook!

›

If you are working within an Excel document that you may not be familiar with, be cautious before deleting or clearing a cell containing a ...

‹

›

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