Excel 2007 Series: Creating a Worksheet
Product Code: 07ex02 Time: 3.0 hour(s) CEUs: Available

Summary:

This course provides information about entering text, values and formulas into worksheet cells in Microsoft Excel 2007. It also provides information about calculating formulas and using built-in functions, like AutoComplete, AutoFill, Insert Function, and AutoSum.

Objectives:

  • Enter text, values, and formulas into a worksheet
  • Use several built-in functions, like AutoComplete, AutoFill, Insert Function, and AutoSum
  • Identify the default order of operations used to calculate formulas
  • Identify different data types used in the application


Topics:

  • Entering text data
  • Entering values
  • Entering formulas
  • Correcting errors
  • Using AutoComplete, AutoFill, and Formula AutoComplete
  • Using the SUM function and AutoSum
  • Editing cells

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.



Copyright © 2008. All rights reserved.