This tip I find useful in converting the Irish/UK take on temperature in comparison to the USA temperatures, I usually like to see the trends of temperatures of where I am going on my regular road...
Category: Formulas
Welcome to Session 4 of Pivot Table Week. Thanks for joining me again for Session 4 in Pivot Table Week. Today we will be looking at additional calculations in If you need a recap of...
How To Count Unique Items In A Range Of Cells Using Advanced Filtering
Whilst using Excel there will be a good number of scenarios where you want to find the number of unique values you have in a range of cells. this could be Customer Names, Invoice Numbers, Order...
Extra Free Day For Everyone- What Will You Do With Yours? Learn More About Excel Dates?
Every four years we get an extra day, how cool is that, so just what will you do with your extra day this February?. You could use it to learn more about date calculations in Excel?...Why...
Most of the time in Excel an AutoFilter would enable you filter lists in the ways you need to, But, in some cases you may need or want to exert more control of over the way filtering operates....
Do you use Excel regularly but are overlooking one of its most powerful features? The LEN function is a great tool for users seeking to calculate the length of text and numbers stored in their...