Microsoft Excel Lesson 4

1
Microsoft ExcelLesson 4

• Lexington Technology Center
• April 2007
• Bob Herring

2
Excel Lesson 4
Review of the Previous Lesson

• Copying cells using relative and absolute cell
  addresses
• Functions
• Printing
• Page Setup
• Excel Options
• Correcting Errors
• Clearing Cells or Worksheets

2
3
Excel Lesson 4
Charts

• Highlight the area that contains the data for
  the chart
• Select Insert, then Chart. This will launch
  the Chart Wizard

3
4
Excel Lesson 4
Chart Wizard, Step 1

• The Chart Wizard guides the user through the
  creation process
• The first dialog allows the user to select a
  type of chart

4
5
Excel Lesson 4
Chart Wizard, Step 2

• Navigate through the dialogs using the and Next buttons
• Note the difference between using rows and
  columns as the key

5
6
Excel Lesson 4
Chart Wizard, Step 3

• This dialog controls the titles, labels, and
  appearance of the chart
• The labels appear on the preview as you type

6
7
Excel Lesson 4
Chart Wizard, Step 4

• The final dialog allows the user to place the
  chart, either on
• its own worksheet or within one of the
  existing worksheets
• When satisfied, click Finish to see the
  completed chart

7
8
Excel Lesson 4
Charts

• The completed chart can be placed to enhance
  presentation, yet
• remains linked to its data. If the data
  changes, the chart will too

8
9
Excel Lesson 4
Chart Types

• Bar and Column Charts
• Show variation over a
• period of time or draw
• comparisons between items

• Area Charts
• Show the relative importance
• of values over time

9
10
Excel Lesson 4
Chart Types

• Line Charts
• Show trends or changes in
• data over a period in time

• Pie Charts
• Show the relationship or
• proportions of parts to a
• whole

10
11
Excel Lesson 4
Chart Types

• High-Low-Close Charts
• Show a common presentation
• of stock prices

• XY (Scatter) Charts
• Show the relationship or degree
• of relationship between numeric
• values of two data series

11
12
Excel Lesson 4
Chart Types

• Surface Charts
• Find optimum combinations
• between two sets of data

• Radar Charts
• Show changes or frequencies of
• data relative to a center point
• and to each other

12
13
Excel Lesson 4
Design for Looks

• Double click in between column headings to
  automatically
• make the column fit its widest entry
• Use borders and shading
• Add and delete rows and columns
• Use drawing tools and clip art (import company
  logos)
• Create your own standard formats
• Excel spreadsheets can be copied into Word or
  PowerPoint,
• which may lessen the need for fancy
  formatting

13
14
Excel Lesson 4
Design for Looks

• Here is some (fictitious) data from an authors
  book tour
• Unformatted, it is hard to read and understand

14
15
Excel Lesson 4
Design for Looks

• The same data, with some formatting
• Give this a try!

15
16
Excel Lesson 4
Design for Looks

• Excel has many tools to add formatting to the
  worksheet

For Clip Art, Select Insert
Format Painter Tool
Font Size Tool
Borders Tool
Bold Tool
Merge Tool
Italic Tool
Right Tool
Center Tool
Fill Tool
16
17
Excel Lesson 4
Design for Looks

• Select Insert, then Picture, then Clip Art ...
• The Academic category has a book picture for
  the worksheet

17
18
Excel Lesson 4
Design for Looks

• The same data, with some formatting

18
19
Excel Lesson 4
Excel Help

• To get help, type a search string into the box
  at the top right corner
• If help finds an article that contains the
  string, it brings it up in the
• Search Results pane
• Click on an article to see the help file

Help Box
Search Pane
19
20
Excel Lesson 4
Sorting

• Excel can quickly sort your data by column
• Select Data, then Sort to bring up the Sort
  dialog box

20
21
Excel Lesson 4
Sorting

• Excel allows the user to sort on up to three
  columns, with the option
• to sort ascending and descending
• The Options button lets you sort by days or
  months (or any list) and
• to sort lower case and upper case and left
  to right instead of top to
• bottom

Sort order for Case sensitive Symbols,
Numbers, Lower, Upper
21
22
Excel Lesson 4
Freezing Panes

• Column and row headers can be immobilized on
  the screen
• Click in the cell whose upper left corner will
  be the intersection
• of the frozen area
• Select Window, and then Freeze Panes

22
23
Excel Lesson 4
Panes Frozen

• Excel displays vertical and horizontal lines to
  mark the boundary
• of the frozen area

Horizontal Pane Marker
Vertical Pane Marker
23
24
Excel Lesson 4
Review

• Creating Charts
• Custom Formats
• Design for Looks
• Excel Help
• Sorting
• Freezing Panes

24