Exploring Microsoft Excel 97

1
ExploringMicrosoftExcel 97

• Second Project
• Sorting and Filtering a Worksheet Database
  Creating a Data Map

CSU, COB, MMIS INSY137 Fall-99.
2
Data Mapping Overview

• Slide 1 of 2
• Data mapping enables you to visualize
  quantitative data
• Create a data map by
• 1) Select the data to be mapped
• 2) Indicate where map goes
• 3) Choose the type of map
• 4) Apply the finishing touches

3
Data Mapping Overview

• Slide 2 of 2
• Data Map Control dialog box determines the type
  of formatting
• Maps available for US, Mexico, Canada, Australia,
  the UK and the world

4
Introduction to Data Mapping

• Hands-On Exercise 1
• Insert a Cell Note
• Draw the Map
• The Microsoft Map Control
• Edit the Legend
• The Finishing Touches
• Place the Map in Its Own Worksheet
• The Print Preview Command

5
From Data to Maps

6
Microsoft Map Control

• Allows for six formats
• User must determine which is appropriate for a
  particular map
• Plotting identical data in different forms can be
  helpful for choosing the right data map

7
Microsoft Map Control

8
Finer Points of Data Mapping

• Hands-On Exercise 2
• Draw the Map
• Edit the Legend
• Microsoft Map Control
• Value Shading Options
• Map Labels
• Complete the Map
• Place the Map in Its Own Worksheet

9
Mapstats Workbook

• Find Mapstats workbook through Windows Explorer
  or Find Command
• Data is extensive for both U.S. and the world
• Data mapping can be very informative
• Save workbook under a different name to keep the
  original copy