Provided by: 123-CBT Computer Based Training Excel XP Proficient User Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

Course Overview

This course covers the advanced skills of working with worksheets in Excel 2002, and teaches how to manage display properties, advanced calculation techniques and worksheet data manipulation. The Outline and Web Integration section covers outlining worksheets and publishing a workbook as a Web page. Finally, the Charts and Drawing Objects section teaches creating and modifying a chart and drawing objects.

Learn To

• Add a button on a toolbar.
• Customize a menu by creating commands.
• Identify built-in formats for numbers.
• Identify the features of functions.
• Create a formula by using a basic function.
• Include a range in a function.
• Consolidate data by category.
• Consolidate data by using a three-dimensional (3-D) reference.
• Set up data validation.
• Identify the functions of Outline symbols.
• Outline a worksheet automatically.
• Outline a worksheet manually.
• Create a chart.
• Modify the location of a chart.
• Modify the appearance of a chart.

Audience

The target audience for this course will be End Users and Power Users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or managerial duties. They may be involved in working with accounting and financial data. The audience will include end users, help desk/support personnel, and other network designers. It is expected that learners should have a working knowledge of Microsoft Windows 9x or later operating systems. Some learners may have a basic knowledge of either Microsoft Office 97 or 2000 programs and should have taken Microsoft Excel 2002 Fundamentals course 74030.

Content Emphasis

Skills-Based

Deployment Options

Internet / Intranet, Download, LAN, Workstation

Accreditation

NASBA credits: 4 CPE Credits

Language Options

American English

Total Learning Time

6 to 8 hours

74031 Objectives

Unit 1: Managing Display Properties

1.5 - 2 hours
• Add a button on a toolbar.
• Customize a menu by creating commands.
• Identify built-in formats for numbers.
• Identify custom number formats.
• Add a cell comment.
• Edit a cell comment.
• Create a Web comment.
• Reply to a Web comment.

Unit 2: Advanced Calculation Techniques

1.5 - 2 hours
• Identify the features of functions.
•

Training Avaliability and Delivery

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD Contact 123-CBT Computer Based Training for more information

Training Presented in: English

About 123-CBT Computer Based Training - Training Provider

More Microsoft Excel XP Training from 123-CBT Computer Based Training

• Excel 2002 Advanced
• Excel 2002 Basic
• Excel 2002 Intermediate
• Excel 2002 Set of 3
• Excel XP Curriculum
• Excel XP Essentials Set of 3
• Excel XP Expert User
• Excel XP Fundamentals
• Excel XP Proficient Expert