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 2007 - Level 1

Location: Latham

Explore the Excel environment, create and modify worksheets, enter formulas and functions, format worksheets, create charts, 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
  • Navigating workbooks

Lesson 2: Entering and editing data

  • Entering and editing text and values
  • Entering and editing formulas
  • Working with pictures
  • Saving and updating workbooks

Lesson 3: Modifying a worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Absolute and relative references
  • Inserting and deleting ranges

Lesson 4: Using functions

  • Entering functions
  • AutoSum
  • Other useful functions
 

Lesson 5: Formatting worksheets

  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Conditional formatting
  • Copying formats and applying table formats

Lesson 6: Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Lesson 7: Creating charts

  • Chart basics
  • Modifying charts
  • Printing charts

Lesson 8: Managing large workbooks

  • Viewing large worksheets
  • Printing large worksheets
  • Using multiple worksheets
Course Fee: $169 Members: $159

Upcoming Class Schedules
# 2624 Thur Apr 1 8:30am-4:30pm
# 2779 Mon May 3 8:30am-4:30pm