MICROSOFT EXCEL MICROSOFT EXCEL Is a spreadsheet application

(MICROSOFT EXCEL)

MICROSOFT EXCEL • Is a spreadsheet application designed to take advantage of the windows graphical interface

DAY 1 - COVERAGE Introduction Screen Elements Mouse Pointers/Bar Operators Resizing Cells/Deleting Cells Basic Formula Formatting Borders

TO GET STARTED: 1. Click START button 2. Point to PROGRAMS 2 3. Click MICROSOFT EXCEL 1 3

Title Bar Menu Bar Tool Bar SCREEN ELEMENTS Name Box Active Cell Formula Bar Column Header Row Header Sheet Tab Scroll Bars

MOUSE POINTERS For clicking commands on the tool bars and menu bars For highlighting and dragging For resizing columns For resizing rows For autofill

BAR OPERATORS Addition Subtraction Multiplication Division Formula Range + * / = :

TYPES OF DATA TO BE ENTERED • CHARACTERS -plain text • NUMBERS -numeric character • FORMULA -working equations or functions starting with an equal sign.

RESIZING COLUMNS AND ROWS Use this sign to resize your rows by dragging it down. Use this sign to resize your columns by dragging it right. Note: This can only be done on rows and column headings

EDITING DATA There are 4 ways of editing data in cells Formula Bar -click the insertion point on the formula bar with the selected data. Edit the data with the cursor F 2 key -hit the F 2 key to make the cursor appear on the cell Double Click -double click to make the cursor appear in the cell. Type Over -type over the data in the cells

INSERTING ROWS, COLUMNS or WORKSHEETS • Click INSERT from the menu bar • Click ROWS (If you need rows) • Click COLUMNS (If you need columns) • Click WORKSHEET (If you need worksheet)

DELETING ROWS or COLUMNS Position your cell on the place where you want to delete • Click EDIT • Click DELETE (Choose the option you prefer then click) • Click OK

RENAMING SHEETS Choose a sheet tab you want to rename Double Click Sheet tab • Click DELETE • Type a New name

FORMULAS To start a formula, always start typing an equal sign = in the cell where you want the result to appear. Select the first operand by clicking it with the mouse pointer (in the form of a white cross) “Marching ants” will appear on the cell which the computer will consider an operand. The coordinates of a cell will also appear on the formula bar. Type the operator. Press ENTER to get the answer

FORMATTING BORDERS • Click FORMAT • Click on CELLS • Click on Border’s Tab button • Select a Border Color • Select a Style • Click on Outline • Click Inside • Click OK

DAY 2 - COVERAGE Formatting Alignment Using Paste Function/ Function Wizard (Average, Maximum, Minimum) Sorting Data

FORMATTING ALIGNMENTS • Click FORMAT • Click on CELLS • Click on Alignment’s Tab button • On Text Alignment Set center on horizontal Set center on vertical • On Text Control Check Wrap Text • Click OK

USING PASTE FUNCTION • Position your cursor where you want the result to appear. • Click on AUTOSUM SYMBOL • Select a Function Name • Highlight your cell range • Press ENTER

SORTING DATA • Position your active cell on the data table which you want to sort. • Click DATA then • Select a SORTING style • Click OK

DAY 3 - COVERAGE Creating Chart

CREATING CHART • Select data that you would like to represent in graphical form • Click INSERT • Click CHART STEP 1 OF 4 • Choose a CHART TYPE • Choose a CHART SUBTYPE • Click Next

CREATING CHART STEP 2 OF 4 • Choose a SERIES – ROWS – COLUMNS Click Next

CREATING CHART STEP 3 OF 4 • Provide a TITLE • Position your LEGEND • Add DATA LABELS Click Next

CREATING CHART STEP 4 OF 4 • Position your CHART – As Object In – As New Sheet Click FINISH