Lesson 21: Editing and Formatting “Charts”
Office 2000-2002-2003-XP

Editing and formatting charts

What you will learn
  • Changing the sub-type of Chart
  • Changing the Range
  • Change of titles
  • Repositioning of the Legend
  • Add Data Labels
  • Add independent text
  • The mapping of time-scale data
  • Preparation of series from the chart
  • Adjusting the perspective of a 3D chart
  • Standard chart

Lesson 22: “Pivot Tables”
Office 2000-2002-2003-XP

Pivot Tables

What you will learn
  • Creating PivotTables and PivotCharts
  • Manipulate PivotTables
  • The PivotTable toolbar
  • Changing Field Properties
  • Automatic Formatting PivotTables
  • PivotChart view
  • PivotTable options
  • Page view options
  • Adding Sub-totals in PivotTables
  • Sort and filter fields

Lesson 27: “Advanced Filter”
Office 2000-2002-2003-XP

Advanced filters

What you will learn
  • Advanced filters
  • The use of "And" and "Or" conditions
  • The use of wildcards in criteria
  • Copy filtered data to a new location
  • Database functions

Lesson 28: “Data Tables”
Office 2000-2002-2003-XP

Data Tables

What you will learn
  • What are Data Tables?
  • The formula reference table
  • Data tables with one variable value
  • Data tables with two variable values

Lesson 29: “Search and Logical Functions”
Office 2000-2002-2003-XP

Search and Logical Functions

What you will learn
  • What is a function?
  • Search functions (LOOKUP function)
  • Logical Functions
  • The nesting of logical functions
  • Suppressing error messages
  • The use of "AND" and "OR" functions

Lesson 30: “Scenarios”
Office 2000-2002-2003-XP

Scenarios

What you will learn
  • Creating scenarios
  • Editing and deleting scenarios
  • Merge Scenarios
  • Scenario reports
  • Goal Seek (Goal Seek)