Author: dlamarche


Creating Abbreviations with Excel VBA

A simple VBA procedure that turn an expression into an abbreviation.
Simple example: ‘International Business Machines’ would return IBM.


Annoyances With Pivot Tables

For many, Pivot tables are the top features in Excel. However there are a number of annoyances with them.
Learn about the options that will fix them all!


Building Nested Functions Easy

Once, a gentleman asked me if there are an easier way to nest a bunch if IF() together.
I showed him how I do it and I I got a good handshake from a much happier man!