Category: Excel Tutorials


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!


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!