Loading...

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.

Unit 7 Time Advisory
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.
 
Terms of Use: The textbook used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License without attribution as requested by the work’s original creator or licensee.
 

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.
 
Terms of Use: Please respect the copyright and terms of use displayed on the webpage above.

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.
 
Terms of Use: Please respect the copyright and terms of use displayed on the webpage above.

  • 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.
     
    Terms of Use: The resource used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License. It is attributed to Velda Arnaud.

7.4 Combination Charts   - Reading: The Saylor Foundation’s “Combo Charts in Excel®” Link: The Saylor Foundation’s “Combo Charts in Excel®”
 
Instructions: Open the PDF document to learn about combination charts by creating one.
 
Reading this document should take approximately 45 minutes.