Re: need instructions for getting started in excel


Mcginnis, Barbara
 

Please let me know if this helps.

Excel is a spreadsheet program that is part of the Microsoft Office package. A spreadsheet program allows you to organize data into columns and rows, analyze data and perform calculations on it.

There are three kinds of entries in spreadsheets: text, numbers and formulas.

You can use a spreadsheet to create a variety of files, including income statements, financial statements, budgets, databases and invoices.

Excel opens with a new blank workbook for you to enter and analyze data and to maintain lists of information.

An Excel file is referred to as a workbook. That is because it is like a book made up of pages. These pages are known as worksheets or spreadsheets.

A spreadsheet is made up of columns and rows. The columns are headed with alphabetic characters and the rows are headed with numbers. There are 16,384 columns. Since there are only 26 letters in the alphabet, Excel gets to columns Z and starts over with AA, AB, AC and all the way to AZ and then moves to BA. BB, BC and so forth

A small rectangle appears whenever a column and row intersects. These rectangles are known as cells. All cells have addresses. The address of the first cell in the upper left corner of the spreadsheet is column A and row 1 or A-1. The active cell has a dark box around it. When you type date, it automatically goes into the active cell.

If your hands are on the keyboard, it is faster to use keyboard navigation. Using keyboard navigation, the active cell moves with you.

The keyboard shortcuts are:

Control plus home moves to cell A
Control plus end moves to the end of data in the spreadsheet.
Home moves to the beginning or to the first cell of the row
Page down moves down one screen
Page up moves up one screen
Left, right, up, and down arrow moves one cell to the right, left, up, or down.

The fastest way to move to a cell is to use the Go To command, Control plus G. Type the cell address in the Go To dialog box and press Enter.

Entering data in a worksheet is a two-step process. One you type data in the cell, the next step is to complete the entry. If you suddenly realize that you selected the wrong cell, you may want to cancel the entry.
Pressing enter makes Excel complete the entry and the active cell moves down one row.
Pressing tab makes Excel complete the entry and the active cell moves right one column
Pressing an arrow key makes Excel complete the entry and the active cell moves in the direction of the arrow.
Pressing escape makes Excel remove any data typed in the cell and the active cell remains active.

-----Original Message-----
From: Barbara Hansen via Jfw [mailto:jfw@lists.the-jdh.com]
Sent: Tuesday, September 22, 2015 5:26 PM
To: Jfw lists <jfw@lists.the-jdh.com>
Cc: Barbara Hansen <the2skibears@embarqmail.com>
Subject: need instructions for getting started in excel

Hi list Friends,



I am needing some basic instructions for getting started in excel. A couple of months ago, I saved some information from someone on this list pertaining to getting started in excel, however; when I tried to open the saved email, my computer says that I am trying to open MS outlook 2013, therefore, I cannot get to this information. I am using MS2010.



When I open the excel program, a table comes up in rows and columns. I know how to navigate from column to column and row to row. Do I just start creating a table as I would in doing a table in word? I am thinking there is more to this.



I write grants for our local radio reading service program, and my goal is to create a document that will reflect the amount of monies received from each foundation, indicating amount spent for each budget item requested in the grant. This is basically for my own personal use, but could also be provided to the donors if requested.



I have looked in the JAWS guides etc. and have downloaded one R&R file about columns, rows, and headers. I'm not sure if this will provide instructions for getting started in creating an excel document.

Any suggestions would be greatly appreciated and I will save comments to just a word document instead of saving the email.



Live and learn.



Barbara Hansen



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20150922/25fe8000/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

________________________________

Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized State official. Unauthorized disclosure of juvenile, health, legally privileged, or otherwise confidential information, including confidential information relating to an ongoing State procurement effort, is prohibited by law. If you have received this email in error, please notify the sender immediately and delete all records of this email.

Join main@jfw.groups.io to automatically receive all group messages.