Excel XP Proficient User

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.

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

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.

Skills-Based

Internet / Intranet, Download, LAN, Workstation

NASBA credits: 4 CPE Credits

American English

6 to 8 hours

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

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD

Training Presented in: English