 |
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
|
|