Dashboard skills are in great demand by employers, if you can build great dashboards; it is a valuable skill to have. Even better if you can build them in one of the most widely used pieces of...
Tag: Excel Tips
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...
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...