INFORMIT logo
InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
ABOUT
  Windows Essentials  
  SQL Server Administrator  
  Windows Server 2003  
   
  Office Power User  
  Office Specialist  
  MICROSOFT CERTIFICATION  
  MICROSOFT TRAINING & CERT.  
     
   
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
Microsoft Excel 2003 / XP Fundamental
The course provides a comprehensive introduction to Microsoft Excel. This beginning spreadsheet class will cover: getting started with Excel, entering and editing data, modifying a worksheet, formatting worksheets, working with charts, and printing.
 
 
Course schedule

Duration: 2 days.
To view the schedule for this class, click here.

Who should attend

    This course is intended for all IT Professionals who want to learn the Excel XP or 2003.

Prerequisites

No previous knowledge of Microsoft Excel is required. You should be familiar with the Windows operating system.

Course Outline

Getting started

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

  • Creating workbooks
  • Entering and editing labels and values
  • Entering and editing formulas
  • Saving and updating workbooks
  • Modifying a worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Using absolute references
  • Inserting and deleting ranges
  • Using functions

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

  • Formatting text
  • Formatting rows and columns
  • Formatting numbers
  • Using Format Painter and AutoFormat
  • Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets
  • Creating charts

  • Chart basics
  • Modifying charts
  • Printing charts
  • Web features

  • Saving workbooks as Web pages
  • Hyperlinks
  • Sending workbooks via e-mail
  •  
     
     

     
     


    INFORMIT - Skill Development Center
    Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
    Fax. (022) 4231 168 - E-mail: info@informit.tc

     
      Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
    © 2006, InformIT Ganesa Pratama. All Right Reserved