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/

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

Tuesday, September 30, 2008

Favorite Keyboard Shortcuts

›

Keyboard Shortcuts can add speed, comfort, and enjoyment to your Excel experience. Although there are dozens, (you probably use some alread...

Monday, September 22, 2008

Obtaining a List of Unique Names

›

Obtaining a list of Unique Names is often a beneficial function in Excel. The good news is that it is Easy! First, select the original ra...

Monday, September 15, 2008

Naming Ranges: Why & How

›

Why Naming ranges in Excel can save you a lot of time and make your formulas more intuitive. Using a named range in a formula does away wi...

‹

›

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