# PRDV252: Intermediate Excel

Unit 7: More Work with Charts   To start this unit off we will take a look at a couple of videos from the Goodwill Foundation’s Excel® 2010 series. We have used this video series in previous units of this class, but now we will look at how they build charts in Excel® 2010. Also, we will look at Sparklines – a new feature in Excel® 2010. Sparklines are very small charts that can fit into a cell, usually adjacent to the cell where the data are derived from. The Sparkline graphically represents the number, and when used in consecutive cells, can create a visual way to differentiate numerical data for easier comprehension by the reader, without a large separate chart either embedded on a page or separate from the data.

Completing this unit should take you approximately 3 hours.

☐    Subunit 7.1: 0.5 hours

☐    Subunit 7.2: 0.5 hours

☐    Subunit 7.3: 1.25 hours

☐    Subunit 7.4: 0.75 hours

Unit7 Learning Outcomes
Upon successful completion of this unit, you will be able to: - construct a scatter chart to show the supply and demand curves for a market; - create a trendline and line equation for a data series; - describe how to create Sparklines; - describe how to change a chart type after a chart has been developed; - define a combination chart; - describe how to create a combination chart

7.1 The Scatter Chart   - Reading: How to Use Microsoft Excel®: “Section 4.3” Link: How to Use Microsoft Excel®: Section 4.3 (PDF)

Instructions: Go to Chapter 4, Section 4.3: The Scatter Chart, which starts on page 366. Continue to use the file you started in Subunit 6.2 (Excel® Text Chapter 4). This is the last section of the textbook. I hope you have saved the text so you can reread it later if you want to.

Completing this assignment should take approximately 30 minutes.

7.2 Working with Charts   - Web Media: GCFLearnFree.org’s “Excel® 2010: Working with Charts” Link: GCFLearnFree.org’s Excel® 2010: Working with Charts (HTML)

Instructions: Read through the six pages and watch the video on page 2. On page 4 they show you how to change a chart type after a chart has been created. This is something that was not shown before and can be useful when you want to compare charts and how your data will look before printing or sharing with others. If you have Excel® 2010, open the Excel® practice spreadsheet and follow the directions on page 6 to practice what was demonstrated in the videos.

Completing this assignment should take approximately 30 minutes.

7.3 Sparklines   - Web Media: GCFLearnFree.org’s “Excel® 2010: Working with Sparklines” Link: GCFLearnFree.org’s Excel® 2010: Working with Sparklines(HTML)

Instructions: Read through the six pages and watch the video on page 2. If you have Excel® 2010, open the Excel® practice spreadsheet and follow the directions on page 6 to practice what was demonstrated in the videos.

Completing this assignment should take approximately 30 minutes.

• Web Media: Merlot’s “Microsoft Excel® 2010: Understanding Data: Create Sparklines” Link: Merlot’s Microsoft Excel® 2010: Understanding Data: Create Sparklines

Instructions: Click on the link above which will take you to a page with several categories of topics. Scroll down to the section on Understanding Dataand click on the link: MS: Create Sparklines. In the link, the left sidebar contains links to four short videos that thoroughly explain Sparklines and how to format them. You don’t need to do the Practice page but you may want to do the Test Yourselfquestions at the end to ensure that you understood the concepts.

Completing this assignment should take approximately 45 minutes.