Excel is a spreadsheet program . A spreadsheet is a rectangular table, or grid, of information, according to Wikipedia. Excel has the ability to both calculate numbers and depict graphs. The programs official full name is actually Microsoft Office Excel.
Excel consists of small, rectangular boxes, called cells , organized in an orderly fashion into columns (vertically) and rows (horizontally) on a worksheet , the overall grid. Several worksheets can be contained in a single file, or a workbook .
Theres not much chance youll run out of space using this program. Each worksheet in Excel 2003 and Excel 2004 (for the Mac) contain 65,536 rows and 256 columns , with a total of 16,777,216 million cells altogether . The newer Excel 2007 exceeds even those limits, with 16,384 columns and one million rows . Tell me how many cells altogether is that?
On each worksheet, the columns are identified by letters of the alphabet , and the rows by number . These numbers and letters are called labels . Every cell on the grid can be identified this way, using a combination first of its column name and then its row name . A cell could be labeled A10 or G25, for instance. After you get to column Z, the column names start with AA, AB, etc.
Typing in Cells
If you open a worksheet and click on a cell, youll notice a thick black border around it. This border, the cell pointer , signifies the active cell , or the one you plan to work with.
You can write text in the cell, type numbers , type dates , or type formulas . You can format the cells just like you would in Microsoft Word , for instance making your entries bold , italicized, or underlined . You can change the text font type or font size , or even center your entry within the cell. You can also change both the text and cell color .
Sample Worksheet Part of an Expense Report:
Lets start with hypothetical spreadsheet calculating how much you spend on office supplies. The first step is to title your worksheet. Click in cell A1 so you can see your cell pointer. Type your title, Office Supply Expenses.
Highlight the title and make it bold, just like you would in Word. (Click on the B at the top of your screen. Its located on the Formatting toolbar in 2003 and on the Mac, and the ribbon under the Home tab in 2007.
Look for cell A1, the corner cell in the upper left. There are several ways to get to that cell. The most obvious is to click on it. But in some cases you might be creating a large spreadsheet and cant get to cell A1 easily. In that case, hold down the Ctrl key on your keyboard and hit the Home key to get to the cell.
Another way to get to cell A1 is to type A1 in the Name Box and hit Enter. The Name Box is located at the top left side of your screen, below the toolbars in 2003 and on the Mac, and below the ribbon in 2007.
You can also get to cell A1, or any cell for that matter, by using the Go To dialogue box. Get to this box by:
Hitting the F5 key on your keyboard
Holding down the Ctrl key and hitting the G key.
2003 and the Mac - Clicking on the Edit menu, and then on Go To.
2007 - Clicking on Find & Select on the right side of the Home ribbon, then click on Go To.
Put the mouse pointer around cell A1 using any method. Next, holding the mouse click down, drag across to highlight cells A1 through G1. Be sure not to highlight any other rows in the process.
There is an easy way to highlight the cells in just that row. After you click on cell A1, hold down the Shift key on your keyboard and click the Right Arrow Key. That way you can highlight one cell at a time. A group of highlighted cells is called a range.
Now click on the Merge and Center icon, a square white icon located on the formatting bar in 2003 and in the middle of the Home ribbon in 2007. On the Mac, look for an icon with a capital A on the formatting toolbar to the right of the $ icon. Whichever way you do it, Office Supply Expenses should now be centered across the page.
A little note: Whenever you highlight cells in Excel, the first cell will never look highlighted. That cell is considered the active cell. So if the first cell was white before, it will stay white even when its highlighted.
Kara Glover has been a Computer Tutor for more than seven years. She offers tutoring both remotely and in person. You can read her entire Beginning Excel article by going to her website: http://www.karathecomputertutor.com
This author of this Article has choosen to make this article available with free reprint rights. Click here to copy this article.
Oooh Kara, I wish I had this info before Monday! I could have used your crash course on Excel. It's the only program in MS Office that I do not know very well. Your example was similiar to something I was trying to figure out and I gave up (due to time constraints). I plan to do a tutorial and will go to your site and read the full article. I like your simple and easy to follow tutorial style. Thank you! Respond to this comment
» left by kara333(24) (36 days 12 hours ago.)
Hi Avis,
Thank you for your comment! I'm glad you like the style of my tutuorial. I plan on writing more. I also send out emails sometimes with computer tips, etc. If you'd like to be on it, send me an email.
Disclaimer: All information on this site is provided for informational purposes only! By no means is any
information presented herein intended to substitute for the advice provided to you by any health care or other professional
or organization.
