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

Microsoft Excel 2007 - Level 1

Location: Colonie

Overview: Discover the practical applications of spreadsheets, understand the types of problems they can solve, and develop basics skills by using the software hands-on.

• Excel Basics
  • The Paper Spreadsheet
  • The Excel Program
  • The Workbook Environment
     
• Entering Data and Navigating in a Worksheet
  • Entering and Correcting Data
  • Saving a File
  • Using Formulas
  • Opening a Second File
  • Navigation and Movement Techniques
     
• Modifying a Workbook
  • Working with Ranges
  • Working with Functions
  • Editing Cell Contents
     
• Moving and Copying Data
  • Inserting Rows and Ranges
  • Moving Data
  • Copying Data
  • Absolute References
  • Using the Fill Series Feature
     
• Formatting a Worksheet
  • Formatting a Worksheet
  • Number Formats and Text Alignment
  • Copying and Pasting Formats
  • Special and Custom Formatting
     
• Printing a Worksheet
  • Checking Spelling
  • Using the Print Preview Command
  • Printing a Large Worksheet
  • Additional Print Options
     
• Introduction to the Workbook Environment
  • Using a Multiple-Sheet Workbook
  • Creating a Chart
  • Outlining Spreadsheet Solutions
     
• Creating Excel Web Pages
  • Using Excel as a Web Tool