Quattro Pro: Advanced (Day 2 of 2)

Performance Based Objectives

  • Use the QuickChart button to display data graphically.

  • Use the Chart Expert, Chart Gallery, and Chart Advisor to create a chart and change its overall appearance.

  • Enhance a chart's display by changing chart object properties, adding data details, and drawing objects on the chart.

  • Create and enhance pie charts and combination charts.

  • Create a map chart, and create and run an automated slide show presentation.

  • Sort data in a notebook based on one or more columns.

  • Work with spreadsheet data as a database to locate records, and groups of records, that meet specific criteria.

  • Work with spreadsheet data as a database to extract and manipulate records, and groups of records, that meet specific criteria.

  • Use database functions to perform calculations and summarize data by creating a Cross Tabs report.

Course Content
Lesson 1: Introduction to Charts
  • The QuickChart Button
  • Exploring Chart Types
  • Previewing a Chart and Using the Objects Sheet

Lesson 2: Using the Chart Expert

  • Using the Chart Expert
  • The Chart Gallery and Chart Advisor

Lesson 3: Enhancing Charts

  • Working with Chart Properties and Elements
  • Working with Chart Details
  • Using Drawing Tools

Lesson 4: Extracting Records

  • One-key Sorts
  • Multiple-key Sorts
Lesson 5: Extracting Records
  • Database Terminology and Guidelines
  • Extracting Records
  • Working with the Output Cells
  • Creating OR and AND Conditions

Lesson 6: Introduction to Selected Database Topics

  • Using Database Functions
  • Summarizing Data in a Cross Tabs Report

this document.

Toll Free 877.NOVATECH (668.2832)