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, July 31, 2017

Freezing Columns or Rows

›

When you have a large table or database, and you wish to keep the headings visible , it is an easy matter to Freeze the Panes so yo...

Tuesday, July 25, 2017

Quick Analysis

›

Viable Shortcuts are the domain of true experts. As I have always said, “There is no glory in effort”, and genuine Excel specialists mak...

Tuesday, July 18, 2017

REPT Function + Wingdings

›

As I have mentioned in the past, the REPT function is an often overlooked and underused tool in Excel. Here is a Fun (and hopefully insp...

Tuesday, July 11, 2017

Forecasting

›

Forecasting is a vital function in nearly every business. Are your company regional sales going to rise, fall, or remain about the same...

Wednesday, July 5, 2017

Add Leading Zeroes with REPT

›

REPT is one of those functions in Excel that most users find obscure and of little use. I have to admit that I was one of those users ...

Monday, June 26, 2017

VBA – Why/Why Not?

›

For those special individuals with proper skills, there is a massive amount of Hidden Power lurking in the depths of Excel. VBA – Visu...

Tuesday, June 20, 2017

Transcend VLOOKUP!

›

You want to look up information in a table or database, and you wonder, “Which is better, VLOOKUP or the combination of INDEX and MATCH ...

‹

›

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