If you use Pivot Tables then you will know the problem- I hope to help you with now. When you create your Pivot Table on certain columns of data, Excel will default to COUNT rather than the...
Recent Posts
Ever needed to use a VLOOKUP but don't you know exactly how to spell what you are looking for, for example you may not remember how to spell a product name or the spelling of a Sales Person. Is it...
Like Pivot Tables? Yes me too, I love them, but have you ever wanted to sort them differently, for example to show the top Sales Month by volume. Here is how to do it....really...
A lot of businesses still use earlier versions of Excel than 2007. If you find that you need to issue of share workbooks with such earlier versions then it is a good idea to run the Compatibility...
Easily Create A Sequence Of Regularly Spaced Time Intervals In Excel
Say you need to create regular appointment slots for a doctors surgery from 8 am to 12 noon, or times for interviewing job applicants. It's really easy to auto create a list of available appointments...
Calculate the Date After A Specified Number of Workdays In Excel
If you use Excel to project manage then you will know that most people work a five day week - Monday to Friday (if they are lucky). So if you have a project start date and the number of days it...