Microsoft Excel Lectures PDF

Mini Toolbar and Shortcut Menu Excel 2019 utilizes Mini Toolbar and Shortcut Menus for quick access to common commands for a selected object. These come in handy when you are in a tab that does not contain the command you need. Using the Mini Toolbar and Shortcut Menus allow you to quickly get to a...

Mini Toolbar and Shortcut Menu Excel 2019 utilizes Mini Toolbar and Shortcut Menus for quick access to common commands for a selected object. These come in handy when you are in a tab that does not contain the command you need. Using the Mini Toolbar and Shortcut Menus allow you to quickly get to a command without having to change tabs Using a Mini Toolbar and Shortcut Menu  In the worksheet, select a cell or range of cells.  Right click the mouse button.  A Mini Toolbar with a Shortcut Menu will be displayed. Select an option as desired. 1  Mouse Pointer Styles The Excel mouse pointer takes on many different appearances as you move around the spreadsheet. The following table summarizes the most common mouse pointer appearances: P0INTER EXAMPLE DESCRIPTION The white plus sign will select a single cell to enter data, retype data or delete text from the selected cell. This pointer is also useful for selecting a range of cells. The white arrow will drag the contents of the selected cell to a new location (drag and drop) The black plus sign activates the fill handle of the selected cell and will fill the adjoining cells with some type of series, depending on the type of data (e.g., a formula or date) is in the beginning cell. Spreadsheet Navigation Method Description mouse pointer Use the mouse pointer to select a cell arrow keys Use the left , right →, up , and down  arrows to move accordingly among cells. Enter Press the Enter key to move down one cell at a time. Tab Press the Tab key to move one cell to the right. End + arrow key Moves the cursor to the next or last cell in the current column or row which contains information. Ctrl+Home Moves the cursor to cell A1 Ctrl+End Moves the cursor to the last cell of used space on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner) 2  Basic Steps for Creating a Spreadsheet When creating a spreadsheet, it is recommended to do the following steps:  Made a draft of your spreadsheet idea on paper.  Enter the data from your draft onto the actual spreadsheet.  Format your data after entering onto the spreadsheet.  Calculate data by using mathematical formulas.  Save the document.  Preview and print the spreadsheet. Enter and Format Data Create Spreadsheet  Select cell A1, and then type Budget for Guest Speakers.  Select cell A3, type Item, and then press the Tab key.  Select cell B3, type Fall, and then press the Tab key.  Select cell C3, type Spring, and then press the Tab key.  Select cell D3, type Summer, and then press the Tab key.  Select cell E3, type Annual, and then press the Tab key. budget for guest FALL SPRING SUMMER ANNUAL Lodging $50.00 $40.00 $5.00 $95.00 ITEM $50.00 $50.00 $15.00 $115.00 RESERSH $50.00 $60.00 $25.00 $135.00 communication $50.00 $70.00 $35.00 $155.00 publicity $50.00 $80.00 $45.00 $175.00 Travel $50.00 $90.00 $55.00 $195.00 Total $300.00 $390.00 $180.00 $870.00 3  Adjust Column Width Initially all columns have the same width in a spreadsheet. Often you will need to make columns wider or narrower. For example, a long text entry in one cell will be cut off/truncated when the cell to its right contains any information. Likewise, numbers will appear as pound symbols ### when larger than cell width. There are several ways to modify column width. method Description dragging method Move the cursor up to the column heading area and point to the vertical line to the right of the column that you want to change. When the cursor becomes a "plus sign" with horizontal arrows, press the mouse button and drag in either direction to resize the column. Release the mouse button to accept the new size. double click to auto fit Move the cursor up to the column heading area and point to the vertical line to the right of the column that you want to change. When the cursor becomes a "plus sign" with horizontal arrows, double click to AutoFit this one column. AutoFit a range Use the mouse to select the range of cells that needs to be adjusted and on the home ribbon in the Cells group, choose Format, and the select the AutoFit Column Width option.  Increase the width of column A via the dragging method so that all text entries are visible.  Decrease the width of column C via the dragging method until pound symbols ### appear.  Increase the width of column C to return to its original size 4  Type Text and Numbers Use the plus sign mouse pointer to select a cell then begin typing in that cell to enter data. If there is existing text/data in a cell, the new text will replace the existing text. Press the Enter or Tab key after typing text in a cell. Insert and Delete Rows and Columns Insert rows and columns to add information between existing rows or columns of information Procedure Description Add Row Select any cell of the row where you desire to add a new row above. On the Home ribbon in the Cell group, click on the Insert button, and then select Insert Sheet Rows. A new roll will appear above your selected cell row. Add Column Select any cell of the column letter where you desire to add a new column to the left. On the Home ribbon in the Cell group, click on the Insert button, and then select Insert Sheet Columns. A new column will appear to the left of your selected column. Delete Row or Select any cell where you desire to delete a row or column. On the Home ribbon in the Column Cell group, click on the Delete button, and then selected Delete Sheet Rows or Delete Sheet Columns. The row or column where the cell was selected will be deleted. 1) Select any cell in column C. 2) On the Home ribbon in the Cell group, click on the Insert drop-down arrow, and then select Insert Sheet Columns. A new column will appear to the left of your selected column. 3) Click the Undo button. 4) Select any cell in row 6. 5) On the Home ribbon in the Cell group, click on the Insert drop-down arrow, and then select Insert Sheet Rows. A new roll will appear above your selected cell row. 6) Select cell A6, and then type Photocopy Services 7) Press Tab and complete the additional columns as follows 5 Text and Number Alignment Microsoft Excel aligns data in a cell in three ways; left, center, and right. Also, a range of cells can be merged into one cell; this is good for text titles. The default text alignment is left, and the default number alignment is right. Alignment can be changed by using the alignment icons located on the home ribbon in the Paragraph group. Select a range before changing alignment to more than one cell at a time. Basic Formulas Microsoft Excel is an electronic spreadsheet that automates manual calculations involved in accounting and bookkeeping. After you have typed the basic text and number entries in a spreadsheet cell, Excel can perform the math calculations for you. You will learn how to create formulas and functions to perform calculations in a spreadsheet. Create Formula You can create any type of math calculation on your own using the following mathematical operators: Symbol Meaning = equals - used to begin a calculation + addition - subtraction * multiplication / division * exponentiation ) open parenthesis - used to begin a grouping close parenthesis - used to close a grouping ( 6  Basic steps for creating a formula: 1) Click in the empty cell which will contain the formula. 2) Type an equal sign (=). 3) Type the cell address or click the cell that contains the first number. 4) Type the math operator (+ - / * ^). 5) Type the cell address or click the cell that contains the second number. 6) Continue in this manner until the formula is complete. 7) Use parenthesis for clarification. 8) Press the Enter key ‫إعداد‬ ‫ب حيدر نزار الياسين‬.‫م‬ 7