Microsoft Exceed expectations 2002.


146 views
Uploaded on:
Category: News / Events
Description
Microsoft Exceed expectations 2002 Instructional exercise 1 – Utilizing Exceed expectations To Oversee Money related Information Recognize significant segments of the Exceed expectations window Exceed expectations is an automated spreadsheet, which is an imperative business apparatus that offers you some assistance with reporting and break down data.
Transcripts
Slide 1

Microsoft Excel 2002 Tutorial 1 – Using Excel To Manage Financial Data New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 2

Identify real segments of the Excel window Excel is an automated spreadsheet, which is an imperative business apparatus that assists you with reporting and investigate data. Exceed expectations stores spreadsheets in records called exercise manuals. Every exercise manual is comprised of individual worksheets, or sheets. Since a wide range of computations can be made in the Excel spreadsheet, it is significantly more adaptable than a paper spreadsheet. The Excel window has some essential parts, for example, an Active cell, Column headings, a Formula bar, a Name box, the mouse pointer, Row headings, Sheet tabs, a Task Pane, Tab looking over catches and Toolbars. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 3

A specimen Excel worksheet In Excel, you may transparent an exercise manual the same way you would open an archive in Word or PowerPoint. This figure demonstrates an example spending plan spreadsheet. The spreadsheet is laid out in a matrix of lines and segments. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 4

Excel worksheets and exercise manuals When you set up counts in a worksheet, if a section is changed in a phone, the spreadsheet will consequently upgrade any ascertained qualities that depended on that passage. When you open Excel, naturally it will open a clear exercise manual with three clear worksheets. When you spare an exercise manual, you have a Save As alternative that can spare the spreadsheet to prior variants of Excel or to Quattro Pro, Lotus 123 arrangements, dBase organizations, and even to a comma or tab-delimited content document. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 5

Identify Excel parts New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 6

Descriptions of Excel segments New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 7

Navigate inside of worksheets To explore inside of an exercise manual, you utilize the bolt keys, PageUp, PageDown, or the Ctrl key in mix with the bolt keys to make bigger developments. The most direct method for route is with your mouse. Parchment bars are given and function as they do in all Windows applications. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 8

Navigate between worksheets To move to different Worksheets, you can: Click their tab with the mouse Use the Ctrl key with the Page Up and Page Down keys to move successively up or down through the worksheets If you are acquainted with Microsoft Access, you will discover the tab looking over catches for moving between worksheets to be like record scanning on an Access structure or datasheet. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 9

Navigation keystrokes This figure demonstrates the keystrokes that are utilized as a part of Excel and the subsequent activity. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 10

Navigate utilizing parchment bars and parchment boxes Clicking in the parchment bar over the parchment box is the same as utilizing the Page Up key. Clicking underneath the vertical parchment bar yields the same result as the Page Down key. You can likewise snap and drag the parchment boxes to make huge, fast moves over the spreadsheet. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 11

Use tab looking over catches To search through the worksheet\'s names tabs, you might likewise utilize an arrangement of tab looking over catches, situated at the lower left parcel of the Excel window, just to one side of the first worksheet tab. Perusing through the worksheet tab names does not change the dynamic worksheet. (This tab looking over component is just dynamic when there are more worksheet tabs than are unmistakable in the Excel window.) New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 12

Identify cell runs A gathering of worksheet cells is known as a phone territory, or extent. Working with reaches in a worksheet makes working with the information less demanding. Extents can be nearby or nonadjacent. An adjoining reach is a solitary, rectangular square of cells Select a nearby range by tapping on a cell and dragging to an inverse corner of a rectangle of cells A nonadjacent extent is included two or more neighboring ranges that are not touching to one another To choose a nonadjacent extent, start by selecting a contiguous extent, then press and hold down the Ctrl key as you select other nearby ranges New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 13

