The Knowledge Network
1510 Central Avenue
Albany, NY 12205
Phone (518)452-2675
Fax: (518)452-2872
Office Hours:
Mon-Fri 9:00am-6:00pm
learn@knowledgenetwork.org

 

Excel 2003 - Level 1

Location: Latham

Navigate the Excel environment, create a new worksheet, enter and edit data, add functions, format, create a chart, and print.

Recommended Preparation: Welcome to Windows XP , Welcome to Windows Vista or equivalent experience.

Lesson 1: Getting started

  • Spreadsheet terminology
  • Exploring the Excel window
  • Getting help
  • Opening and navigating workbooks
  • Closing workbooks

Lesson 2: Entering and editing data

  • Creating workbooks
  • Entering and editing labels and values
  • Entering and editing formulas
  • Saving and updating workbooks

Lesson 3: Modifying a worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Using absolute references
  • Inserting and deleting range

Lesson 4: Using functions

  • Entering functions
  • Using AutoSum
  • Using AVERAGE, MIN, and MAX
 

Lesson 5: Formatting worksheets

  • Formatting text
  • Formatting rows and columns
  • Number formatting
  • Using Format Painter and AutoFormat

Lesson 6: Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Lesson 7: Creating charts

  • Chart basics
  • Modifying charts
  • Printing charts

Optional Topic: Web features

  • Saving workbooks as Web pages
  • Hyperlinks
  • Sending workbooks via e-mail
Course Fee: $169 Members: $159

Upcoming Class Schedules
# 2626 Thur Apr 29 8:30am-4:30pm
# 2786 Wed May 12 8:30am-4:30pm