MS Excel - PowerPoint

Document Sample
MS Excel - PowerPoint Powered By Docstoc
					Microsoft Office 2007- Illustrated Introductory,
           Premium Video Edition

        Getting Started with Excel 2007
       Understanding Spreadsheet
               Software
              Sample worksheet with chart




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Touring the Excel 2007
  Window
    • The Name box displays the active
      cell address
    • The formula bar allows you to enter
      or edit data in the worksheet
    • The intersection of a row and a
      column is called a cell



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Touring the Excel 2007
  Window
    • Each cell has its own unique location
      called a cell address
            • A cell address is identified by its
              coordinates (A1)
    • The cell in which you are working is
      called the active cell
    • Sheet tabs let you switch from sheet
      to sheet in a workbook

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Touring the Excel 2007
  Window
    • The status bar provides a brief
      description of the active command or
      task in progress
    • The mode indicator provides
      additional information about certain
      tasks
    • A selection of two or more cells such
      as B5:B14 is called a range

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Touring the Excel 2007
  Window
                                                   Open workbook
Name box and
 current cell
  address


      Cell
   pointer

  Formula
     bar




     Sheet tabs                                                         Status bar
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Understanding Formulas
    • Formulas are equations in a
      worksheet
    • Excel formulas allow users at every
      level of mathematical expertise to
      make calculations with accuracy




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Understanding Formulas
    • When creating calculations in Excel,
      it is important to:
            • Know where the formulas should be
            • Know exactly what cells and arithmetic
              operations are needed
            • Create formulas with care
            • Use cell references rather than values
            • Determine what calculations will be
              needed
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Understanding Formulas
                              Viewing a Formula

       Formula
      appears in
     formula bar




      Result of
      formula




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Understanding Formulas

        Excel arithmetic operators




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Entering Labels and Values
  and Using AutoSum
    • Labels contain text and numerical
      information not used in calculations
            • Labels help you identify data in
              worksheet rows and columns
            • You should enter all the labels first
              before entering other content
    • Values are numbers, formulas, and
      functions that can be used in
      calculations
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
        Entering Labels and Values
           and Using AutoSum
    • A function is a built-in formula
            • A function includes arguments, the
              information necessary for the
              calculation
    • Clicking the AutoSum button sums
      the adjacent range above or to the
      left, though you can adjust the range
    • The Fill button fills cells based on the
      first number sequence in the range
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
             Entering Labels and Values
                and Using AutoSum
          Creating a formula using the AutoSum button
                                                                               AutoSum
                                                                                button

Formula
                                                                               Fill button




                                                                    Cells
                                                                 included in
                                                                   formula



     Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Editing Cell Entries
    • You can change, or edit, the contents
      of an active cell at any time
    • To edit the contents of the active cell:
            • Double-click the cell, or
            • Click in the formula bar, or
            • Just start typing
    • Excel switches to Edit mode when
      you are making cell entries
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Editing Cell Entries
                     Worksheet in Edit mode


    Active
      cell



Insertion
   point




  Mode
indicator
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Editing Cell Entries

        Common pointers in Excel




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Entering and Editing a Simple
  Formula
    • Formulas start with the equal sign
      (=), also called the formula prefix
    • Calculation operators in formulas
      indicate what type of calculation you
      want to perform
    • Arithmetic operators perform
      mathematical calculations such as
      adding and subtracting

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Switching Worksheet Views
    • You can change your view of the
      worksheet window by using either:
            • View tab on the Ribbon
            • View buttons on the status bar
    • Normal view shows the worksheet
      without including headers and footers
      or tools like rulers and a page
      number indicator

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Switching Worksheet Views
    • Page Layout View provides a more
      accurate view of how a worksheet
      will look when printed
            • It shows page margins, headers and
              footers, rulers, etc.
    • Page Break Preview displays a
      reduced view of each page of the
      worksheet, along with page break
      indicators
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
    Switching Worksheet Views
                                                                          Horizontal
                   Page Layout View                                         ruler


 Workbook
