Archive | Microsoft Office

RENAME OUTLOOK.COM ACCOUNT IN NAVIGATION PANE IN OUTLOOK 2013

How to rename Outlook.com account in navigation pane in Outlook 2013?

If you setup your Outlook.com account in Outlook 2013 using Exchange ActiveSync and want to rename the account from [email protected] to Personal, you cannot rename it as a regular IMAP/SMTP account: File > Account Settings > Select account and then Change… > More Settings… However, you can rename the account by going to Send/Receive > Define Send/Receive Groups and edit […]

Continue Reading
Portrait-Landscape Page

Change page orientation in Word 2013 for one page only

In order to change the page orientation in Word 2013 for one page only you have to use Section Breaks. First you should enable Paragraph marks and other hidden formatting symbols to be easier to work in your document No go to the last page you want to keep current page orientation (usually the default orientation […]

Continue Reading
random numbers

How to generate random numbers in Excel

Here is how you can generate random numbers in Excel: Put all your possible characters into an individual cell, such as A1:

You can name this cell MySource. You could then use a formula such as the following to return the random string of characters (broken into individual lines for clarity, but it is still […]

Continue Reading
Excel Count Formula

Count Cells with Numbers

If you need to count all cells with numbers you can use the Excel COUNT function which counts cells that contain numbers. Its syntax is: =COUNT(value1, value2,…valueX). value1, value2,…, valueX  can be cell references, or values typed into the COUNT formula. Excel COUNT function example – count numbers in cells A2:A7. In the cell where […]

Continue Reading
Duplicated Values result

Find duplicate cells values in Excel 2010 & 2013

To quickly find duplicate values in a Excel spreadsheet you can use Conditional Formatting under Home tab. There is a special rule for this called Duplicate Values… Highlight the cells in which you want to find the duplicates and click on the Conditional Formatting | Highlight Cells Rules | Duplicate Values Select the formatting for duplicates and click OK.

Continue Reading