Computer Courseware Sample Course Downloads for IT Trainers

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 training materials for trainers

Microsoft Excel 2007 Advanced Level Courseware 
Training materials for Office 2007

Microsoft Excel 2007 training materials inc. Office 2007 courseware

Training Course Outline.

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