Microsoft Office Excel 2003

0
0
2538 days ago, 835 views
PowerPoint PPT Presentation
New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1. 2. Recognize significant segments of the Excel window. Exceed expectations is a mechanized spreadsheet, which is an essential business device that offers you some assistance with reporting and investigate data. Exceed expectations stores spreadsheets in archives called exercise manuals. Every exercise manual is comprised of individual worksheets, or sheets. Since a wide range of count

Presentation Transcript

Slide 1

Microsoft Office Excel 2003 Tutorial 1 – Using Excel To Manage Data New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 2

Identify real segments of the Excel window Excel is an electronic spreadsheet, which is a critical business device that helps you report and dissect 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 figurings can be made in the Excel spreadsheet, it is a great deal more adaptable than a paper spreadsheet. The Excel window has some fundamental segments, 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 Office Excel 2003, Second Edition-Tutorial 1

Slide 3

An example Excel worksheet New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 4

Excel worksheets and exercise manuals When you set up counts in a worksheet, if a passage is changed in a phone, the spreadsheet will consequently refresh any figured qualities that depended on that section. When you open Excel, as a matter of course 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 adaptations of Excel or to Quattro Pro, Lotus 123 configurations, dBase arranges, and even to a comma or tab-delimited content document. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 5

Identify Excel segments New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 6

Descriptions of Excel parts New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 7

Navigate inside worksheets To explore inside an exercise manual, you utilize the bolt keys, PageUp, PageDown, or the Ctrl enter in mix with the bolt keys to make bigger developments. The most direct method for route is with your mouse. Scroll bars are given and work as they do in all Windows applications. New Perspectives on Microsoft Office Excel 2003, Second Edition-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 know about Microsoft Access, you will discover the tab looking over catches for moving between worksheets to be like record perusing on an Access frame or datasheet. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 9

Navigation keystrokes New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 10

The Active Cell New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 11

Developing a Worksheet Determine the worksheet's motivation. Enter the information and equations. Test the worksheet and make any important alters/remedies. Record the worksheet and enhance appearance. Spare and print the entire worksheet. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 12

Entering Data into a Worksheet To enter information, first make the phone in which you need to enter the information dynamic by clicking it. Enter the information (content, recipes, dates, and so forth.) into the dynamic cell. Utilize the Alt+Enter key blend to enter message on different lines inside a similar cell. Utilize TAB key, bolt keys, or ENTER key to explore among the cells. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 13

Entering Data into a Worksheet New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 14

Entering Formulas An equation is a scientific expression that ascertains an esteem. In Excel, equations dependably start with an equivalent sign (=). An equation can comprise of at least one number juggling administrators. The request of priority is an arrangement of predefined guidelines that Excel takes after to compute an equation. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 15

Arithmetic Operators New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 16

Order of Precedence Rules New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 17

Resize worksheet lines and segments There are various techniques for adjusting line tallness and segment width utilizing the mouse or menus: Click the separating line on the segment or line, and drag the isolating line to change the width of the section or stature of the line Double-tap the fringe of a segment heading, and the segment will increment in width to coordinate the length of the longest passage in the segment Widths are communicated either as far as the quantity of characters or the quantity of screen pixels. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 18

Resize a section New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 19

Identify cell goes A gathering of worksheet cells is known as a phone territory, or range. Working with extents in a worksheet makes working with the information simpler. Reaches can be neighboring or nonadjacent. A nearby range is a solitary, rectangular square of cells Select an adjoining range by tapping on a cell and dragging to an inverse corner of a rectangle of cells A nonadjacent range is involved at least two neighboring extents that are not touching to each other To choose a nonadjacent range, start by choosing a contiguous range, then press and hold down the Ctrl key as you select other adjoining ranges New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 20

Select and move worksheet cells To choose an expansive zone of cells, select the primary cell in the range, press and hold the Shift key, and after that tap the last cell in the range. When you have chosen a scope of cells, you may move the cells inside the worksheet by clicking and dragging the choice from its present area to its new one. By squeezing and holding the Ctrl key as you drag, Excel will leave the first choice in its place and glue a duplicate of the choice in the new area. To move between exercise manuals, utilize the Alt key while dragging the choice. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 21

Adjacent and nonadjacent ranges New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 22

Range determination procedures New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 23

Moving chose cell runs New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 24

Insert worksheet lines and segments You can embed one or numerous extra lines or sections inside a worksheet with only a couple steps utilizing the mouse or menu choices. You can embed singular cells inside a line or segment and after that pick how to uproot the current cells. You can tap the Insert menu and afterward select line or segment, or right tap on a line or section heading or a choice of cells and afterward pick Insert from the easy route menu. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 25

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 alternate way menu. Clearing, rather than erasing, does not adjust the structure of the worksheet or move uncleared information cells. What can confound about this procedure is that you can utilize the Delete key to clear cells, however it doesn't expel them from the worksheet as you may anticipate. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 26

The Insert discourse box New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 27

Use the Undo and Redo highlights Editing is a characteristic undertaking in any record, and particularly helpful are the Undo and Redo activities. The Undo include permits you to successively go down to a specific activity, for example, an erase, a move, a section, and so forth and permits you to turn around those activities. Re-try permits you to reapply activities with extra special care that you have already fixed. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 28

Insert, move, and rename Worksheets are much similar to pages inside a book; you scrutinize through them like you flip the pages of a book. There are a few approaches to move, duplicate and work with worksheets. Right tap on the sheet tab and pick Move or Copy. Select another position in the exercise manual for the worksheet or tap the Create a duplicate checkbox and Excel will glue a duplicate of that worksheet in the exercise manual. A similar alternate route menu for the sheet tab likewise gives you the choice to embed, erase or rename a worksheet. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 29

Print an exercise manual To Print a worksheet, you can utilize: A menu The Print catch on the standard toolbar The Ctrl-P keystroke to start a printout of the worksheet Excel utilizes an indistinguishable fundamental techniques for printing from different Windows and Microsoft Office applications. New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

Slide 30

The Print exchange box New Perspectives on Microsoft Office Excel 2003, Second Edition-Tutorial 1

SPONSORS