Infero Training – Business and Technical Courses

Let’s say you want to format cells, so that you can display preceding zeroes for a number, for example, a phone number will always begin with a zero.

1. Select the cells that you want to format.
2. Right click on selected and from the menu choose the Format Cells
3. From the Number tab in the Category click on Custom.
4. Click in the Type box, delete the displayed content and enter zeroes that correspond to the size of the required number, for example if you want to display 5 numbers, enter 00000.
5. Click OK.

When you enter numbers into the formatted cells, the preceding zeroes will be displayed, for example if you formatted the cells as 00000, when you enter 123 you will get 00123

Unlike Microsoft Excel, Project doesn’t have an unhide feature. When you hide a column in Microsoft Office Project, the column is only removed from view, not deleted from your plan. Also, hiding a column doesn’t remove any information from your plan.

To bring the column back again, you need to insert the column like you would with any new column. Any custom formatting that you applied to a previously hidden column will need to be re-applied to the inserted column.

1. In a sheet view, select the column to the right of where you want to show the column.
2. On the Insert menu, click Column.
3. Select the Field name you would like to display.

Fed up receiving junk email? Then, configure the Junk Email Filter!

The Junk Email Filter is designed to catch the most obvious spam and send it to your Junk Email folder.

The Junk Email Filter analyses each incoming message according to several factors, such as the time when the message was sent, the content and structure of the message to evaluate the message on ‘spamness’. The Junk Email Filter is turned on by default, and the protection level is set to Low. This level is designed to catch the most obvious spam. You can increase the level of protection by changing it.

Follow the following steps if you want to reduce the amount of junk email:

1. In Microsoft Outlook from the Menu bar, go to Tools and choose Options.
2. On the Preferences tab, click Junk Mail.
3. Under Options tab select the level of protection:

• High – If you receive a large number of junk email messages, but do not wish to restrict the messages you see to only those from senders on your safe lists, select this option. However, you should periodically review messages moved to the Junk Email folder, because some legitimate messages may be moved there as well.
• Safe Lists Only – If you receive a large number of email messages, you can alternatively select this option, which will cause any email message that is sent neither from someone on your Safe Senders List nor to a mailing list on your Safe Recipients List to be treated as junk.