Virginia Commonwealth University

Training

Title: Excel 2003 - Beginning
Date/Time: 11/6/2009  9:00am [Cabell] - 12:00pm

Presenter: Shirley Mitteldorfer, Technology Services
Registration: Class is full. To be added to the waiting list, please contact Technology Services.
Prerequisites: Computer basics such as using a mouse, navigating, and managing electronic files and folders
Building: Cabell Library   320
Cost: $0  

Sponsor: Technology Services
Audience: VCU Students, Faculty and Staff Only

Category: Computer Basics, Microsoft Office, Spreadsheets
Description: This course covers the basics of using Excel 2003 in the office and teaching environments. Excel is a spreadsheet program that is able to calculate and analyze numerical data. Collected data displays graphically with a chart/graph or in table format. Basic terms and how they apply to the Excel environment provide an understanding of how Excel works.

Learning Objectives:
  • Describe a spreadsheet and suggest several potential applications
  • Create, manage, save, and open a spreadsheet
  • Explain how the toolbars are displayed, hidden, and arranged
  • Differentiate between a pull-down menu, a shortcut menu, and a toolbar
  • Type, copy, manage text, and numeric values in columns and rows
  • Resize, add, move, and delete columns and rows
  • Enter a series of numbers, dates, and data across a range
  • Change page orientation, set print titles and print range
  • Format spreadsheet using autoFormat
  • Display date and dollar amounts using different formats
  • Use Spell Check
  • Distinguish between a constant, formula, and function
  • Discuss the order of operations
  • Enter a formula to calculate numeric values
  • Use the fill handle to copy formulas across columns and rows
  • Understand the difference between absolute, relative, and mixed cell addressing
  • Enter a function to average and sum numeric values
  • Print a worksheet two ways (displaying the computed values or the cell formulas)
  • Create charts/graphs using Excel`s Chart Wizard
Other Resources:

Contact: Technology Services
(804) 828-8088
ts-courses@vcu.edu