Select and move worksheet cells To choose a huge region of cells, select the first cell in the reach, press and hold the Shift key, and afterward tap the last cell in the reach. When you have chosen a scope of cells, you may move the cells inside of the worksheet by clicking and dragging the determination from its present area to its new one. By squeezing and holding the Ctrl key as you drag, Excel will leave the first determination in its place and glue a choice\'s duplicate in the new area. To move between exercise manuals, utilize the Alt key while dragging the determination. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 14

Adjacent and nonadjacent reaches Working with extents is an imperative element in light of the fact that it permits you to choose gatherings of cells and control them inside of the worksheet or duplicate them to different zones, even to different applications such a Word or Outlook. Contiguous reach determination. Nonadjacent extent determination. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 15

Range choice procedures This figure depicts a few methods for selecting cell ranges. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 16

Moving chose cell reaches To move a choice of cells, select the neighboring or non-adjoining range in the first place, discharge the mouse catch, then place it close to the outskirt and drag the choice to another area, as appeared. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 17

Understand content, qualities, and equations Information went into cells is arranged as either content, qualities or recipes. A date is an uncommon sort of quality that is put away inside as a number and changed over to a date on the screen utilizing a standard tradition. Values must be numbers, however they can be arranged to show up on the screen as cash or a rate, for instance. Recipes are expressions that are utilized to figure a worth. An expression can contain one or more number juggling administrators, for example, additionally, less, separate, or duplicate When more than one math administrator is available, the estimation must take after request of-priority standards, which figure out which administrator is connected to start with, second et cetera New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 18

Editing cells and selecting so as to enter expressions You can alter a phone the cell and afterward clicking in the equation bar or by double tapping the cell to open the cell in alter mode. Phone numbers or government managed savings numbers that contain different characters (like a dash or brackets) are dealt with as content and can\'t be utilized as a part of computations. Number juggling administrators are utilized as a part of equations. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 19

Use the Undo and Redo elements Editing is a characteristic undertaking in any report, and particularly valuable are the Undo and Redo activities. The Undo highlight permits you to successively go down to a sure activity, for example, an erase, a move, a passage, and so on and permits you to turn around those activities. Re-try permits you to reapply activities slowly and carefully that you have beforehand fixed. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 20

Excel’s number juggling administrators Arithmetic operations, images and depiction of their utilization. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 21

Know the request of priority The request of priority guidelines must be considered when making expressions. The outline underneath delineates Excel’s request of priority and shows test expressions and the aftereffect of every expression. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 22

Insert worksheet lines and segments You can embed one or numerous extra lines or sections inside of a worksheet with only a couple steps utilizing the mouse or menu alternatives. You can embed individual cells inside of a line or section and after that pick how to dislodge the current cells. You can tap the Insert menu and afterward select line or segment, or right tap on a line or segment heading or a determination of cells and afterward pick Insert from the alternate way menu. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 23

Delete worksheet lines and sections To erase and clear cells, lines, or segments, you can utilize the Edit menu, or right tap on a heading or a choice of cells and pick Delete from the easy route menu. Clearing, rather than erasing, does not adjust the worksheet\'s structure or movement uncleared information cells. What can be confounding about this procedure is that you can utilize the Delete key to clear cells, yet it doesn\'t expel them from the worksheet as you may anticipate. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 24

The Insert dialog box This figure portrays the Insert dialog box, which shows up when you select a scope of cells, right tap on the determination and afterward pick Insert from the alternate way menu. Selecting one of these alternatives controls what happens to existing cells when the new line or segment is embedded. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 25

Deleting cells and scopes of cells When you decide to erase a determination, a dialog box like the Insert dialog box appears, aside from that the initial two decisions are to Shift cells left or Shift cells up. Be mindful that when you erase (uproot) cells, lines or segments, if a recipe in another cell referenced a cell that was erased, this will bring about a lapse in that equation, as delineated in the figure at right. New Perspectives on Microsoft Excel 2002 Tutorial 1

Slide 26

Resize worksheet lines and sections There ar

Recommended
View more...