Advanced Tools of Excel 2000

Training Provided by Teach Me IT The Advanced Tools of Excel 2000 WBT is the third course in the Excel 2000 curriculum. This course teaches the users to create 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. After completing this course, the student will be able to:

Create and format charts
Create and customize maps
Create and format a PivotTable
Modify the arrangement of data in a PivotTable
Create PivotCharts
Create a PivotChart from a PivotTable
Create macros for automating tasks
Create templates and databases
Manage databases
Link office documents with object linking
Use hyperlinks with other office documents

Advanced Tools of Excel 2000

Other Courses in the Curriculum  Getting Started with Excel 2000  Data Management in Excel 2000 Course Name Advanced Tools of Excel 2000 Audience End users who are familiar with the GUI environment and need to use numeric data for performing mathematical calculations and data analysis.  Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements  ØMacromedia Shockwave plug-in for Windows for IE/NN  ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.   Pre-requisites Users should be familiar with Microsoft Office products and Windows 95/98 operating systems. The users should have a basic knowledge of Excel 2000 and an understanding of formulas and functions used to compute data in Excel 2000. Additionally, the users should be familiar with scenarios and reports.  Course Duration 4.5  hours Course Objectives The Advanced Tools of Excel 2000 WBT is the third course in the Excel 2000 curriculum. This course teaches the users to create 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. After completing this course, the student will be able to: Create and format charts Create and customize maps Create and format a PivotTable Modify the arrangement of data in a PivotTable Create PivotCharts Create a PivotChart from a PivotTable Create macros for automating tasks Create templates and databases Manage databases Link office documents with object linking Use hyperlinks with other office documents   Course Outline Excel Charts and Maps Creating Charts in Excel Customizing Charts in Excel Creating Maps in Excel Quiz PivotTables and PivotCharts Creating PivotTables Creating PivotCharts Quiz Macros and Databases Creating Macros and Templates Managing Excel Databases Using Excel Objects Quiz

About The Training Provider: Teach Me IT

More Excel 2000 Training from Teach Me IT

• Data Management in Excel 2000
• Getting Started with Excel 2000