Microsoft® Excel 2002 Proficient User CBT Training CD

Rating:
Summary: Microsoft® Excel 2002 Proficient User CBT Training CD
Review: 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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Italian, German, Polish, Spanish, Chinese, Russian, US English, Arabic, French, Dutch

Total Learning Time
6 to 8 hours

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.
# Create a formula by using a basic function.
# Include a range in a function.
# Include a date function in a formula.
# Include an IF logical function in a formula.
# Include a financial function in a formula.
# Include a lookup function in a formula.
# Create a named range.
# Include a named range in a formula.


# Unit 3: Worksheet Data Manipulation - 1-2 hours Consolidate data by category.
# Consolidate data by using a three-dimensional (3-D) reference.
# Set up data validation.
# Trace a dependent and precedent cell in a formula.
# Match each formula error value with its description.
# Protect a selected area in a worksheet.
# Protect an entire workbook.


# Unit 4: Outlining and Web Integration - 1 hour Identify the functions of Outline symbols.
# Outline a worksheet automatically.
# Outline a worksheet manually.
# Create a hyperlink to a Web site from a workbook.
# Preview a workbook as a Web page.
# Save a workbook as a Web page.
# Publish a workbook on the Web.


# Unit 5: Charts and Drawing Objects - 1 hour Create a chart.
# Modify the location of a chart.
# Modify the appearance of a chart.
# Modify chart options.
# Add a trendline to a chart.
# Set up a chart for printing.
# Insert a drawing object.
# Modify the appearance of a drawing object.