Views group


Header text
   box


  Vertical
   ruler




  Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Switching Worksheet Views
                          Page Break Preview




                                                                        Bottom page
                                                                           break
                                                                         indicator
 Blue outline
  indicates
  print area




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Choosing Print Options
    • You can see how a worksheet would
      look when printed using:
            • Page Layout tab
                   • The dotted line indicates the print area, the
                     area to be printed
            • Print Preview
                   • You can print from this view by clicking the
                     Print button on the Ribbon



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Choosing Print Options
    • Page Layout tab
            • Page Setup group
                   • Print orientation: landscape or portrait
            • Scale to Fit group
            • Sheet Options group
    • Print dialog box lets you choose the
      number of copies, the printer, etc.


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Choosing Print Options
                  Worksheet with Portrait orientation


  Page
Layout tab




Dotted line
surrounds
print area




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Choosing Print Options
                       Worksheet in Print Preview


                                                                        Close Print
    Print                                                                Preview
   button                                                                 button


  Zoom
  button




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Creating a Complex Formula
    • A complex formula is an equation
      that uses more than one type of
      arithmetic operator
            • Example: formula that uses both
              addition and multiplication
            • Arithmetic operations are performed
              according to the order of precedence



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Creating a Complex Formula
               Formula containing multiple arithmetic operators




Complex
formula




 Mode
indicator



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Creating a Complex Formula
    • Order of precedence in Excel
      formulas
            • Operations inside parentheses are
              calculated first
            • Exponents are calculated next
            • Multiplication and division are
              calculated next (from left to right)
            • Addition and subtraction are calculated
              next (from left to right)

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Inserting a Function
    • A function is a predefined worksheet
      formula that makes it easy to perform
      a complex calculation
            • Can be used by itself or within a
              formula
            • If used alone, begins with the formula
              prefix (=)



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
      Inserting a Function
             Function Arguments dialog box

Function




 Insert
Function                                                                    Description
 button                                                                         and
                                                                             argument
                                                                              format
Argument




    Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Typing a Function
    • A function can be typed manually into
      a cell
            • You must know the name and initial
              characters of the function
            • Can be faster than using the Insert
              Function dialog box
            • Experienced Excel users often prefer
              this method


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Typing a Function
    • While manually typing a function, it is
      necessary to begin with the equal
      sign (=)
    • Once you type an equal sign, each
      letter you type activates the
      AutoComplete feature



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Typing a Function

        MAX function in progress




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Copying and Moving Cell
  Entries
    • You can copy or move data within a
      worksheet or between worksheets
      using:
            • Cut, Copy, and Paste buttons
            • Fill handle in the lower-right corner of
              the active cell
            • Drag-and-drop feature
    • Office Clipboard temporarily stores
      information that you copy or cut
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Copying and Moving Cell
  Entries
    • Pasting an item from the Clipboard
            • Only need to specify the upper-left cell
              of the range where you want to paste
              the selection




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Copying and Moving Cell
  Entries
                              Copied data in Clipboard
   Paste
   button

    Copy
   button

 Clipboard
  launcher


    Item in
  Clipboard



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Formatting Values
    • The format of a cell determines how
      the labels and values look
            • Bold, italic, dollar signs, commas, etc.
    • Formatting does not change the data
      only its appearance
    • Select a cell or a range, then apply
      formatting


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Formatting Values
                        Format Cells dialog box




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing Font and Font Sizes
   • A font is the name for a collection of
     characters with a similar, specific
     design
   • Font size is the physical size of text
           • Measured in points
                  • 1 point = 1/72 of an inch
   • The default font in Excel is 11-point
     Calibri

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing Font and Font Sizes
               Font tab in the Format Cells dialog box
                                                                        Type a custom
 Currently                                                               font size or
 selected                                                                select from
   font                                                                    the list



                                                                        Font style
                                                                          options


                                                                         Preview
                                                                          area



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing Font and Font Sizes
          Worksheet with formatted title and labels

                                    Font and size of active cell or range




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing Attributes and
  Alignment
   • Alignment determines the position of
     data in a cell
            • Left, right, or center
   • Apply attributes and alignment
     options using:
            • Home tab, or
            • Format Cells dialog box, or
            • Mini toolbar
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
      Changing Attributes and
      Alignment
              Worksheet with formatting attributes applied
