Showing posts with label Microsoft Office. Show all posts
Showing posts with label Microsoft Office. Show all posts

Monday, January 4, 2010

Use Voice Command Office

Microsoft OfficeSame with Windows Media Player, you can also use a voice command Office or the so-called speech recognition. In addition, you can also dictate or select menus, toolbars, and dialog boxes using voice (in English).

Never use this application? You can do the installation by clicking the "Speech" on the Tools menu in Microsoft Word, or run a Custom installation during installation of Microsoft Office. Once installed, the button will appear in Speech Tools menu in all Microsoft Office programs.

To start using it, you need a microphone connected to the sound card or USB, a computer with a minimum speed of 400MHz or more, at least 128MB RAM or more, and Windows 98 until the latest.

There are two options available modes of this feature, the Voice Command and Dictation. Voice Command mode allows you to give commands in Microsoft Word, for example, to select menus, toolbars, dialog boxes, or to change the format of the document. While to dictate Microsoft Word so you do not need to type them with the keyboard, select Dictation mode. To switch between Voice Command mode and Dictation, just click the button on the Language bar or by saying "voice command" or "dictation" on the microphone.

Examples of speech recognition to change the font via voice:
1. To open the Font box on the Formatting toolbar, saying: "td".
2. To change the font of Times New Roman to Verdana, said: "verdana".
READ MORE - Use Voice Command Office

Automatic Text Reading Excel Data

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSoGyf7MUm34H-FRKbhmY1508rG8PrlPS4IoooO36jSaHGv3148N2RMcKRlT_7e1iZ5wJTmGBy_IUc-9vEUSXFN1wu2LQYB8DBQQfc8CAUSb6AIyG9vPHiBTZW6qdri4CrdE3fYlmgc-0/s320/excel_logo.gifWorking with a spreadsheet is not easy, especially if you are required to maintain the accuracy of the data contained there. Now, with Text to Speech feature, you can make the computer read any text that is inserted into Excel to do the verification. Here's how to activate it.

1. On the "Tools" menu, select "Speech", then click "Show Text to Speech Toolbar".

2. Select the cell you want to read.

3. On the toolbar "Text to Speech", click "By Rows" to the computer to read per line, or select 'By Columns' to the computer to read data per column.

4. Click the "Speak Cells" to the computer to read the cell that you select.

5. If you find errors in the data, click on "Stop Speaking", and then use the mouse to fix it.

6. Click the "Speak Cells" to continue.

In order for Excel to read any data you enter into the cell, this trick jajal.

1. On the "Tools" menu, select "Speech", then click "Show Text to Speech Toolbar".

2. On the toolbar "Text to Speech", click the "Speak On Enter". Furthermore, every time you enter data in a cell and press Enter, the computer will read the data in these cells.
READ MORE - Automatic Text Reading Excel Data

Lock and Hide Excel Formula

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSoGyf7MUm34H-FRKbhmY1508rG8PrlPS4IoooO36jSaHGv3148N2RMcKRlT_7e1iZ5wJTmGBy_IUc-9vEUSXFN1wu2LQYB8DBQQfc8CAUSb6AIyG9vPHiBTZW6qdri4CrdE3fYlmgc-0/s320/excel_logo.gifWhile working with formulas in Excel, you may feel the need to store and protect so that no change when you want to use it again. How?

Actually it's easy, even you can hide it all. Here's how.

• At first, first block of cells you want to hide the formula.

• Select the "Format Cell", followed by clicking on the tab "Protection". Enable "Locked" to lock and "Hidden" to hide it, then click "OK".

• Ensure that other cells do not come unlocked so that any time you can change existing data (Locked inactive, because its default active Locked) is to block all the cells would not be locked. Remember, do not activate the Locked and Hidden.

• Select "Tools> Protection> Protect Sheet ...". Dialog box will appear "Protect Sheet". Enable "Contents", then type the password that will be used, ending with "OK". Dialog box will show "Confirm Password" to make sure. Type the same password again, then press "OK". Presto! The formula will disappear suddenly.

• To bring it up again, select "Tools> Protection> Unprotect Sheet ...". Enter the password, then click "OK". Tada! The formula will reappear.
READ MORE - Lock and Hide Excel Formula

Site Info

 

Copyright © 2009 NdyShared | Blogger Templates Gallery. All Rights Reserved. Powered by Resources and Inspiration and NegeriAds.com Solusi Berpromosi | Portal News dan Entertainment | Download Film Gratis | Blogger Indonesia Dukung Internet Aman, Sehat & Manfaat | Ingat Solo Ingat Soloaja.com.