Today I\u2019d like to take some time to walk you through working with spreadsheets in Microsoft Excel. Many of the concepts we will cover can apply to online versions, and even to Google Sheets. However, today we will be focusing on the desktop version of Microsoft Excel.<\/p>\n
When you open a blank excel sheet, you are in a huge table with nothing in it. That is where you come in. Excel is very good at sorting and calculating. If you think of Excel like a giant table that can do some fancy things with Math, you\u2019re getting the right idea. If you ever played the Battleship game as a kid, you could think of that. Remember the grid starting in A1? That could also help you visualize what you are doing in Excel. Most of the commands I will give you will be Excel-related commands, which will work regardless of whether or not you are using a screen reader. If a command is screen reader-specific, I\u2019ll indicate that.<\/p>\n
I don\u2019t want to drown you in terminology, so I\u2019ll keep this quick and simple. These are the basic terms you\u2019ll need to use Excel like a boss.<\/p>\n
We are going to make a very simple spreadsheet. It only has two columns, so you won\u2019t get lost. First make sure you are in a blank Excel sheet. You will start on the cell A1.<\/p>\n
Now without moving anywhere, type the word Snacks.<\/p>\n
Next, press the TAB key. You will now be in cell B1.<\/p>\n
Type Cost, and press ENTER.<\/p>\n
You are now in Cell A2.<\/p>\n
Now we have the two columns set. You can move around the sheet with your four arrow keys. You can also go to a specific cell with the keyboard command CONTROL+G. After pressing this command, type the cell reference such as A1 and press ENTER. Later we will also use this command to select a range of cells. To do this, just type something like A2:B10 and press ENTER. Note the colon between the two cell references. Also, capitalization does not matter here.<\/p>\n
Now, before we start entering our snacks and prices, we need to tell the screen reader where the column headers are. You know that they are in cells A1 and B1, but your screen reader doesn\u2019t know that yet.<\/p>\n
If you want your screen reader to read the column headers as you move left\/right, regardless of where you are on the sheet, start by going to your first column header. In our case it is A1. Either arrow to A1 or use the Go To command.<\/p>\n
If you are using NVDA, press NVDA+SHIFT+C. The NVDA key is either INSERT or CAPS LOCK depending on your settings.<\/p>\n
If you would also like to have column A to be read automatically as you arrow down through the rows, make sure you are at A1, then press NVDA+SHIFT+R.<\/p>\n
Now for JAWS users, The JAWS Key is also either the CAPS LOCK or the INSERT key. Once you are in the right spot, Press JAWSKEY+CONTROL+ALT+C. This will tell JAWS to speak the column headers across the top.<\/p>\n
If you want to make JAWS speak row headers down the A column as well, press JAWSKEY+CONTROL+ALT+R.<\/p>\n
These commands will tell your screen reader to speak everything across the top and down the left side of your data. This way as you are arrowing through your sheet, you will not need to keep checking what column\/row you are in. Of course, in this case it really doesn\u2019t matter too much, but if you found yourself in a sheet with 20 or 30 columns and 100 rows, this would be crucial to get setup correctly.<\/p>\n
For the sake of this simple walkthrough, we are only going to type in three different snacks along with their prices. So, let\u2019s get started\u2014I\u2019m gettin\u2019 hungry!<\/p>\n
First move to cell A2. Type BBQ Chips and press ENTER.<\/p>\n
You should now be in cell A3. Type Cookies and press ENTER.<\/p>\n
You are now in cell A4. Type Brownies and press ENTER.<\/p>\n
We are now in cell A5, but we are not creating more snacks. Feel free to keep creating them if you\u2019d like though.<\/p>\n
Now we are going to cell B2. For the prices, do not type dollar signs; we\u2019ll have Excel do that for us later.<\/p>\n
Type 1.25 and press ENTER.<\/p>\n
Now you are in cell B3. Type 1.5 and press ENTER.<\/p>\n
Now you are in cell B4. Type 1.75 and press ENTER.<\/p>\n
Now you are in Cell B5. Arrow down one more cell to B6. We are going to have Excel automatically calculate the total price of these snacks just so you can see how a very simple formula works.<\/p>\n
Press ALT+= (that is ALT+EQUALS), then press ENTER.<\/p>\n
You will land in cell B7, so arrow up to cell B6. You should hear 4.5.<\/p>\n
The cool thing about this formula is it will automatically recalculate in real time whenever anything in the cost column changes as long as it is above B6. So, if you did enter another snack in cell A5, and a price in cell B5, your total in cell B6 would instantly change. Actually, let\u2019s do that now.<\/p>\n
Go to A5, type a snack of your choice, and press TAB.<\/p>\n
You are now in B5, so type a price for your snack. When you arrow down to B6, you should see that your total changed. Cool, huh?<\/p>\n
Excel does not know that the numbers in the cost column are supposed to be dollars, so let\u2019s change that.<\/p>\n
First, we need to tell Excel the cells to interact with. So let\u2019s use the Go To command (CONTROL+G). Type the cell reference: b2:b6 and press ENTER.<\/p>\n
Now let\u2019s get into the Format Cells dialog box. To do this, press CONTROL+1 on your numbers row across the top of your keyboard.<\/p>\n
Tab once to Category, arrow down to Currency and press ENTER.<\/p>\n
You will now be back in your snacks sheet. As you arrow up and down through the Price column, you should now hear dollars and cents as would be appropriate for a snacks price listing.<\/p>\n
We are still in the cost column, and we are going to sort the prices from highest to lowest. Navigate to cell B2 and either use your applications key or press SHIFT+F10.<\/p>\n
Arrow to Sort or press the letter O.<\/p>\n
Now arrow to Sort Largest to Smallest and press ENTER.<\/p>\n
You will be back in your sheet, and you will notice that Excel has kindly rearranged your data accordingly.<\/p>\n
Let\u2019s try one more sorting function.<\/p>\n
Navigate to cell A2.<\/p>\n
Get back into your sort menu, but this time you will choose Sort A to Z\u201d. Again, you will notice that your data has been rearranged accordingly, and your snacks are now in alphabetical order.<\/p>\n
Ok, you\u2019ve made it! Hopefully you now have a much better idea of using excel in a personal or professional setting. There is of course much more to Excel, but I\u2019ll leave you with this much for now. May all of your spreadsheets be error free!<\/p>\n
Qapla!<\/p>\n","protected":false},"excerpt":{"rendered":"
Today I\u2019d like to take some time to walk you through working with spreadsheets in Microsoft Excel. Many of the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[12,123,122],"tags":[384,221,130,220,268,383],"class_list":["post-5890","post","type-post","status-publish","format-standard","hentry","category-general","category-jaws","category-nvda","tag-data","tag-excel","tag-microsoft","tag-office","tag-productivity","tag-spreadsheets"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9GTYL-1x0","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1007,"url":"https:\/\/webfriendlyhelp.com\/create-professional-documents-quickly-with-office-templates\/","url_meta":{"origin":5890,"position":0},"title":"Create Professional Documents Quickly with Office Templates","author":"Casey","date":"June 25, 2019","format":false,"excerpt":"I want to start this article by asking you to use your imagination. Maybe you\u2019re in your home office, or even working in a corporate office somewhere. One of your coworkers comes up to you asking you to create a business flyer, invoice, company memo, or any other complex document.\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/webfriendlyhelp.com\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5491,"url":"https:\/\/webfriendlyhelp.com\/features-and-accessibility-of-the-top-three-remote-meeting-platforms-zoom-teams-and-meet\/","url_meta":{"origin":5890,"position":1},"title":"Features and Accessibility of the Top Three Remote Meeting Platforms: Zoom, Teams, and Meet","author":"Casey","date":"February 2, 2021","format":false,"excerpt":"Some of my readers have been asking about differences between Zoom, Microsoft Teams, and Google Meet. I started researching the differences between the big three meeting platforms, and the below info has been culled from various online resources. At the end of this article, I\u2019ll provide a handy table with\u2026","rel":"","context":"In "Apps"","block_context":{"text":"Apps","link":"https:\/\/webfriendlyhelp.com\/category\/apps\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10511,"url":"https:\/\/webfriendlyhelp.com\/optimizing-windows-for-assistive-tech-users-practical-tips-to-improve-efficiency-and-accessibility\/","url_meta":{"origin":5890,"position":2},"title":"Optimizing Windows for Assistive Tech Users – Practical Tips to Improve Efficiency and Accessibility","author":"Casey","date":"February 29, 2024","format":false,"excerpt":"In this article, I will explain many settings that I tweak to enhance the usability and accessibility of Windows for my customers. If you happen to be a member of my Tame your tech services, I\u2019ve already done these for you. However, this list could be beneficial for anyone looking\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/webfriendlyhelp.com\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4355,"url":"https:\/\/webfriendlyhelp.com\/write-with-your-voice-use-microsoft-dictation-on-your-pc\/","url_meta":{"origin":5890,"position":3},"title":"Write with Your Voice: Use Microsoft Dictation on your PC","author":"Casey","date":"August 11, 2020","format":false,"excerpt":"Before we dive in, I want to first get a few things out of the way. While dictation is very exciting, it doesn\u2019t take the place of learning to use a keyboard if you are able to do so. If you use a screen reader, dictation will not replace the\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/webfriendlyhelp.com\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5191,"url":"https:\/\/webfriendlyhelp.com\/locate-deals-with-microsoft-edge\/","url_meta":{"origin":5890,"position":4},"title":"Locate Deals with Microsoft Edge","author":"Casey","date":"December 15, 2020","format":false,"excerpt":"The below information was taken from a Microsoft Blog. I have added comments at the end that should help screen reader users. If you would like to see screenshots of the areas described, check out screenshots in the original article. Now, here\u2019s Microsoft. Snip Holiday season is quickly approaching and\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/webfriendlyhelp.com\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":743,"url":"https:\/\/webfriendlyhelp.com\/how-you-can-use-narrator-to-download-the-screen-reader-of-your-choice\/","url_meta":{"origin":5890,"position":5},"title":"How You Can Use Narrator to Download the Screen Reader of Your Choice","author":"Casey","date":"January 30, 2019","format":false,"excerpt":"What do you do once you have setup your computer? Before you can truly begin to use it, you may want to download either JAWS or NVDA. Of course you could use Narrator exclusively, but that is not the topic for today. For now, I want to help you get\u2026","rel":"","context":"In "Jaws"","block_context":{"text":"Jaws","link":"https:\/\/webfriendlyhelp.com\/category\/jaws\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/posts\/5890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/comments?post=5890"}],"version-history":[{"count":0,"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/posts\/5890\/revisions"}],"wp:attachment":[{"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/media?parent=5890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/categories?post=5890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webfriendlyhelp.com\/wp-json\/wp\/v2\/tags?post=5890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}