Formatting                                      Center button                 Merge &
 buttons
                                                                            Center button
 selected




     Title centered
         across                                                Column headings centered,
        columns                                                     bold, and underlined
    Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing Attributes and
  Alignment

 Common attribute and alignment buttons




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Adjusting Column Width
    • Adjust column widths to
      accommodate data
            • Default column width is 8.43 characters
              wide (a little less than one inch)
            • One or more columns can be adjusted
              using the mouse, the Ribbon, or the
              shortcut menu



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Adjusting Column Width
    • Column heading is the box at the top
      of each column containing a letter
    • Changing a column width with the
      mouse
            • Position the mouse pointer between the
              column headings of the column and the
              column to its right
            • Click and drag the resize pointer to the
              right
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Adjusting Column Width
    • Using the AutoFit feature
            • Position the mouse pointer between the
              column headings of the column and the
              column to its right
            • Double-click to activate the AutoFit
              feature




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Adjusting Column Width

               Preparing to change the column width

Resize pointer




                                                                        Click to change
                                                                        column or row
                                                                           formatting




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Inserting and Deleting Rows
  and Columns
    • When you insert a new row, the
      contents of the worksheet shift down
      from the newly inserted row
    • When you insert a new column, the
      contents of the worksheet shift to the
      right of the new column
    • Excel inserts rows above the cell
      pointer and columns to the left

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Inserting and Deleting Rows
  and Columns

                                  Insert dialog box




   Entire row
  option button




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Inserting and Deleting Rows
  and Columns
    • Deleting rows and columns
            • Select the row or column heading
            • Click the Delete button in the Cells
              group or use the Delete command on
              the shortcut menu




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Applying Colors, Patterns,
  and Borders
    • You can add enhancements such as
      colors, patterns, and borders by
      using:
            • Border and Fill Color buttons in the
              Font group on the Home tab of the
              Ribbon and on the Mini toolbar, or
            • Fill tab and Border tab in the Format
              Cells dialog box


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Applying Colors, Patterns,
  and Borders
    • Cell styles are pre-designed
      combinations of formatting attributes
            • Use the Cell Styles button in the Styles
              group on the Home tab




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Applying Colors, Patterns,
  and Borders
  Viewing fill color using LivePreview
                                                                          Cell styles
                                                                            button




 Font color
 list arrow

                                                                        Cell A1 with
                                                                         light blue
                                                                        background

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Naming and Moving a Sheet
    • By default, an Excel workbook
      initially contains three worksheets,
      named Sheet1, Sheet2, and Sheet3
    • To move to another sheet, click its
      sheet tab
    • To make it easier to identify the
      sheets, you can rename each sheet
      and add color to the tabs

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Naming and Moving a Sheet
    • To rename a sheet, double-click its
      sheet tab, type the new name, and
      then press [Enter]
    • To add color to a sheet tab, right-
      click the sheet tab, point to Tab
      Color, and then choose a color
    • You can change the order of sheets
      by dragging the sheet tabs

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Naming and Moving a Sheet


                                 Sheet during move




     Sheet
   relocation                    Sheet1                 Indicates
     pointer                    renamed                 tab color


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Checking Spelling
 • Spelling checker scans the
   worksheet and flags possible
   mistakes and suggests corrections
         • To check other worksheets in a
           workbook, display the worksheet and
           run the spelling checker again
         • Add words that are spelled correctly but
           are not recognized by the spelling
           checker

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
   Checking Spelling
                        Spelling: English dialog box




Misspelled
  word



Replacement
   word
