Microsoft Excel Computer Class Notes: Lesson 3
For Louise's Model of Monthly Bills: Email me at susanmwest@createfaith.org and I will send you a copy.
Microsoft Excel Computer Class Notes: Lesson 2
To get familiar with the features and functions of Excel, hover your mouse over the icons on the tool bar. Click any feature to get a menu of functions. It’s a good idea to practice and try each function, so that you remember what it does.
To cut and paste, or copy and paste: move and click/hold your mouse over the section you wish to move to highlight that section. Then, go to Edit on the toolbar, then cut or copy. Move your mouse to the place you want to insert the section, go back to Edit and click paste.
To insert a column or row: Click Insert on the toolbar, then column or row.
To align the content within a cell: Go to the Alignment feature and click right, left, or center alignment. (The icons look like lines on a page.)
To add grids for printing: Click Borders. Then choose how you want the lines to appear on the printed page. Depending on what you choose, select the borders you desire. You may wish to select All, outside borders only, or others depending on your spreadsheet.
To bold text or content: Highlight content and click B on the toolbar. You can also underline by clicking U, or italicize by clicking I.
To merge cells, click Format, and then merge cells.
This link may be useful for beginners: http://spreadsheets.about.com/od/excel101/a/Excel_beg_guide.htm
Microsoft Excel Computer Class Notes: Lesson I
General: It is a good idea to bring a jumpdrive to save your work. One can be purchased at Walmart or similar store and cost around $10. Any amount of megabytes or gigabytes will do.
To start Excel-Click START, then ALL PROGRAMS, MICROSOFT OFFICE, EXCEL
To save-Click SAVE AS, select location in dropdown box (if you are saving on a jumpdrive, be sure it is plugged in and you can find it in the dropdown box), then rename your file (something that makes sense- ex. 2009 Budget)*, click SAVE.
*Note about saving: you can only use numbers, letters, periods (.), and underscore marks (_) in filenames.
Be familiar with the toolbar, the icons, and their functions. Hovering your mouse over them will show you what they do.
Functions and tips:
- The “boxes” are called “cells”. Each page is called a “spreadsheet” and each set of spreadsheets is called a “workbook”.
- Each cell in the spreadsheet has a “name”. Ex. A1, B3, C8. There are literally thousands of cells available. If you look at the bottom of the sheet, you will see “sheet 1”, “sheet 2”, and “sheet 3”. You can add sheets to the workbook. The availability of space is virtually endless.
- The name box shows what cell the cursor is in. You can type in the line next to the name box and it will show in that cell on your spreadsheet.
- You can change the font, color, size, and location inside the cell by using the tools in the toolbar.
- PAGE BREAK REVIEW will show how many pages you have.
- PRINT PREVIEW will show how your pages will print. The extra boxes will not print.
- To rotate text, click FORMAT CELL. You have options to rotate the text inside the cell.
If you need typing practice, this site may help:
http://www.davis.k12.ut.us/cjh/appliedtech/Business/Keyboarding/
This is a good site for Excel 2003/2004 version help:
http://www.baycongroup.com/excel.htm Excel is a registered trademark of the Microsoft® Corporation