excel intermediate tutorial pdf

Excel analyzes the two cells, sees the incremental pattern, and re-creates it in subsequent cells. Absolute referencing is discussed in the next section. Excel keeps a list of all the labels that you enter on a worksheet by column. 0000005954 00000 n For example, to determine the sum of a series of numbers in cells A1 through H1, you can enter the function =SUM(A1:H1). You learn more about functions in Formulas that you create typically include cell addresses that reference cells on which you want to perform a calculation. The cells are highlighted on the worksheet (see Techniques that you can use to quickly select a row, a column, an entire worksheet, or several ranges are shown in Click the row heading number at the left edge of the worksheet. Now you can set the formatting that will be applied to cells that meet your condition. Excel functions can do all kinds of calculations for all kinds of purposes, including financial and statistical calculations. This is particularly useful for large worksheets that span several pages; then you don't have to keep looking back to the first page of the printout to determine what the column headings are. Align Left                         Places data at left edge of cell                               Align Right                       Places data at right edge of cell                               Center                            Centers data in cell                               Merge and Center             Centers data in selected cell range Excel also enables you to indent your text within a cell. The numbers down the side of the worksheet, which identify the rows in the worksheet. Type the text or value that you want to find into the 4.

Click the When you have finished working with Excel, you need to exit the application. To see a preview of the workbook before you open it, click the When you have finished with a particular workbook and want to continue working in Excel, you can easily close the current workbook. Click you have finished working with the Find and Replace dialog boxclick If you don't need to replace an entry but would like to find it in the worksheet, you can use the Find feature. As you make your selections, keep in mind that if you plan to print your worksheet with a black-and-white printer, the colors you select might not provide enough contrast on the printout to provide any differentiation between ranges of cells. If the area you select is too large to fit on one page, no problem; Excel breaks it into multiple pages. Excel provides a way for you to select labels and titles that are located on the top edge and left side of a large worksheet and to print them on every page of the printout. Then open the Another way to enter labels or values onto a sheet is to use the Fill feature. 6. To format cells using the Font tab of the Format Cells dialog box, follow these steps: 1. The default Scientific format has two decimal places.

Use this format to display the number of digits you want on each side of the slash and the fraction type (such as halves, quarters, eighths, and so on). Some functions can include more than one set of cell addresses, which are separated by commas (such as A1,B1,H1). Click in the cell where you want to enter the value. %PDF-1.4 %���� Type the text. Select the first cell in the area where you would like to place the copy. Excel provides a large number of functions listed by category. For example, suppose you have a worksheet tracking sales in Europe and you are entering country names, such as Germany, Italy, and so on, multiple times into a particular column in the worksheet. From the Functions list, select the function you want to insert. Even though you won't see this number (Excel displays your entry as a normal date), the number is used whenever you use this date in a calculation. Starting Excel. Click You can delete multiple sheets if you want. To move around the worksheet with your keyboard, use the key combinations listed in You can also quickly go to a specific cell address in a worksheet using the Go To feature. The Office Clipboard is viewed in the Clipboard task pane.

You can correct the range by typing a new range or by clicking the 5. A great way to change multiple occurrences of a label or value is using Excel's Replace feature; you can locate data in the worksheet and replace it with new data. Simply click the You can also have Excel zoom in on a particular portion of a worksheet. Excel data basically comes in two varieties: labels and values.

Select the cell or cells and click the If you would like to access a greater number of font format options for a cell or range of cells, you can use the Font tab of the Format Cells dialog box. Type the formula or function (begin the formula or function with the equal sign). There will definitely be occasions when you need to edit information in a cell.