If you create multiple charts in Excel, this tutorial is a game-changer. You may or may not have noticed that by default, Excel will create a Column Chart. You can easily set your preferred chart...
Tag: Excel
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...
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...