Turn a Picture Into a Watermark

You can turn a picture, clip art, or a photo into a watermark that you can use to brand or decorate a document.

1. On the Page Layout tab, in the Page Background group, click Watermark.
2. Click Custom Watermark.
3. Click Picture watermark, and then click Select Picture.
4. Select the picture that you want, and then click Insert.
5. Select a percentage under Scale to insert the picture at a particular size
6. Select the Washout check box to lighten the picture so that it doesn’t interfere with text.

The picture that you selected is applied as a watermark to the entire document.

Sort by more than one column or row

You may want to sort by more than one column or row when you have data that you want to group by the same value in one column or row, and then sort another column or row within that group of equal values. For example, if you have a Department column and an Employee column, you can first sort by Department (to group all the employees in the same department together), and then sort by name (to put the names in alphabetical order within each department). You can sort by up to 64 columns.

Note: For best results, the range of cells that you sort should have column headings.

1. Select a range of cells with two or more columns of data, or make sure that the active cell is in a table with two or more columns.
2. On the Data tab, in the Sort & Filter group, click Sort.
3. Under Column, in the Sort by box, select the first column that you want to sort.
4. Under Sort On, select the type of sort. Do one of the following:
* To sort by text, number, or date and time, select Values.
* To sort by format, select Cell Color, Font Color, or Cell Icon.
5. Under Order, select how you want to sort. Do one of the following:
* For text values, select A to Z or Z to A.
* For number values, select Smallest to Largest or Largest to Smallest.
* For date or time values, select Oldest to Newest or Newest to Oldest.
* To sort based on a custom list, select Custom List.
6. To add another column to sort by, click Add Level, and then repeat steps three through five.
7. To copy a column to sort by, select the entry and then click Copy Level.
8. To delete a column to sort by, select the entry and then click Delete Level.

Note: You must keep at least one entry in the list.

9. To change the order in which the columns are sorted, select an entry and then click the Up or Down arrow to change the order.  Entries higher in the list are sorted before entries lower in the list.
10. To reapply a sort after you change the data, click a cell in the range or table and then, on the Data tab, in the Sort & Filter group, click Reapply.

Copy Formulas with the Fill Handle

1. Create the formula in the appropriate cell on the spreadsheet.

2. Click on that cell to make it the active cell.

3. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.

4. Drag the fill handle to copy the formula to as many cells as needed.

Save Time, Work Less: The Power of Using Macros to Complete Repetitive Tasks in Microsoft Word 2007

Product(s): Microsoft Word 2007
Audience(s): Business Professional.
Date(s): Thursday, August 26, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Are you tired of performing the same repetitive steps on document after document? Do you wish Word had an “easy” button? Then macros may be the tool for you. Macros allow users to record a series of actions within Word to be “played back” later. From simple to complex strings, macros help make you a more efficient user. This 60 Minute Webinar will help you save time by automating your tasks.

To Register: Click Here. Fee: $99.00

Link or Embed Excel Data into Microsoft Project

You can insert data from Microsoft Office Excel into Microsoft Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.

To use a view that is not on the View tab, click the arrow on Other Views, then select More Views. From the list on the More Views dialog, select the view that you want, and then click Apply.

3. In Project, select the location where you want to insert the data.
4. Right-click to select Paste Special.
5. On the Paste Special dialog, do one of the following:
* To paste the data, without a link to the source document, click Paste.
* To link the inserted data to the data in the source document, click Paste Link.
6. From the list, select Text Data and then click OK.

Add a command to the Quick Access Toolbar

1. On the ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
2. Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu.

Restrict changes in Word 2010

1.  On the Review tab, in the Protect group click Restrict Editing.
2. The Restrict Formatting and Editing pane appears.
3. In Formatting restrictions, Editing restrictions and Start enforcement, you can make selections that meet your formatting and editing needs.

Change the Appearance of Your Calendar: Change the Background Color

1. On the Tools menu, click Options, and then click Calendar Options.
2. Under Calendar options, in the Background color list, click the color that you want.

Notes:
* The color that you choose is applied to the Day and Work Week views. The Week and Month views use system background colors, which are gray and white, by default.
* The color that you choose is applied to weekday hours. A darker shade of the background color is applied to night and weekend hours.

Print Blank Calendars
You can use Microsoft Outlook to print a blank calendar. Blank calendars may be useful to take notes on or to consult when you meet to discuss a project with your team.

1. On the File menu, point to New, and then click Folder.
2. In the Create New Folder dialog box, in the Name text box, type a name for the folder.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, click Calendar, and then click OK.
5. In Calendar, in the Navigation Pane under the My Calendars section, select the check box for the calendar you created.
6. On the File menu, click Print.
7. In the Print dialog box, under Print this calendar, click the calendar you created.
8. Select the print style options you want, and then click OK.

Make Your Presentations POP! Using Transitions and Animations in Microsoft PowerPoint (2007)

Product(s): Microsoft PowerPoint 2007
Audience(s): Business Professional.
Date(s): Tuesday, July 20, 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Once you’ve created your presentation, it’s time to make it move. In this session we show users how to bring life to their PowerPoint presentations with eye-catching transitions that take you from slide to slide and a variety of animations which can be applied to text and graphic elements within slides. PowerPoint has helpful, simple ways of adding animations and transitions and we cover these as well as more advanced techniques to add custom animations and vary the order of animations for each slide.

To Register: Click Here. Fee: $99.00