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...
It is really easy to insert line breaks into Excel cells, all you need to do is hit ALT+ENTER where ever you want one. I know that I normally use them to make text easier to read in cells, longer...
As far as Excel shortcuts go this really ranks as one of my favourites. I don't ever go to File Save as when I can simply hit F12. Yes that's it F12 and my Save As dialog box...
Do you often find yourself needing to fill a column with the weekday name only? Excel's autofill feature can make this easy for you. In this blog post, we will show you how to set up Excel to...
If you ever need to move or copy or move permantly a worksheet form one workbook to another then here is the best way to do it in Excel - using the Move or Copy Dialog Box. Firstly open the...
Having spikes in your data can sometimes make it difficult to carry out predictive analysis. These spikes can be due to seasonal fluctuations in sales, for example more sales of soft drinks and ice...