• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User Microsoft Office Training Courses

Excel 2000 Advanced

View course dates

Course Duration: 2 days

Course Code: DEX2KA

Course Description:

This in-depth two-day course introduces Microsoft Excel 2000 users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; use outlines on worksheets, lookup and database functions, and PivotTables. In-class exercises will involve use of data tables and scenarios to make projections about data and use Goal Seek, Solver, and the Analysis ToolPak to analyze data. Students will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros and templates, and import and export information and documents. Additional topics include use of workgroup features; working with custom views and Report Manager; and creating and modifying data maps.

 

After completing the Excel 2000 Introduction, Intermediate, and Advanced courses, students would have covered all the topics that map to the Microsoft Office User Specialist Expert certification exam.

Prerequisite courses:

Excel 2000 Introduction

Excel 2000 Intermediate

Relevant Certifications:

MOS: Microsoft Office 2000 Track

This course includes the following modules:

Course contents include:

• Sort and manage data in lists.
• Filter and query data.
• Use outlines on worksheets.
• Use lookup and database functions.
• Use PivotTables to display and chart data.
• Use data tables and scenarios to make projections about data.
• Use Goal Seek, Solver, and the Analysis ToolPak to analyze data.
• Audit worksheets.
• Protect worksheets and workbooks.
• Create and use macros.
• Use and create templates.
• Import and export information and documents.
• Use workgroup features.
• Work with custom views and Report Manager.
• Create and modify data maps.

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course