Week 3 - Creating and Editing Charts (Ch3) | Formatting, Organizing, and Getting Data (Ch4)

Overview

In addition to building formulas and functions in a worksheet, you can use Excel to graph or chart data. After selecting values and labels, you can quickly create a professional looking chart with a few clicks of the mouse. Our third chapter introduces you to the basics of creating, editing, and formatting Excel charts.

Excel can use data from many sources as well as provide data to other programs. When data is shared among applications, the data is usually in a list or table layout like a database. Our fourth chapter covers how to format data as an Excel table, how to sort and filter data, how to get data from other sources, and how to build a PivotTable.

Objectives

At the end of this week, you will be able to:

Learning Activities

  1. Check out the informational items for some in-depth specifics.
  2. Read Excel Ch 3 (SIMBook) in SIMnet.
  3. Read Excel Ch 4 (SIMBook) in SIMnet.
  4. Complete the end-of-chapter questions to check your knowledge (you are not required to submit these).

Assignments

  1. Complete Excel Ch 3 SIMBook Let Me Try in-reading tasks.
  2. In SIMnet, complete Excel Ch 3 SIMpath.
  3. Complete Excel Ch 3 SIMnet Project 3-3.
  4. Complete Excel Ch 3 SIMnet Project 3-4.
  5. Complete Excel Ch 4 SIMBook Let Me Try in-reading tasks.
  6. In SIMnet, complete Excel Ch 4 SIMpath.
  7. Complete Excel Ch 4 SIMnet Project 4-3.
  8. Complete Excel Ch 4 SIMnet Project 4-4.