Author: dlamarche

0

Relative, Mixed and Absolute References

Introduction I’ve been teaching Excel since 1993 and if I had to name one feature that puzzles participants the most, it would be the one described in the title of...

0

Creating Abbreviations with Excel VBA

The problem Recently I was asked how hard would it be to take a company name and create the abbreviation of the name. For instance ‘International Business Machines’ would return...

0

Annoyances With Pivot Tables

Dealing with these annoyances Are you fairly new to Pivot Tables in Excel? If you are, you may have had difficulties to make them look clear and professional looking. This...

0

Building Nested Functions Easy

About Nested Functions In all the years that I have been training Excel Functions, there is a feature that consistently puzzles. I am referring to the creation of nested functions....

0

About Workdays

Workdays and days off Recently I was asked if Excel can create a three month sequence of dates where the non-working days were Sunday and Monday. It just happened that...

0

Why understanding counts?

Understanding equates with confidence. It is then that one will retain much longer and build upon to acquire further inferences. Also when a user understand a concept he/she is more...

0

Truth is … Understanding does matter.

The purpose of this site is to learn about intricate features of Excel and other features in Microsoft Office applications. An other important aspect is that an important section will...