suggestions



 Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Planning a Chart
    • Chart elements
            • The horizontal axis (x-axis) is also
              called the category axis
            • The vertical axis (y-axis) is also called
              the value axis
            • The z-axis is present in 3-D charts
            • Area inside the horizontal and vertical
              axes is called the plot area
            • The scale of measure on the y-axis is
              identified by tick marks
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Planning a Chart
    • Chart elements (cont.)
            • A data point is the value in a cell you
              select for your chart
            • A data marker visually represents each
              data point in the chart
            • A group of related data points is a data
              series
            • A legend makes it easy to identify each
              data series

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
   Planning a Chart
                Chart elements


                                                                                      Data point
Vertical axis
                                                    Plot area

Tick marks

                                                                                       Legend




      Data                 Data
                                                                    Horizontal axis
      marker               series
 Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Planning a Chart

Common chart types




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Creating a Chart
• To create a chart:
        • Select a range of data
        • Use buttons on the Insert tab of the
          Ribbon to create and modify a chart
• An embedded chart is one that is
  inserted directly in the current
  worksheet



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Creating a Chart
• Sizing handles, the small series of dots
  at the corners and sides of the chart’s
  border, indicate that the chart is
  selected
• A chart sheet is a sheet in a workbook
  that contains only a chart, which is
  linked to the workbook data



Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Creating a Chart
           Column chart palette




         Clustered                                                      Column chart
         Column
                                                                        types
         chart type
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Moving and Resizing a Chart
    • A chart is a graphic, or drawn object
    • Not located in a specific cell or range
    • An object is an independent element
      on a worksheet
            • Can be moved anywhere worksheet
              without affecting formulas or data
            • Resize a chart by moving its sizing
              handles; move a chart by dragging it

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Moving and Resizing a Chart
              Moved and resized chart




                                                                        Middle-right
                                                                        sizing handle




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing the Chart Design
    • Changing data values in the
      worksheet automatically updates
      the chart
    • Chart Tools tabs can be used to
      make specific changes in a chart




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing the Chart Design
    • Using the Chart Tools Design tab,
      you can:
            • Change the chart type
            • Modify the data range and configuration
            • Change the layout of objects
            • Choose from coordinating color
              schemes
            • Move the location of the chart

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing the Chart Design

                           Change Chart Type dialog box

Currently
selected chart
type




 Chart type
 categories




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing the Chart Layout
    • Chart Tools Layout tab makes it easy
      to create and modify individual chart
      objects
    • Using the Chart Tools Layout tab,
      you can:
            • Add shapes and text to a chart
            • Add and modify labels
            • Change the display of axes

Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Changing the Chart Layout
    • Using the Chart Tools Layout tab,
      you can (cont.):
            • Modify the fill behind the plot area
            • Eliminate or change the look of
              gridlines
            • Create titles for the horizontal and
              vertical axes
            • Add graphics or background color


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
             Changing the Chart Layout
                      Axes titles added to chart



Chart                                                                                   Axis Titles
Elements                                                                                button
list arrow
                                                                               Chart title
Vertical axis
title                                                                          Horizontal
                                                                               axis labels

 Vertical axis                                                                 Horizontal
 labels                                                                        axis title

       Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
                     Formatting a Chart
    • Chart Tools Format tab can be used
      to make formatting enhancements
            • Change colors in a specific data series
            • Apply a style to a series using the
              Shape Styles group
            • WordArt, which lets you create curved
              or stylized text, can be created using
              the WordArt Styles group


Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
                     Formatting a Chart
                                         Format Data Series dialog box


Click Border Color to
control line display




Click Shadow to
control shadow
settings




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Create a Pie Chart
    • You can create multiple charts based
      on the same worksheet data
            • Different chart types can be better at
              emphasizing different parts of the data
    • In a pie chart, emphasize a data
      point by exploding, or pulling that
      slice away from the pie chart
    • In landscape orientation, the text
      runs the long way on the page
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
  Create a Pie Chart
      Exploded pie slice




Microsoft Office 2007-Illustrated Introductory, Premium Video Edition

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:9/14/2012
language:English
pages:78