Now viewing our Australian / International computer courseware site  

 
Computer Courseware Sample Course Downloads for IT Trainers

Flexibility: An entire library of class room ready computer courseware titles designed for tutor-led training. Print manuals on demand when you need them.

Quality & Value: Exceptional quality computer courseware for a low cost one-off investment with no annual licensing fees. No limit on numbers taught. No time limit on using the materials.

Customizable: Supplied in editable Microsoft Office format. Add your own name and logos.

   

 Home 

  IT Courseware Library 

 ECDL / ICDL

  Budget Courseware

  Prices / Ordering 

 About Us

  Members Area

 

 IT Courseware for:

  Microsoft Windows Vista  Windows Vista 
  Microsoft Windows XP  Windows 2000 / XP
  Microsoft Word 2007  Microsoft Word
  Microsoft Excel 2007  Microsoft Excel
  PowerPoint 2007 Courseware PowerPoint
  Microsoft Access 2007  Microsoft Access
  Internet Explorer 7 Internet Explorer
  Microsoft Outlook 2007  Outlook
  Microsoft Project Microsoft Project
  Microsoft Publisher Microsoft Publisher
  Microsoft FrontPage Microsoft FrontPage
  Microsoft Visio Courseware Materials Microsoft Visio
  Expression Web
  Computer Concepts
  ECDL and ICDL - European Computer Driving Licence
ECDL / ICDL

        PLUS MANY MORE ...

 

Microsoft Excel 2000 Courseware Training Materials
Advanced Level Course

Microsoft Excel training materials inc. Office 2007 courseware   Courseware Training Manual


1. TEMPLATES AND STYLES

  • WHAT ARE TEMPLATES?
  • CREATING TEMPLATES
  • USING TEMPLATES
  • WHAT ARE STYLES?
  • CREATING AND USING STYLES

2. IMPORTING DATA

  • WHY IMPORT DATA?
  • THE TEXT WIZARD
  • IMPORTING FROM A DATABASE
  • DATABASE TERMINOLOGY
  • USING MICROSOFT QUERY

3. 'WHAT IF' UTILITIES

  • EXCEL 'WHAT IF?' TYPE UTILITIES
  • GOAL SEEK
  • GRAPHICAL GOAL SEEKING
  • SCENARIO MANAGER
  • SOLVER
  • SOLVER TERMINOLOGY
  • SOLVER - AN EXAMPLE

4. MACROS AND CUSTOM CONTROLS

  • WHAT ARE MACROS?
  • TO RECORD A MACRO
  • RUNNING MACROS
  • CREATING A BUTTON IN A WORKSHEET AND ASSIGNING A MACRO TO IT
  • ATTACHING MACROS TO A BUTTON
  • DRAWING, EDITING AND FORMATTING BUTTONS

5. CUSTOMIZING EXCEL

  • CUSTOMIZING EXCEL 2000 - OPTIONS
  • CUSTOMIZING TOOLBARS

6. SECURITY AND PROOFING WITHIN EXCEL

  • AUDITING AND SECURITY FEATURES WITHIN EXCEL 2000
  • THE SPELL CHECKER
  • WHAT ARE SHARED WORKBOOKS?
  • ADVANCED WORKBOOK SHARING OPTIONS
  • DATA VALIDATION
  • WORKBOOK PASSWORD PROTECTION
  • WORKBOOK PROTECTION
  • WORKSHEET PROTECTION
  • CELL PROTECTION
  • EXCEL 2000 AUDITING TOOLS
  • AUDITING WORKSHEETS
  • CELL COMMENTS

7. DATA MAPS

  • WHAT ARE DATA MAPS?
  • THE DATA MAP CONTROL DIALOG BOX
  • PLACING DATA ON A MAP
  • FORMATTING A DATA MAP

8. CONSOLIDATION

  • WHAT IS CONSOLIDATION?
  • CONSOLIDATING ROWS AND COLUMNS

Microsost Excel  Courseware


Other Microsoft Office 2000 Courseware materials

 


    Home | Download Computer Courseware Samples | IT Course Outlines | ECDL / ICDL Courseware | Site Map | FAQs 
    New & Upcoming Courses | Download Sample ECDL / ICDL Training Materials | NewsletterContact UsAbout Us

    USA Canada UK Ireland Australia International  
   © 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged.  Terms & Conditions
   Course content subject to change without notice.

  
More about Cheltenham Courseware ...

Now download complete samples of all our courses
Download Computer Training Sample Courses
    
    Consider the benefits of investing in quality computer courseware materials:  
    For schools, colleges, professional IT trainers & computer training companies

   
You get  the duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'