Home  | Samples / Prices  | Courses  | What You Get  | About Us  | FAQs  | Contact | ECDL / ICDL

             Cheltenham Courseware

UK Computer Courseware Irish Computer Courseware
Please select your region  
UK/Ireland | USA/Canada | Australia/International 

 

 COMPUTER COURSES

  MS Office 2010
  Courseware
  Word 2010 Foundation
  Word 2010 Intermediate
  Word 2010 Advanced
  Excel 2010 Foundation
  Excel 2010 Intermediate
  Excel 2010 Advanced
  Access 2010 Foundation
  Access 2010 Intermediate
  Access 2010 Advanced
  Outlook 2010 Basics
  PowerPoint 2010 Foundation
  PowerPoint 2010 Intermediate
  PowerPoint 2010 Advanced

  MS Office 2007
  Courseware
   Word 2007 Foundation
  Word 2007 Intermediate
  Word 2007 Advanced
  Excel 2007 Foundation
  Excel 2007 Intermediate
  Excel 2007 Advanced
  Access 2007 Foundation
  Access 2007 Intermediate
  Access 2007 Advanced
   Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
   PowerPoint 2007 Foundation
  PowerPoint 2007 Intermediate
  PowerPoint 2007 Advanced
  Outlook 2007 Basics

   MS Office 2003 
  Courseware
   Word 2003 Foundation
  Word 2003 Intermediate
  Word 2003 Advanced
  Excel 2003 Foundation
  Excel 2003 Intermediate
  Excel 2003 Advanced
  Access 2003 Foundation
  Access 2003 Intermediate
  Access 2003 Advanced
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Foundation
  PowerPoint 2003 Intermediate
  PowerPoint 2003 Advanced
  Outlook 2003 Basics

  LONGER 2 LEVEL 
  COURSES

  MS Office 2010
  Courseware
 
  Word 2010 Basics
  Word 2010 Expert
  Excel 2010 Basics
  Excel 2010 Expert
  Access 2010 Basics
  Access 2010 Expert 
  Outlook 2010 Basics
  PowerPoint 2010 Basics
  PowerPoint 2010 Expert

   MS Office 2007
  Courseware
  Word 2007 Basics
  Word 2007 Expert
  Excel 2007 Basics
  Excel 2007 Expert
  Access 2007 Basics
  Access 2007 Expert
  Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
  PowerPoint 2007 Basics
  PowerPoint 2007 Expert
   Outlook 2007 Basics

   MS Office 2003 
  Courseware
  Word 2003 Basics
  Word 2003 Expert
  Excel 2003 Basics
  Excel 2003 Expert
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Basics
  PowerPoint 2003 Expert

  ICT Courseware
   PC Basics
   Windows XP Basics
  Windows Vista Basics
  Windows 7 Basics
   Internet Explorer 8

SEO Training

Sample IT Training Materials

SEO training

 

Printable and customizable Microsoft Office 2010 Training MaterialsMicrosoft Excel 2010 Intermediate

Computer Courseware Training Materials

Training Course Outline

 Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a Page(s)
  • Printing Titles On Every Page
  • Printing the Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Printing Options

Functions and Formulas

  • Getting Help With Functions.
  • Nested Functions.
  • Consolidating Data using a 3-D Reference Sum Function.
  • Mixed References within Formulas.

Time & Date Functions

  • TODAY.
  • NOW.
  • DAY.
  • MONTH.
  • YEAR.

Mathematical Functions

  • ROUND.
  • ROUNDDOWN.
  • ROUNDUP.

Logical Functions

  • IF.
  • AND.
  • OR.

Mathematical Functions

  • SUMIF.

Statistical Functions

  • COUNT.
  • COUNTA.
  • COUNTIF.
  • COUNTBLANK.
  • RANK.
  • TEXT FUNCTIONS
  • LEFT.
  • RIGHT.
  • MID.
  • TRIM.
  • CONCATENATE.

Financial Functions

  • FV.
  • PV.
  • NPV.
  • RATE.
  • PMT.

Lookup Functions

  • VLOOKUP.
  • HLOOKUP.

Database Functions

  • DSUM.
  • DMIN.
  • DMAX.
  • DCOUNT.
  • DAVERAGE

Named Ranges

  • Naming Cell Ranges.
  • Removing a Named Range.
  • Named Cell Ranges and Functions.

Cell Formatting

  • Applying Styles to a Range.
  • Conditional Formatting.
  • Custom Number Formats.

Manipulating Worksheets

  • Copying or Moving Worksheets
  • Splitting a Window.
  • Hiding Rows, Columns & Worksheets.

Templates

  • Creating Excel Templates.
  • Editing Excel Templates

Paste Special Options.

  • Using Paste Special to Add, Subtract, Multiply & Divide.
  • Using Paste Special ‘Values’.
  • Using Paste Special Transpose Option.

Other Microsoft Office 2010 training courses

 		  

UK coursework   USA coursework Canada Australia coursework International Computer coursework  Privacy Policy       SEO Training
© 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions 
Course content subject to change without notice. Cheltenham Group | HTML Formatted Sample
Microsoft Word - Microsoft Excel - Microsoft Access - Microsoft PowerPoint - Microsoft Windows | Prices & Ordering | Computer Courseware Samples | FAQs | Cheltenham Group | About Us | Contact Us |  ECDL UK Instructor-led Courseware  |  ECDL / ICDL International Courseware | Site Map | Home Page |  Perth SEO | 
SEO training Perth

            Computer Training resources for IT trainers inc Microsoft Office 2010

  Customisable Courseware
  No Annual Renewal Fees
  Unlimited Number of Users
  Unlimited Reprinting Rights
  PLUS Intranet Versions


Please select your region  
 UK/Ireland | USA/Canada | Australia/International 

   Computer Training Courseware for IT Teaching Professionals
    Quality courseware materials for tutor-led computer training:  
    For schools, colleges, IT trainers, corporate training departments, & computer training companies. SEO Perth Training Video