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 Advanced

This advanced spreadsheet course will learn to use advanced features of Microsoft Excel such as using multiple worksheets and workbooks, create advanced charts, template, documenting and auditing, advance formatting, and work with large worksheets.

 
 
Course schedule

Duration: 1 day.
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

Experience in Microsoft Excel XP / 2003 Fundamental.

Course Outline

Working with large worksheets

  • Viewing options
  • Hiding, displaying, and outlining data
  • Printing large worksheets
  • Using multiple worksheets and workbooks

  • Using multiple worksheets
  • Linking worksheets by using 3-D formulas
  • Consolidating data
  • Linking workbooks
  • Managing workbooks
  • Customizing Excel

  • Using the Options dialog box
  • Customizing toolbars and menus
  • Advanced formatting

  • Borders and shading
  • Using special number formats
  • Working with dates
  • Working with styles
  • Other advanced formatting
  • List management

  • Examining lists
  • Sorting and filtering lists
  • Advanced filtering
  • Advanced charting

  • Chart formatting options
  • Using combination charts
  • Using graphic elements
  • Documenting and auditing

  • Auditing features
  • Comments and text boxes
  • Protection
  • Workgroup collaboration
  • Using templates

  • Built-in templates
  • Creating and managing templates
  •  
     
     

     
     


    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