Skip to main content

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)



  Dragon for Mac 5



Comments

Popular posts from this blog

How US Tax Reform Affects Patients with Chronic Illness

It was messy, but it is finally done and over with! On December 22, 2017 the tax reform bill, or 'a giant tax cut ' as President Trump calls it, has finally been passed by both houses and has been signed into a law.

It is not immediately obvious how the tax plan impacts patients with chronic illnesses. Views in the media are often tainted by the political prism through which the commentators tend to look at this issue. Plus there is limited discussion of the specific provisions that can affect patients with chronic illnesses.

In this post, I am outlining some of the major provisions of the final bill that may affect chronically ill patients. Bear in mind that I am not a professional in accounting and taxation. However, I seem to have had more than my fair share of tax problems and as a result, I have become overfamiliar with the IRS website and publications.

Article continues after the ad
To make it easier to wrap our brains around this complex piece of legislation, I have div…

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 included in the list.
(The …

How I Healed My Shoulder Tendinitis

Shoulder Tendinitis is a common cause of shoulder pain. A more accurate term for it is Rotator Cuff Tendinitis. It means that one or more of tendons that make up the rotator cuff are inflamed. In my experience, even though this is not a serious injury, it is often debilitating and takes a long time to heal. I have had three recurring episodes of shoulder tendinitis in the last one year. I tried a variety of treatments but in the end, Kinesiology Tape along with frequent icing proved to be the most effective approach.
Article continues after the ad

Here is an account of my experience.
The initial symptoms
I developed shoulder tendinitis for the first time in my life due to shoulder pull ups. I was doing the pull ups as a part of a physiotherapy regimen to help me become functional after multiple years of disabling neck pain. Since I was also suffering from chronic abdominal pain, I was unable to lift any weights. So in order to rebuild the upper body strength, the physiotherapist suggest…