Exceed expectations Instructional exercise 1 Beginning with Exceed expectations.


100 views
Uploaded on:
Category: Sales / Marketing
Description
Exceed expectations Instructional exercise 1 Beginning with Exceed expectations. Targets. Comprehend the utilization of spreadsheets and Exceed expectations Take in the parts of the Exceed expectations window Look through a worksheet and explore between worksheets Make and spare an exercise manual record Enter content, numbers, and dates into a worksheet
Transcripts
Slide 1

Exceed expectations Tutorial 1 Getting Started with Excel

Slide 2

Objectives Understand the utilization of spreadsheets and Excel Learn the parts of the Excel window Scroll through a worksheet and explore between worksheets Create and spare an exercise manual document Enter content, numbers, and dates into a worksheet Resize, embed, and uproot segments and lines New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 3

Objectives Select and move cell extents Insert equations and capacities Insert, erase, move, and rename worksheets Work with altering devices Preview and print an exercise manual New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 4

Introducing Excel Microsoft Office Excel 2007 (or Excel ) is a PC project used to enter, investigate, and present quantitative information A spreadsheet is a gathering of content and numbers laid out in a rectangular lattice. Regularly utilized as a part of business for planning, stock administration, and choice making What-if examination gives you a chance to change one or more values in a spreadsheet and afterward evaluate the impact those progressions have on the figured values New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 5

Introducing Excel New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 6

Exploring Excel New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 7

Exploring Excel New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 8

Navigating a Worksheet Excel gives a few approaches to explore a worksheet New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 9

Planning a Workbook Before you start to enter information into an exercise manual, you ought to build up an arrangement Planning investigation sheet New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 10

Entering Text, Numbers, and Dates in Cells The equation bar shows the dynamic\'s substance cell Text information is a blend of letters, numbers, and a few images Number information is any numerical quality that can be utilized as a part of a scientific computation Date and time information are generally perceived configurations for date and time values New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 11

Entering Multiple Lines of Text Within a Cell Click the phone in which you need to enter the content Type the first line of content For each extra line of content, press the Alt+Enter keys (that is, hold down the Alt key as you press the Enter key), and afterward sort the content New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 12

Changing Column Width and Row Height A pixel is a solitary point on a PC screen or printout The default section width is 8.38 standard-sized characters Row statures are communicated in focuses or pixels, where a point is 1⁄72 of an inch Matching so as to autofitt takes out any vacant space the segment to the width of its longest cell passage or the line to the tallness of its tallest cell passage New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 13

Changing the Column Width and Row Height Drag the right outskirt of the segment making a beeline for lessening the segment width or right to expand the segment width Drag the base fringe of the line going to diminish the line tallness or down to build the line stature or Double-tap the right fringe of a segment heading or the base fringe of a line going to AutoFit the segment or line to the phone substance (or select one or more segment or lines, tap the Home tab on the Ribbon, tap the Format catch in the Cells gathering, and afterward click AutoFit Column Width or AutoFit Row Height) or Select one or more segments or lines Click the Home tab on the Ribbon, tap the Format catch in the Cells gathering, and after that snap Column Width or Row Height Enter the segment width or line stature you need, and after that tap the OK catch New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 14

Inserting a Column or Row Select the column(s) or row(s) where you need to embed the new column(s) or row(s); Excel will embed the same number of segments or lines as you select In the Cells bunch on the Home tab, tap the Insert catch (or right-click a segment or line heading or chose segment and line headings, and afterward snap Insert on the easy route menu) New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 15

Inserting a Column or Row New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 16

Deleting and Clearing a Row or Column Clearing information from a worksheet uproots the information yet leaves the clear cells Deleting information from the worksheet evacuates both the information and the phones New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 17

Working with Cells and Cell Ranges A gathering of cells is known as a phone territory or extent A contiguous reach is a solitary rectangular piece of cells A nonadjacent extent comprises of two or more particular neighboring ranges An extent reference demonstrates the area and size of a phone territory New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 18

Selecting Cell Ranges To choose an adjoining extent: Click the phone in the upper-left corner of the nearby range, drag the pointer to the phone in the lower-right corner of the neighboring reach, and afterward discharge the mouse catch or Click the phone in the upper-left corner of the nearby range, press the Shift key as you tap the phone in the lower-right corner of the adjoining reach, and after that discharge the Shift key To choose a nonadjacent scope of cells: Select a phone or a nearby range, press the Ctrl key as you select each extra cell or neighboring extent, and afterward discharge the Ctrl key To choose every one of the phones in a worksheet: Click the Select All catch situated at the crossing point of the line and segment headings (or press the Ctrl+A keys) New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 19

Selecting Cell Ranges New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 20

Moving or Copying a Cell or Range Select the phone or extent you need to move or duplicate Move the mouse pointer over the determination\'s fringe until the pointer changes shape To move the extent, tap the fringe and drag the choice to another area (or, to duplicate the reach, hold down the Ctrl key and drag the choice to another area) or Select the phone or extent you need to move or duplicate In the Clipboard bunch on the Home tab, tap the Cut catch or the Copy catch (or right-tap the choice, and afterward snap Cut or Copy on the alternate way menu) Select the phone or upper-left cell of the reach where you need to move or duplicate the substance In the Clipboard gathering, tap the Paste catch (or right-tap the choice, and after that snap Paste on the alternate way menu) New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 21

Moving or Copying a Cell or Range New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 22

Inserting and Deleting a Cell Range New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 23

Inserting or Deleting a Cell Range Select a range that matches the reach you need to embed or erase In the Cells bunch on the Home tab, tap the Insert catch or the Delete catch or Select the reach that matches the extent you need to embed or erase In the Cells gathering, tap the Insert catch bolt and after that tap the Insert Cells catch or snap the Delete catch bolt and after that tap the Delete Cells charge (or right-tap the chose reach, and after that snap Insert or Delete on the alternate route menu) Click the choice catch for the course in which you need to move the phones, segments, or lines Click the OK catch New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 24

Entering a Formula A recipe is an expression that profits an esteem An equation is composed utilizing administrators that join diverse qualities, giving back a solitary esteem that is then shown in the phone The most usually utilized administrators are math administrators The request of priority is an arrangement of predefined principles used to focus the succession in which administrators are connected in an estimation New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 25

Entering a Formula New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 26

Entering a Formula New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 27

Entering a Formula Click the phone in which you need the equation results to show up Type = and an expression that ascertains a worth utilizing cell references and number-crunching administrators Press the Enter key or press the Tab key to finish the recipe New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 28

Entering a Formula New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 29

Copying and Pasting Formulas With equations, nonetheless, Excel alters the formula’s cell references to mirror the new area of the recipe in the worksheet New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 30

Introducing Functions A capacity is a named operation that profits a quality For instance, to include the qualities in the reach A1:A10, you could enter the accompanying long recipe: =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10 Or, you could utilize the SUM capacity to fulfill the same thing: =SUM(A1:A10) New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 31

Entering a Function New Perspectives on Microsoft Office 2007: Windows XP Edition

Slide 32

Entering Functions with AutoSum The AutoSum catch rapidly embeds Excel capacities that compress every one of the qualities in a segment or line utilizing a solitary measurement Sum of the qualities in the segment or line Average worth in the segment or line Total include of numeric qualities the segment or line Minimum worth in the segment or line Maximum quality in the segment or line New Perspectives on Microsoft Office 2007: Windows XP Edition

Recommended
View more...