Working with Numbers: Excel 97 - 2003
Project 4: Data Groups & Formulas

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

Project Objectives

  • Create groups that have Subtotals
  • Expand/Collapse groups
  • AutoCalculate
  • Insert AutoShape
  • Insert image
  • Format data groups with color and border
  • Fix broken formulas

Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel BasicsTo subtopics    

Project 3: Format & ArrangeTo subtopics    

Project 4: Groups & Formulas To subtopics
    SubtotalsTo subtopics
    Images & DrawingsTo subtopics
    Changes & FormulasTo subtopics
    ExercisesTo subtopics

Project 5: DesignTo subtopics


In Excel Project 4 you will look at grouping your data in useful ways, especially for subtotals.  You will find that thoughtful formatting and spacing of parts will help make your spreadsheet easier to use. Images and AutoShapes can enhance your sheets. You will look at how making changes to your sheet can break your formulas. So, of course, you will learn how to repair broken formulas.