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

Microsoft Excel 2007 training materials inc. Office 2007 courseware  


FUNCTIONS

  • Excel 2007 Functions
  • Getting help about using a particular function
  • TODAY
  • DAY
  • MONTH
  • YEAR
  • SUMIF
  • ROUND
  • COUNT
  • COUNTA
  • COUNTIF
  • PROPER
  • UPPER
  • LOWER
  • CONCATENATE
  • FV
  • NPV
  • PMT
  • PV
  • RATE
  • HLOOKUP
  • VLOOKUP
  • IF
  • AND
  • OR
  • ISERROR
  • DSUM
  • DMIN
  • DMAX
  • DCOUNT
  • Nested functions

USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES

  • Using a one input Data Table command
  • Using a two input data table command

A FIRST LOOK AT PIVOT TABLES

  • Creating a PivotTable
  • Dropping data into the Pivot Table
  • Modifying data and refreshing the Pivot Table
  • Grouping data within a Pivot table

SCENARIOS

  • Scenario Manager - an example
  • Showing a scenario
  • Viewing an alternative scenario
  • Create a scenario summary

AUDITING

  • Tracing precedent cells
  • Tracing the dependants of a cell
  • Displaying all formulas within a worksheet
  • Adding comments
  • Displaying comments
  • Removing comments
  • Editing comments

MACROS

  • Displaying the Developer tab
  • Recording and running macros
  • Lowering your macro security level
  • Customizing the Quick Access Toolbar
  • Changing the Quick Toolbar Macro icon
  • Removing a macro icon from the quick access toolbar
  • Raising your macro security level

Excel courseware training materials


Other 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'