Excel 2003 - Charts and Databases


Summary:

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

 

This lesson is part of our Excel 2003 online training series which contains 26 hours of self-paced courseware. Our web-based training provides 1 year of unlimited access.


Objectives:

After completing this course you 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

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


Prerequisites: None:


Technical Requirements:

  • Internet connection
  • Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 45. We have been providing web based training for the past 8 years.