You are viewing our UK computer training courseware site    

Cheltenham Courseware | Training materials for IT trainers, schools & ICDL / ECDL training


  Training Materials 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 materials PowerPoint XP
  Microsoft Access 2007  Microsoft Access
  Internet Explorer 7 Internet Explorer
  Microsoft Outlook 2007  Outlook
  Expression Web
  Microsoft Project Microsoft Project
  Microsoft Publisher Microsoft Publisher
  Microsoft FrontPage Microsoft FrontPage
  Microsoft Visio Microsoft Visio
  Computer Concepts

  ECDL and ICDL - European Computer Driving Licence ECDL / ICDL Downloads
     
      PLUS MANY MORE ...

 Download Computer Training Sample Courses
Complementary computer training materials.
About Cheltenham Courseware
ECDL & ICDL Courseware Materials
 All these cousres are contained within the IT Courseware Library
Price List
Educational Discounts
 Call us
Clients

ECDL Foundation Approved
ECDL ICDL practice quiz revision questions

Microsoft Excel 5
Intermediate Level Training Course

Courseware Training Manual

1. Worksheets, a further look

  • Renaming worksheets
  • Deleting and inserting worksheets
  • Finding files
  • Displaying other toolbars
  • Managing 'child Windows' within Excel
  • Freeze panes
  • The series command

2. Formatting, further techniques

  • Using cell formats as styles
  • Using colors in Excel
  • Using colors based on values
  • Gridlines
  • Hiding data and re-displaying data
  • Hiding other screen elements

3. Further functions

  • What are functions?
  • The if( ) function
  • Data validation functions
  • The hlookup / vlookup function
  • A sample hlookup
  • The choose function
  • Entering a choose function
  • The date functions
  • Date math
  • The time function
  • Functions for text manipulation
  • Calculating worksheets

4. Database and list management

  • What is a database?
  • Excel databases
  • Database terminology
  • Creating, editing and navigating a database
  • Sorting an internal Excel database
  • What is autofilter?
  • Filtering data
  • Totaling and manipulating filtered data
  • Creating subtotals
  • Using dataforms
  • The Excel data form

5. Manipulating and customizing charts

  • Manipulating charts
  • Formatting charts
  • Creating and formatting 3-d charts
  • Customizing chart series
  • Customizing the plot area, walls, and chart area
  • Customizing chart axes
  • Customizing chart titles
  • Customizing chart legends

6. Drawing and pictures

  • Drawing lines, boxes, ovals and arcs
  • Drawing freeform shapes
  • Creating text boxes
  • Pictures
  • Bring to front/send to back
  • Grouping and un-grouping objects
  • Changing the appearance of objects

7. Excel and other applications

  • Using the conversion feature
  • Cut, copy and paste - using the clipboard
  • Using paste special
  • OLE - embedding vs. linking
  • Inserting embedded objects
  • Linking data from other worksheets
  • Linking data from Word
  • Linking data to Word

   Home | Download Computer Courseware Samples | IT Course Outlines | ECDL / ICDL Courseware | Site Map | FAQs 
    What's New | Download Sample ECDL / ICDL Training Materials | Newsletter | Contact Us | About Us

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

 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  duplication rights for all 150+ computer training courses when you invest in the 'Courseware Library'