Excel 2003: Charts and Databases
Product Code: EXCL06 Time: 4 Hour(s) CEUs: .40

Summary:

This course teaches the user how to add charts and graphics to worksheets, and how to create and manage databases using Excel 2003.

Objectives:

After completing this course, students will be able to:
  • Create charts using Chart Wizard
  • Insert clip art into a worksheet
  • Create your own graphics
  • Create a database
  • Manage a database

Outline:

  • Using the Chart Wizard
  • Editing charts
  • Changing the chart options
  • Adding images
  • WordArt and organizational charts
  • Grouping and hiding images
  • Creating a database
  • Adding e-mail and Web addresses
  • Viewing and finding records
  • Sorting records
  • Using AutoFilter
  • Custom AutoFilters

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Simulations that allow users to practice course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This course is for anyone who wants to get the most out of using Excel 2003.

Prerequisites:

Excel 2003: Getting StartedExcel 2003: Creating a SpreadsheetExcel 2003: Formatting DataExcel 2003: Editing and Printing WorksheetsExcel 2003: Managing Worksheets

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Microsoft® is a registered trademark of Microsoft Corporation.
  • Windows® is a registered trademark of Microsoft Corporation.

Terms of Use:

None

Copyright © 2004 eLearningDepot.com. All rights reserved.