LESSON ONE Introduction and
Managing Files
E
Xcel’2007 is a spreadsheet program. Excel book is divided sheets; every sheet has grid of rows and columns, containing up to 1,048,576,rows and 16,384 columns, a letter is named to each column and a number is named to each row. Every intersection between a row and a column is called cell, for example, the intersection of column B and row 2 is known cell B2.
Starting Ms-Excel for Windows
Click "Start" button and choose "Programs"
Choose "Microsoft Office" and then choose Microsoft Office Excel 2007
Spreadsheet Terminology
Row : Horizontal lines of the sheet
Column : Vertical lines of the sheet
Cell : Every interjection of a row and column.
Range : More than one cell and less than sheet.
Sheet : Current sheet that you are working in.
Book : Clicking book that contains all others elements.
Parts of the Ms-Excel XP Window
Control Panel.
Title bar.
tabs
Tool bars.
Formula bar.
Name Box.
Work area.
Sheet Tabs.
Scroll bars.
Rows' Numbers.
Columns' Letters.
Creating a New Book
Click " Microsoft Office Button " menu, and choose "New" or press (Ctrl + N)
Under "Blank Workbook"
Choose "create" button.
Saving an Active Book
To save a book, must assign where you want to store the file on your computer's hard disk or in another location.
Click "Microsoft Office Button " menu and "Save" or Press (Ctrl + S) / (Shift + F12)
In the "File name" box, type the book Name and Extension.
Under "Save in" Select the location you want to save in.
Choose "Save" button or Press "Enter"
Opening an Existing Book
You can Open books that are stored on your hard disk or on network drives that you have connections to.
Click " Microsoft Office Button " menu and Choose “Open" or press (Ctrl + O) / (Ctrl + F12)
In the "Look in", select the location that contains your book.
In the "File name" text box, type the book name or select it in the books list.
Choose "Click" button or press "Enter"
Saving a Book with a Password
You can assign a protection password to prevent users from Opening your file. A password can contain any combination of letters, numbers, and symbols, and it can be up to 15 characters long.
Click " Microsoft Office Button " menu and "Save As" or Press (F12)
Click "Tools" Shortcut menu in the Save As dialog box.
Choose "General Options" command.
In the "Password to Open" box, type a password and press↵.In the "Reenter password to Open" box, type the password
Choose "Ok" button and "Save" button.
LESSON TWO Controlling the View
of Document
Setting Page Setup Margins,
Click " Layout " menu and choose "Page Setup"
Select "Margin" tab and specify your margin settings including:
Top
Bottom
Left
Right
Under "Center on page" select the following check boxes.
Horizontally.
Vertically.
Choose "Ok" button.
Paper size and Customizing Sheets
Click " Layout " menu and choose "page setup"
Select "Page" tab and specify your needs.
Under "Orientation" options, select one of the following:-
Portrait
Landscape
Under "Paper Size" list, select the predefined paper size you want.
Select "Sheet" tab, and then to show the gridlines of current page, select "Gridlines" check boxes.
Under "Page order", select one of the following options.
Down, then over.
Over, then down.
Choose "Ok" button.
Preview Document before Printing
Retrieve the document you want to preview
Click " Microsoft Office Button " menu and choose "Print Preview"
Printing the Document
Click " Microsoft Office Button " menu "Print" or (Ctrl + P) or (Ctrl + Shift + F12)
In the "Name" specify the name of the printer you want to use.
Under "Print range" select one of the following options: -
All.
Page(s) From ⬜ To ⬜
In the "Number of Copies" specify the quantity to print every page.
Choose "Ok" button.
LESSON THREE Managing Sheets
Renaming a Sheet
Select the sheet tab name you want to rename.
Click "Format" menu and choose "Sheet" and then "Rename".
Enter the name in the sheet tab, and press "Enter".
Coloring Sheet Tabs
Select the sheet tab name you want to color.
Click "Home" menu and choose "Format" then "Tab Color".
Under "Tab Color" select the color you want.
Choose "OK" button.
Inserting and Deleting a Sheet
To insert a new sheet Click “Click Right Mouse Button
and choose Insert And then” Worksheet”
To delete, select the sheet tab name you want to delete.
Click "Home menu and choose "Delete ".and then choose “Delete Sheet”
Protecting the Content of the Sheet
Select the sheet tab name you want to protect.
Click "Review" menu and choose and then "Protect Sheet".
Select "Protect Worksheet and contents of locked cells" check boxes.
In the "Password to unprotect sheet" type the protection password and choose "Ok" button or press "Enter"
In the "Reenter Password" type the password again and choose "Ok" button or press "Enter"
Adding Comments to the Cells
Comments are notes that you attach to the cells, separate from other cells contents. Comments are useful as reminders to yourself to provide feedback to other users.
Select the cell you want to comment on.
Click "Review" menu, and choose "New Comment".
In the box, type the comment text.
When you finish typing the text, click outside the comment box.
LESSON FOUR
Change the Font, Font Size, and Font Color
A font is a set of characters represented in a single typeface. Each character within a font is created by using the same basic style. . You can change the Font, Font Size, and Font Color of the data you enter into Excel.
Change the Font
Select cells B2 to E3.
Choose the Home tab.
Click the down arrow next to the Font box. A list of fonts appears. As you scroll down the list of fonts, Excel provides a preview of the font in the cell you selected.
Find and click Times New Roman in the Font box. Note: If Times New Roman is your default font, click another font. Excel
hanges the font in the selected cells.
Change the Font Size
Select cell B2.
Choose the Home tab.
Click the down arrow next to the Font Size box. A list of font sizes appears. As you scroll up or down the list of font sizes,