Description
This course is the third course in a series of three in the Excel 2000 curriculum. This course covers the creation of PivotTables, PivotCharts, macros, and databases. The course introduces students to maps and templates in Excel. The course also describes linking of office documents with object linking and using hyperlinks with other office documents.
Audience
Application developers who plan, design and implement distributed Excel applications.
Prerequisites
(Currently no course prerequisite information)
Objective
Upon completion of this course the student will be able to:
create charts using the Chart Wizard format charts in Excel create maps in Excel customize Excel maps create a PivotTable modify the arrangement of data in a PivotTable format a PivotTable create PivotCharts in an Excel worksheet create a PivotChart from a PivotTable create macros for automating tasks create templates create databases in Excel manage databases in Excel link office documents with object linking use hyperlinks with other office documents
Topics Include
Excel Charts and Maps
- Creating Charts in Excel
- Customizing Charts in Excel
- Creating Maps in Excel
PivotTables and PivotCharts
- Creating PivotTables
- Creating PivotCharts
Macros and Databases
- Creating Macros and Templates
- Managing Excel Databases
- Using Excel Objects
Duration
3 hrs
Minimum Requirements
Netscape or Internet Explorer (versions 4.0 or higher). Â Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display; Macromedia Shockwave Version 6.02 or higher.
Media
Web Based Training
|