need instructions for getting started in excel


Barbara Hansen <the2skibears@...>
 

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>


Jim Portillo
 

You know, the Hadley school has a course dealing with getting started with Excel. Might check it out.

Sent from my iPhone 6!

On Sep 22, 2015, at 2:26 PM, Barbara Hansen via Jfw <jfw@lists.the-jdh.com> wrote:

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


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.


Barbara Hansen <the2skibears@...>
 

Hi Barbara M

The instructions you sent regarding excel were great! They provided the
basic info I needed to better understand the excel program.

I believe there is also something involved regarding doing formulas in order
for the program to calculate and total numbers. Any help regarding this
would also be appreciated.

I have listened to a web&R training from Freedom Scientific on creating
headers and formula's, but, honestly, the presentation was not very useful
to me. I think there was about 3 sentences throughout the presentation, that
might be helpful to me.Glad I wasn't paying for it.

I would like to communicate with you off list, if that's okay. My email is:
the2skibears@embarqmail.com.

Thanks for your clear explanation of excel.

Barbara Hansen

-------------- next part --------------
An embedded message was scrubbed...
From: "Mcginnis, Barbara via Jfw" <jfw@lists.the-jdh.com>
Subject: RE: need instructions for getting started in excel
Date: Wed, 23 Sep 2015 11:56:25 -0400
Size: 6452
URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20150924/045c52bd/attachment.mht>


Mario
 

I've been following this thread, and I'd also would like to understand formulas, especially if there's a method to building your own.I think this kind of information is invaluable, especially myself.

On 9/24/2015 9:19 AM, Barbara Hansen via Jfw wrote:
Hi Barbara M

The instructions you sent regarding excel were great! They provided the
basic info I needed to better understand the excel program.

I believe there is also something involved regarding doing formulas in order
for the program to calculate and total numbers. Any help regarding this
would also be appreciated.

I have listened to a web&R training from Freedom Scientific on creating
headers and formula's, but, honestly, the presentation was not very useful
to me. I think there was about 3 sentences throughout the presentation, that
might be helpful to me.Glad I wasn't paying for it.

I would like to communicate with you off list, if that's okay. My email is:
the2skibears@embarqmail.com.

Thanks for your clear explanation of excel.

Barbara Hansen

-------------- next part --------------
An embedded message was scrubbed...
From: "Mcginnis, Barbara via Jfw" <jfw@lists.the-jdh.com>
Subject: RE: need instructions for getting started in excel
Date: Wed, 23 Sep 2015 11:56:25 -0400
Size: 6452
URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20150924/045c52bd/attachment.mht>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com