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 95 Courseware Materials
Advanced Level Training Course

   Courseware Training Manual


1. Templates and styles

  • What are templates?
  • Creating templates
  • What are styles?
  • Creating and using styles

2. Importing data

  • Why import data?
  • The text wizard
  • From text to spreadsheet
  • Importing from a database
  • Microsoft query
  • Database terminology
  • Starting Microsoft query
  • Adding fields to query
  • Completing the query

3. 'What if' Utilities

  • Excel 'what if?' type utilities
  • Goal seek
  • Graphical goal seeking
  • Scenario manager
  • Solver
  • Before solver
  • After solver

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. Pivot tables

  • What is a pivot table?
  • A sample pivot table
  • To create a pivot table
  • Rearranging a pivot table
  • Pivot and query toolbar

6. Customizing Excel

  • Customizing Excel 95 - options
  • Customizing toolbars
  • Hiding other screen elements

7. Security and proofing within Excel

  • Auditing and security features within Excel
  • Spelling checker
  • Workbook password protection
  • Workbook protection
  • Worksheet protection
  • Cell protection
  • Object protection
  • Excel 95 auditing tools
  • Auditing worksheets
  • Using tracers
  • Cell notes and documentation
  • The info window

8. Miscellaneous advanced features

  • Grouping and ungrouping worksheets
  • Fractions
  • What is consolidation?
  • Consolidating rows and columns
  • Data maps
  • The data map control dialog box
  • Placing data on a map
  • Formatting a data map


Microsoft Office 2007 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'