Microsoft Excel Guide PDF

Microsoft is a multinational computer technology corporation. Microsoft was founded on April 4, 1975, by Bill Gates and Paul Allen in Albuquerque, New Mexico.  Microsoft Early Microsoft employee Excel Charles Simonyi is the man behind some of the company's most successful software, inclu...

Microsoft is a multinational computer technology corporation. Microsoft was founded on April 4, 1975, by Bill Gates and Paul Allen in Albuquerque, New Mexico.  Microsoft Early Microsoft employee Excel Charles Simonyi is the man behind some of the company's most successful software, including Word and Excel. Evolution of the Microsoft Excel Workbook – is what an excel file is called. Workbook – is composed of worksheets. Book1 – is the default file name/temporary name. Worksheet – is represented by grid, much like a graphing paper. Column headings – the horizontal bars on top of the worksheet. They are labeled with letters from A to XFD. Column – vertical division – labeled with letters  Row – horizontal division – labeled with numbers Row headings – vertical bars at the left side of the worksheet. They are labeled with numbers from 1 to 1,048,576. Cells – are identified by their cell address in the name box. Example: A1 (Column A and Row 1) Cell – the small blocks on the grid Active cell – the cell that is currently selected. Name box – contains the name address of the active cell. Formula bar – shows the contents of the active cell and can be used to Select all buttonedit it. for selecting the entire – used worksheet. Sheet tabs – contain the names of the available worksheet in the current Tab Split Box– you Tab Scrolling buttons– used workbook. These tabs enable can drag this to the left to scroll through the sheet you to switch to a specific or right to adjust the tabs in your workbook, sheet in the workbook. Right area allocated for allowing you to view other click any sheet tab to show a displaying the sheet worksheets in the workbook. shortcut menu to insert, tabs. delete, rename, move or copy worksheets. Working with a Workshee t To begin creating your workbook, 1. Open MS Excel app 2. Make a new workbook Click the File tab then click New. By default, Blank Workbook is selected. Once you have opened a new workbook you are ready to input data on the cells. You can enter any sort of data, such as numbers, letters, and formulas to any active cell. Entering Data 1. Click a cell and type the desired data. 2. If you had typed the correct data, press Enter. 3. To cancel the data you just entered, press Esc. Editing Data Editing Data Editing Data  Using the Typeover  Using F2 (Edit key)  Using Double-click 1. Select the cell 1. Go to the cell you 1. Double-click the you wish to edit. wish to edit. cell you want to 2. Type the new 2. Press F2. edit. data. 3. Edit the cell as 2. Edit the cell as 3. Press Enter. desired. desired. 4. Press Enter. 3. Press Enter. Selecting Cells Using the Mouse  To select a cell – click the cell  To select adjacent cells – click and drag over the cells to highlight your selection  To select non-adjacent cells: 1. Click and drag over the first range of cells. 2. Hold down the Ctrl key. 3. Select the succeeding ranges of cells. Navigating Through the Worksheet Using the Keyboard  One cell up One cell to the left One cell down One cell to the To the beginning of the row One screen up One screen down To the top edge of the current data region To the bottom edge of the current data region To the left edge of the current data region To the right edge of the current data region To the last cell used in the worksheet To the beginning of the worksheet One screen to the left One screen to the right Deleting Data in Cells: 1. Select the cells/s whose data you want to delete. 2. Press DELETE. To select several cells using the keyboard, use Shift together with the keys specified previously. Copying Cells 1. Select the cells to be copied. 2. Under the Home tab, you can click in the Clipboard group, or right-click and choose Copy. 3. Move the cell pointer to the first cell of the desired destination. 4. Under the Home tab, you can click in the Clipboard group, or right-click and choose Paste. Moving Cells 1. Select the cells to be moved. 2. Under the Home tab, you can click in the Clipboard group, or right-click and choose Cut. 3. Move the cell pointer to the first cell of the desired destination. 4. Under the Home tab, you can click in the Clipboard group, or right-click and choose Paste. Creating a series Creating a Number Series 1. Type the first two consecutive numbers of your series in consecutive cells. 2. Select these two cells. 3. Position the mouse pointer over the fill handle till the mouse pointer becomes a cross-hair. 4. Click and drag to fill the succeeding cells with the desired series. Creating a Date and Time Series 1. Type the desired date or time in the first cell. 2. Position the mouse pointer over the fill handle till the mouse pointer becomes a cross-hair. 3. Click and drag to fill the succeeding cells with the desired series. Note that the days increase when you enter a date and the hours increase when you input time. Note: Press Ctrl + ; to show the current date. Press Ctrl + : to show the current time. Formatting Cells See the image above? This was done by typing “Input Data Sheet for E-Class Record” in A1, selecting A1:AJ1 and then clicking. You will find many available commands in the Home tab gallery. However, many prefer to access the Format Cells dialog box for more choices. You can click any of the Font, Alignment, or Number group dialog box launchers, or you can select the cells you want to format, right-click and then choose Format Cells. You will then see a new window like the one below. This dialog box has several tabs. Just click the tabs to access their options. Select the desired category and format code. In our worksheet, the dates were formatted using this: These cells were formatted by If the text you have entered is changing the Orientation to 90 too long to fit inside the cell, Degrees and the Color to Red. click the Shrink to fit checkbox. Changing the Column Width and Row Height Positioning your mouse between any two row or column headings will change the mouse pointer into a cross bar. Drag the mouse to change the width or height of the cells. You can also go to the Cells group under the Home tab, and then click Format. Note: If you find it difficult to estimate the height or width, just select AutoFit. There are the Changing twoColumn kinds ofWidth dataand that Row youHeight can enter into the cells: labels and values. Positioning your mouse between any two row or column headings will Labels change the mouse – are alphanumeric pointer into a characters cross bar. Drag that you the mouse do not to perform change the widthmathematical or height of the calculations cells. You can with.also go to the Cells group under the Home tab, and Values then – are click Format. numbers that you use for computation. To classify a number as a label and not a value, type an apostrophe (‘) first before the number. A small green triangle will appear on the upper left side of the cell that will denote that the number is indeed a label.