Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101
Home > Jan's CompLit 101 > Working with Numbers > Design
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Design

Project Objectives

  • Learn sheet design principles
  • Create, format, and print comments.
  • Create a data validation input message.
  • Use Planning Checklist
  • Create a What If sheet
  • Use the IF function and conditional formatting
  • Create formulas using cell names
  • Share data with Word

The real power of spreadsheets is not in simple sheets that are created and used just once. It's in the sheets that can be used and reused and the sheets that allow you to change values to see what the consequences are. These are called What If sheets.

In this project you will learn to recognize good design for spreadsheets and how to plan one yourself. You will document what you have done and why. You will learn to use spreadsheets for What If experiments and how to apply formatting that depends on the values, called conditional formatting. Finally you will learn some of the ways to include a spreadsheet in a Word document.