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