it-training.com
Home My Basket My Account
 
Currency

 
Username
Password
Forgot password
Text Only | Login Help
How the courses work
Try a free course
Other Courses
Search Courses Certification Corporate About Us Contact
Learn to do more for less!
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.

 Microsoft Office
PowerPoint
Excel
Outlook
Word
Access
Project
Visio
 ECDL / ICDL
 Microsoft Technical
Microsoft Certification
Windows 2000
 Web Development
Beginner
Web Tools
Design and Graphics
Advanced
Java
 CompTIA
 Cisco
CCDA
Cisco CCNA
Cisco CCNP
 Oracle
 SAP
 Programming
 Technical
 Business and Management Skills
 Other Courses
 Public Seminars