Microsoft Excel 97 Curriculum CBT Training CDs

Rating:
Summary: Microsoft Excel 97 Curriculum CBT
Review: Course Overview
This course series is intended for individuals seeking the fundamental and advanced skills of Microsoft Excel 97. This series will also prepare individuals who are seeking to become a Microsoft Excel Proficient Specialist and Microsoft Excel Expert Specialist.

Learn To
See individual course descriptions for detail.

Audience
This course series is intended for individuals who want to learn the fundamental and advanced skill of Microsoft Excel 97.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course
ITCAP credits: 1.5 Credit Hours
CEU credits: 1.40 CEUs

Language Options
US English

Total Learning Time
12 to 16 hours

Objectives
Unit Course Series: Microsoft Excel 97 Curriculum: Proficient and Expert 12 - 16 hours
# Course Series: 71031-71032
# The first course in this series provides students with the knowledge to enter text, numbers and formulas; insert, modify and delete rows and columns; use absolute and relative references; sort data; preview and print worksheets; format worksheet information; create and apply ranges; use Excel's built-in functions; create charts and use drawing capabilities; save spreadsheets in HTML format. This course covers the skills tested in the "Microsoft Excel Proficient Specialist" exam and has been approved by Microsoft. The second course in this series provides students with the knowledge to use advanced formatting capabilities; perform queries within a list or database; use filters and extract data; use data analysis, pivot tables and data maps; audit worksheets; use data validation and conditional formatting; create and use macros; import data and export data with other applications; create and edit templates; link data in multiple workbooks; use workgroup features of Excel. This course covers the skills tested in the "Microsoft Excel Expert Specialist" exam and has been approved by Microsoft.




Microsoft Excel 97 Proficient User
Course Overview
This self-paced learning course will instruct you on working with Microsoft Excel 97. The unique instruction uses text, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to have a personalized study path based on the knowledge and skills demonstrated. Mastery modules at the end of each unit allow you to verify your understanding of key skills and guide you back to any content that warrants further study.

Learn To
# Create budgets and expense reports.
# Create marketing and sales reports.
# Create invoices and purchase orders.
# Create spreadsheet information for use on the Internet/Intranet.


Audience
This course is intended for both a new spreadsheet user or a person familiar with Excel but not this version. Participants should have taken Microsoft Windows 95 Fundamentals (Course 70011).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: 0.5 Credit Hour
CEU credits: 0.65 CEUs

Language Options
US English, French, Dutch, Spanish, Brazilian Portuguese, German, Japanese

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Working with Workbooks 1 - 2 hours
# Start Excel.
# Open a workbook.
# Enter text and numbers.
# Enter formulas.
# Save and close workbooks.
# Save spreadsheets to be read on HTML.
# Read an HTML spreadsheet.


Unit 2: Entering and Editing Data 1 - 2 hours
# Create and name ranges.
# Clear and format ranges.
# Copy and move ranges.
# Preview and print worksheets.
# Print the screen and ranges.
# Print headers and footers.


Unit 3: Formatting Worksheets 2 hours
# Delete cell contents.
# Delete a worksheet.
# Revise text and numbers.
# Rotate and indent text.
# Revise formulas.
# Copy and move data.
# Insert, modify, and delete rows and columns.
# Use references: absolute relative mixed
# Modify cell size and alignment.
# Apply general numbers formats.
# Apply font formats.
# Apply outlines.
# Create and modify lines and objects.
# Create and modify 3D shapes.


Unit 4: Charts 2 hours
# Create and format and modify charts.
# Preview and print charts.




Microsoft Excel 97 Expert User
Course Overview
This multimedia self-paced learning course will instruct you on working with the advanced features and functions of Microsoft Excel 97. The unique instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Preassessment testing in the beginning of each unit will allow you to have a personalized study path based on the knowledge and skills demonstrated. Mastery modules at the end of each unit allow you to verify your understanding of key skills and guide you back to any content that warrants further study.

Learn To
# Create accounting and financial statements.
# Create data analysis.
# Create statistical tables.
# Create amortization schedules.
# Create forecasts.
# Create personnel records.
# Create lists.


Audience
This course is intended for experienced Microsoft Excel 97 users who wish to leverage Excel's more advanced features and options. Participants should have taken Microsoft Windows 95 Fundamentals (Course 70011) and Microsoft Excel 97 Proficient User (Course 71031).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
ITCAP credits: 0.5 Credit Hour
CEU credits: 0.70 CEUs

Language Options
Spanish, Brazilian Portuguese, German, US English, French, Dutch

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Editing, Formatting and Printing Techniques 1 - 2 hours
# Apply general number formats.
# Create custom formats.
# Use styles and autoformats.
# Preview and print workbooks.
# Import from other applications.
# Export to other applications.


Unit 2: Advanced Calculation Techniques 1 - 2 hours
# Create and record macros.
# Edit macros.
# Run macros.
# Check and review data.
# Find cells referred to in a specific formula.
# Find formulas that refer to a specific cell.
# Find errors.


Unit 3: Database and Workgroup Functionality 2 hours
# Work with existing templates.
# Create templates.
# Edit templates.
# Query a database.
# Perform a web query.
# Extract data.
# Use filters.
# Use data analysis and pivot tables.
# Use data map.
# Sort data.
# Run a query from a list.
# Link workbooks.
# Use multiple workbooks.


Unit 4: Workgroup Functions 2 hours
# Use cell tips.
# Use share lists.
# Track changes.
# Resolve conflicts.
# Show history of changes.
# Merge workbooks.