Minggu, 30 Maret 2008

How to Initiate a Chat Session from Within Groove by Using Office Communicator

Initiate a Chat Session from Within Groove by Using Office Communicator
When you are running Microsoft Office Groove 2007 and Microsoft Office Communicator 2007 or 2005, you can view the awareness states (such as online, busy, or away) of your Communicator contacts directly from the Groove Launchbar or a Groove workspace. When a contact is available, you can right-click to initiate a Communicator real-time chat or phone call with that contact directly from the Groove interface.

How to Set the Print Area in Microsoft Office Excel

Setting the Print Area in Microsoft Office Excel
Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how:
1. With a spreadsheet open, select all the rows or columns that you want to print.
2. On the Page Layout tab, in the Page Setup section, click Print Area, and then click Set Print Area.
3. Click the Print icon on the toolbar, or click the Office button, point to Print, and click Print. Only the required content gets printed.

Kamis, 27 Maret 2008

How to Use the Bcc Field in Outlook 2007

How to Use the Bcc Field in Outlook 2007
In Microsoft Office Outlook 2007, click New to open a new e-mail message, and then click Show Bcc on the Options tab

How to Apply Consistent Colors and Effects in MS Office Visio

Apply Consistent Colors and Effects Automatically Throughout Your Diagram in MS Office Visio

Use the new themes features in Microsoft Office Visio 2007 to quickly apply a consistent set of colors or effects throughout your diagram. Themes in Visio 2007 are separate from the document themes you may know from 2007 Microsoft Office system programs such as Word, Excel, and PowerPoint.

To use themes in Visio 2007, on the Format menu, click Themes. In the Theme-Colors task pane, click to apply a set of existing theme colors to your diagram, or click New Theme Colors (at the bottom of the task pane) to customize your own color set. Note that clicking the arrow that appears when you point to a color set shows you additional options.

To apply additional formatting, click Theme Effects to switch to the Theme-Effects task pane. You can then click to apply an existing set of effects (including text, line, fill, shadow, and connector formatting). You can also click New Theme Effects at the bottom of the task pane to create your own effects. Also, clicking the arrow that appears when you point to an existing theme effects set shows you additional options, including the option to duplicate a built-in set of theme effects so that you can customize it.

Selasa, 25 Maret 2008

How to use 2003 to 2007 Custom Slide Show

2003 to 2007 Custom Slide Show
Does showing the same Microsoft Office PowerPoint 2003 presentation to different audiences require you to manually hide and unhide irrelevant or confidential slides? With custom slide shows in Microsoft Office PowerPoint 2007, you can create and save multiple shows from the same presentation.
1. Click the Slide Show tab, and then click Custom Slide Show in the Start Slide Show section.
2. Click Custom Shows, and then click New.
3. Name the slide show, and then add the slides you want from the left box to the right box.
4. Reorder the slides if necessary, and then click OK.
5. You can start the slide show by clicking Show in the Custom Shows dialog box or by selecting it from the Custom Slide Show list on the Ribbon.

How to Create a Linear Series of Values in Excel

Create a Linear Series of Values in Excel
Here’s how to use Auto Fill to create a series of values:
1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
2. Select cells A1 and A2.
3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.

Senin, 24 Maret 2008

How to Insert Rows or Columns in Excel

How to Insert Rows or Columns in Excel
With a Microsoft Office Excel document open, you can insert extra rows and columns by holding down the SHIFT key while you grab a cell by its handle and drag it. Excel will insert as many cells as needed.