Excel 2010 NL tips

Excel Formula Day of a Date

To ensure that the day is displayed after entering a date, a function must be used. In your Excel formula, use the TEXT function.

Set number of worksheets in Excel

When creating a new Excel workbook, three worksheets are created by default. To avoid unnecessary deletion, you can set this number to 1.

Export email addresses from Outlook to Excel

Exporting all email addresses from a specific folder in Outlook—for example, to use in a mailing—can be done in just a few clicks.

Remove Duplicates in Excel

You have a list of data, but it contains duplicate values. Here’s how to get a list with only unique values.

Excel 2010 Function: SUMIF Explained

The SUMIF function is used to calculate a total from a column if a condition is met in another column.

Keyboard Shortcut: Cell Formatting in Excel

By pressing the keyboard shortcut CTRL+1 while selecting a cell or multiple cells, the Format Cells dialog box opens. But even within the dialog box, you can work without using the mouse.