Transcription of MS-EXCEL LECTURE NOTES
1 MS-EXCEL LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI NIGERIAPage1MS-EXCELLECTURENOTESMS- excel LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI NIGERIAPage2 PREAMBLEM icrosoft excel is an electronic spreadsheet. You can use it to organize your datainto rows and columns. You can also use it to perform mathematical calculationsquickly. Thiscourseteaches Microsoft excel basicsas a prelude to the use ofStatistical Analysis System(SAS)softwarein carrying out more complex statisticalanalysis.
2 Although knowledge of how to navigate in a Windows environment ishelpful, thismanualiscreated for the computer the end of the course, participants are expected to know how touse MicrosoftExcel to: Entertext andnumbersin a spreadsheet Enter Excelformulas Formatdata Create excel functions Fillcellsautomatically Print results CreateCharts, and EnteradvancedExcelformulasAccordingly, the course isdivided into the following five (5) : Entering Text and NumbersSection2: Entering excel Formulas and Formatting DataSection3: Creating excel Functions, Filling Cells, and PrintingSection4: Creating ChartsSection5: More onEntering ExcelFormulasSection1:Entering Text and Microsoft excel WindowThisSectionwill introduce you to the excel window.
3 To begin thisSection, startMicrosoft excel 2007 as on Microsoft Start the mouse onAll on Microsoft on Microsoft excel 2007MS- excel LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI NIGERIAPage3 The Microsoft excel window appears and your screen looks similar to the one Microsoft Office ButtonIn the upper-left corner of the excel 2007 window is the Microsoft Office you click the button, a menu appears. You can use the menu to create a newfile, open an existing file, save a file,printand perform many other Quick Access ToolbarNext to the Microsoft Office button is the Quick Access toolbar.
4 The Quick Accesstoolbar gives youquickaccess to commands you frequently Title BarNext to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Exceldisplays the name of the workbook you are currently using. At the top of the Excelwindow, you should see "Book 1-Microsoft excel " or a similar RibbonIn Microsoft excel 2007, you use the Ribbon to issue commands. The Ribbon islocated near the top of the excel window, below the Quick Access LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI excel consists of worksheets.
5 Each worksheet contains columns and columns are lettered A to Z and then continuing with AA, AB, AC and so on;therows are numbered 1 to 1,048, combination of a column coordinate and a row coordinate make up a celladdress. For example, the cell located in the upper-left corner of the worksheet iscell A1, meaning column A, row 1. Cell E10 is located undercolumn E on row enter your data into the cells on the Formula BarIf the Formula bar is turned on, the cell address of the cell you are in displays in theName box which is located on the left side of the Formula bar.
6 Cell entries displayon the right side of the Formula LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI Status BarThe Status bar appears at the very bottom of the excel window and provides suchinformation as the sum, average, minimum, and maximum value of Around aWorksheetBy using the arrow keys, you can move around your worksheet. You can use thedown arrow key to move downward one cell at a time. You can use the up arrowkey to move upward one cell at a time.
7 You can use the Tab key to move across thepage to the right, one cell at a time. You can hold down the Shift key and then pressthe Tab key to move to the left, one cell at a time. You can use the right and leftarrow keys to move right or left one cell at a time. The Page Up and Page Down keysmove up anddown one page at a time. If you hold down the Ctrl key and then pressthe Home key, you move to the beginning of the 1 Movearound the Worksheetusing the Down and Up Arrow Keys, the Right and LeftArrow Keys, the Tab Key, the PageUp and Page Down Keys and the (Ctrl) Home To Cells QuicklyThe following are shortcuts for moving quickly from one cell in a worksheet to a cellin a different part of the 2Go F5.
8 The Go To dialog LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI the Reference Enter. excel moves to cell to--Ctrl+ down the Ctrl key while you press "g" (Ctrl+g). The Go To dialog the Reference Enter. excel moves to cell To--TheName BoxYou can also use the Name box to go to a specific cell. Just type the cell you want togo to in the Name box and then press the Name Enter. excel moves to cell CellsIf you wish to perform afunction on a group of cells, you must first select those cellsby highlighting them.
9 The exercises that follow teach you how to LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI 3 Select Cells F8To select cells A1 to E7 to cell the F8 key. This anchors the that "Extend Selection" appears on the Status bar in the lower-leftcorner of the window. You are in the Extend in cell E7. excel highlights cells A1 to Esc and click anywhere on the worksheet to clear the Method: Select Cells by to cell the left mouse holding down the left mouse button, use the mouse to move from cellA1 to the left mouse down the Ctrl keyuntil step the mouse, placethe cursor in cell the left mouse holding down the left mouse button, move to cell F10.
10 Release the leftmouse the Ctrl key. Cells A1 to C5 and cells D7 to F10 are Esc and click anywhere on the worksheet to remove the DataIn this section, you will learn how to enter data into your worksheet. First, place thecursor in the cell in which you want to start entering data. Type some data, andthen press Enter. If you need to delete, press the Backspace key to delete onecharacter at a LECTURE NOTES FOROWERRI CBT HI-TECH, OWERRI 4 Enter the cursor in cell Jordan.
