Students will use a variety of ways to create visually interesting worksheets. You will learn when to create charts, which chart types to use for different situations, and how charts are particularly useful in understanding relationships among numbers in a worksheet. In this chapter, you will also learn about formatting data based on desired conditions and inserting pictures and shapes.

- Insert charts
- Use chart tools to modify charts
- Move and size charts
- Edit chart data
- Add images to a worksheet
- Apply conditional formatting

Students will demonstrate learning by creating the following projects:

  • Sales Charts
  • R1+R2-VHours
  • R3-SummerFunds
  • A1+A2-Profit
  • A3-LTForecast
  • WorldWideWeather
Lesson # Lesson Title Duration of Days