Now viewing our Australian / International computer courseware site  

 

Quality & Value: Exceptional quality computer courseware for a low cost,  one-off investment. No annual licensing fees. No limit on numbers taught. 

Flexibility: An entire library of computer courseware titles. Print manuals on demand when you need them. Add your own name and logos. Supplied in editable MS Word format.
   
   

 

ECDL 5 / ICDL 5 Courseware

 

Microsoft Excel 97 Courseware
Advanced Level Training Course

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

  • What is a pivot table?
  • A sample pivot table
  • To create a pivot table
  • Pivot Table toolbar

6. Customizing Excel

  • Customizing Excel 97 - options
  • Customizing toolbars

7. Security and proofing within Excel

  • Auditing and security features within Excel 97
  • The spell checker
  • What are shared workbooks?
  • Advanced workbook sharing options
  • Data validation
  • Workbook password protection
  • Workbook protection
  • Worksheet protection
  • Cell protection
  • Excel 97 auditing tools
  • Auditing worksheets
  • Cell comments

8. Data maps

  • What are data maps?
  • The data map control dialog box
  • Placing data on a map
  • Formatting a data map

9. Consolidation

  • What is consolidation?
  • Consolidating rows and columns

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 | Newsletter | Contact Us | About 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 ...      Get Acrobat Reader

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'