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, August 29, 2017

Pivot Tables – A First Look

›

This week, we will begin a brief series of posts regarding Pivot Tables . As I mentioned in my blog post seven years ago, much has been ...

Tuesday, August 22, 2017

Automating Macros

›

Continuing with the subject of using macros in your Excel workbooks, we are going to look at Executing Macros Automatically this week. ...

Wednesday, August 16, 2017

Recording Macros

›

Ah, Macros… The wonderfully mysterious tools of glorious geekdom! As is the case with many otherwise meaningful and useful words in busin...

Monday, August 7, 2017

Conditional Formatting Rule Manager

›

Conditional Formatting is, as many of us know, an excellent way to visualize trends, spot abnormal values, provide quick analysis, and m...

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

‹

›

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