The TrainingAuthority.

=Proper(Cell) formula in Excel

In this example, I copy and pasted a list of the 3 most expensive paintings of all time.

The ‘Proper’ function allows me to quickly transform the data so that every word is capitalized. Simply type =proper(The cell you need to change).

1. Right-click on an email from your Inbox that has more than one email in the string
2. Choose Find Related, then Messages in This Conversation which will display the list of results with the queried info highlighted in yellow
3. All emails with the same subject will be listed. By double-clicking on any of them, the email can be opened.

1. On the Design tab, select Colors and Create New Theme Colors.

1. Click the drop-down next to each Theme color (for your Text/Background, Accents and Hyperlinks) and select the desired color choice.
2. Enter a Name for your Custom Theme.
3. Click Save when finished.
4. The new color scheme will now be available on the Design tab in the Colors theme list.

Creating Hyperlinks in Word 2010

1. Highlight text in your document that you want to be linked
2. In the Links group of the Insert tab, click on the Insert Hyperlinkbutton
3. Enter the web address in the pop up window if you are linking to a website or the file server
4. If you are linking to a place in the same document click on Place in This Document
5. In the Selection box, scroll down until you see the list of Bookmarks then click on the desired bookmark
6. Click OK to finish

• With Word open, click the Home tab.
• In the Font group, click the Font dialog box launcher in the lower right hand corner.
• In the Font section, change the Font Style. If desired, change the Font Size.
• At the lower left-hand corner of the Font Dialog box, click Set as Default.
• Click Yes when prompted to change the default.

1. Copy a column chart from Excel.
2. Paste it onto a blank PowerPoint slide.
3. Select the Chart.
4. Click the Animation Tab.
5. Select the Fade In effect or any other desired entrance.
6. Click on the Effects Options drop-down menu and choose By Series, By Category, By Element in Series, or By Element in Category.

1. From a new mail message, click the Optionstab.
2. In the Tracking group, click Use Voting Buttons.
3. Select one of the default voting choices, or click Custom to create your own (separate choices by a semicolon).
4. Edit and send the message as you normally would.
5. To view the results, click any response or view your original message. You can also open your original email and click on the tracking tab to view all responses together.

Here is a quick formula that calculates the current date each time you open your spreadsheet.

1. Select a cell
2. Type the following formula: <Today()
3. Press Enter

1. Now that cell will always display the current date and can be referenced in other formulas

NOTE: you can also use the Now command if you would like to include the time as well: <Now()