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...
Tag: Excel
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...
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...
Why you NEED to know how to build Business Dashboard Reports
Dashboards are a real buzzword we all know that. It is actually a term borrowed from the Car industry. That makes sense- all of the important information right in front of you. In the case of...