|
Provided by: 123-CBT Computer Based Training Excel XP Proficient User |
 |
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.
•
|
|
||||||||||
