Category Archives: Learning

Speaking to Excel

I’ve gotten a lot of inquiries lately about using speech recognition in Excel.

The fastest way to learn to apply Utter Command to Excel is to read UC Lesson 10.9: Navigating, numbers, functions, selecting and formatting in tables and spreadsheets, and UC Lesson 10.10: Putting it all together in any program (say “UC Lesson 10 Point 9” and “UC Lesson 10 Point 10” to call them up). Then take a look at the Top Excel Guide, which opens a list of useful shortcuts along the right edge of your screen.

Here are some basics:

  • “Cell” followed by a letter and number jumps to any cell, e.g. “Cell B 2” or “Cell Bravo 2”
  • “Control Space” selects the row the cursor is on
  • “Shift Space” selects the column the cursor is on

Here are some particularly useful combinations:

  • A number followed by a direction selects cells — keep in mind you can select in two directions at once, e.g. “3 Rights · 5 Downs” to select 3 columns to the right and 5 rows down
  • “3 Downs · Control d” selects 3 rows down, then invokes the fill function to copy whatever was in the first row to the selected rows

And here’s a method that will save you time whether you use one formula or many:

Add the formulas you use to the Vocabulary Editor, with a comfortable spoken form. For instance “Equals Sum” to type “=SUM(”

To add a formula, say

  1. “NatSpeak Vocabulary”
  2. Speak the formula using “spell” to put the written form in the Written Form text box, e.g. “spell equals caps Sierra Uniform Mike close paren” to type “=SUM(“
  3. “1 Tab”
  4. Put a comfortable and memorable written form in the spoken Form dialog box, e.g. “equals sum”.
  5. “Enter”
  6. Escape” to exit or “Written Form” to add another.

Now every time you want to type “=SUM(“, say “equals sum”.

New Videos: The Whirlwind Tour

Check out our new videos — UC Whirlwind Tour part 1 and UC Whirlwind Tour part 2.

The Whirlwind Tour gives you a taste of what you can do with Utter Command in some key areas:

  • Controlling the Utter Command menu
  • Opening and closing programs
  • Clicking the mouse
  • Moving and sizing windows
  • Using Windows and program menus
  • Opening files and folders directly
  • Dictating and closely editing in any program
  • E-mailing
  • Using the Internet

There’s a printed copy of this tour, including cross references, in Getting Started. UC also includes an on-screen guide for this tour (say “UC Whirlwind” and the Whirlwind Tour commands will appear in a narrow on-screen guide window on the right side of your screen — other programs will size around).

Watch the tour, then use the on-screen guide or a printout of Getting Started to take it yourself.

What’s your favorite UC command? What would you like to see a tour on? Reply here or let me know at info@ this website address.