ComboProjects Recent articles and tutorials

0

Relative, Mixed and Absolute References

Absolute and Mixed references are a one of those dreaded features in Excel. It’s too bad because in only 30 minutes, you can set the record straight once and for all!

0

Creating Abbreviations with Excel VBA

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

0

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!

0

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!