Excel Digest

You can save yourself allot of typing if you know how to make use of autofill feature in Excel.
Suppose you want to enter names of days in cells A1 to A7 (Sun, Mon, …. Sat). Here is what you do:

Enter “Sun” on cell “A1”.
Drag the fill handle across the [...]

Excel provides a vast number of common date formats. However if you do need a format that is not included in the built-in list then you can create your own custom format as follows:

Right-click on the cell where the date is.
Select Format Cells.
When the dialogue box opens select the Number tab.
In the Category [...]