Category: Excel Tutorials
Working with Percentages in Excel
Let’s face it, it is pretty impossible to completely avoid percentages in Excel. This post will make them clear, practical (and fun!)
Conditional Formatting
Using Conditional Formatting in an Excel list with the help of a formula is easier that you think.
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!
About the Workdays Function
Create a list of dates and eliminate all weekend dates as well as some holidays.