Dragon Naturally Speaking Tutorial : How to Format Columns in Microsoft Excel

In this Dragon NaturallySpeaking tutorial, I show how to format a column in Microsoft Excel using speech recognition.

While working with Microsoft Excel, you may be required to format a column, for example, if the column contains a specific type of data such as dates or a dollar amount. To achieve this using Dragon Naturally Speaking, first bring up the format column dialogue box using the command "Format Column". Now you can navigate and choose any particular options using different Dragon Naturally Speaking commands.

The most convenient way to navigate is to simply say the name of the option. For example, you can simply say "Currency" to select the currency option. There is one particular case in which this may not work. In Microsoft Excel, the option "Number" is located within the tab also called as "Number". Dragon Naturally Speaking will then just go to the tab but will not navigate to the option because it has no way of determining whether the user wanted to go to the tab or to the option. To avoid the confusion, you can use the commands "Move down/up x line ".

A faster way to navigate is to use Knowbrainer 2017 command - "Display Numbers". This will display a number over each clickable item and then you can simply choose a particular item by saying the number displayed over it.

Here is a YouTube video that explains how to format a column in Microsoft Excel 2010 with Dragon NaturallySpeaking premium 13 :

About Dragon NaturallySpeaking:

Dragon NaturallySpeaking is the most popular speech recognition software on PC. Dragon Dictate / Dragon For Mac is the counterpart of Dragon NaturallySpeaking on Apple Macintosh computers.

Windows:

At the time of writing this blog post, Dragon NaturallySpeaking Professional Individual 15 is the recommended version for most users. However, I continue to use Dragon NaturallySpeaking premium 13) (approximately $100) because of version 15 incompatibility with Natlink. If your needs are limited to email and web surfing, then you may just want to purchase Dragon naturally speaking home 13 (about $ 50) .

Mac:
Dragon professional for Mac is the recommended version (costs around $ 300) .

You can download the appropriate version directly from the company's web store from the links below. (They usually run discounts once every month so you can be on the lookout for the deals from the online store and purchase accordingly)

Comments

Reduce finger, wrist and forearm pain due to computer mouse usage with Gentle Mouse

If you are reading this on a computer screen, chances are that you would have clicked your mouse at least a couple of times to navigate through this content. And in most cases, the finger used to click would be your index finger. Now imagine doing this repetitive movement every few minutes, day after day, year after year and you can easily infer that your fingers are at an increased risk of repetitive stress injury (or RSI) due to mouse overuse. The common name given to this painful condition is Mouse Finger . The 'Finger' in Mouse Finger usually leads a person to believe that the pain is restricted to the fingers alone. However, from what I have surmised after reviewing anecdotal evidence and medical literature, it commonly presents as a cluster of symptoms in the finger, wrist and the forearm. Perhaps that explains why there are no easily available research studies pertaining to Mouse Finger alone. Most of the research studies consider these symptoms as a p...

Chronic pain : Tools of trade

Over the course of several years that I've spent in dealing with chronic pain, I have discovered a number of items that helped to reduce the pain and keep me functional. Here is a list of 10 items that I use frequently : Thermotex infrared heating pad . ( Video review ) I have used this since 2007 and it is still working very well. At the time I bought this, I thought it was pretty expensive. Now that it has been 9 years and the pad really reduced the need of pain medication on several occasions, I think it has paid for the investment several times over . I have mainly used it for abdominal muscular pain. There were times that I have wrapped it around the abdomen and slept at night. The main advantage of infrared is that it penetrates deeper and does not heat up the skin like a conventional heating pad. A good side effect of using it on the abdomen is that it reduces my tendency for constipation . It is also been very useful whenever I had any pathology n the rectum like an...

Strengthening Exercises While Being Bedridden

If you are frequently bedridden due to illnesses like chronic pain , chances are that you will tend to lose muscle mass. Less muscle strength can lead to increase pain thus causing a vicious cycle of chronic pain. It is important therefore to find a way to exercise and strengthen the muscle despite being bedridden . Over the years, I have found myself frequently to be in this situation due to fibromyalgia . There are several videos about exercises for the bedridden patients(for example, this ). However, the exercises in these are more to improve mobility rather than increase muscle strength. Ultimately, I spent quite a bit of time compiling a list of exercises from YouTube that exercise and strengthen every major muscle group. The list is provided below along with the major muscle groups that they exercise.As I have suffered from injuries because of using weights incorrectly, I recommend trying only with the resistance bands initially and that is what I have includ...

Living with fibromyalgia

Search This Blog