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 Advanced

Computer Courseware Training Materials

Training Course Outline

 Pivot Tables

  • Using a Pivot Table.
  • Filtering and Sorting Data
  • Grouping Data

Input Tables

  • One-Input Data Tables.
  • Two-Input Data Tables.

Charts

  • Combined Line and Column Chart.
  • Adding a Secondary Axis.
  • Changing the Chart Type For a Data Series.
  • Adding a Data Series to a Chart.
  • Removing a Data Series from a Chart.
  • Modifying the Chart Title, Legend & Data Labels.
  • Chart Axis Scales.
  • Inserting Images Into Chart Columns.
  • Formatting the Chart Area

Hyperlinks

  • Inserting a Hyperlink.
  • Editing a Hyperlink
  • Removing a Hyperlink

Linking & Embedding

  • Linking Data within a Worksheet.
  • Linking Cells between Worksheets within a Workbook.
  • Linking Data between Workbooks.
  • Linking Data from Excel to a Word Document.
  • Linking an Excel Chart to a Word Document.
  • Updating, Locking and Breaking Links.

Importing Text Files

  • Importing a Delimited Text File.

Sorting and Filtering Data

  • Sorting Data by Multiple Columns
  • Custom Sorts
  • Customized List 
  • AutoFilter.
  • Top 10 AutoFilter.
  • Advanced Filter Criteria.
  • Sub-Totalling.
  • Removing Subtotals.
  • Expanding and Collapsing Outline Detail.

Tracking and Reviewing Changes

  • Enabling or Disabling 'Track Changes'.
  • Sharing, Comparing and Merging Worksheets.

Scenarios

  • Scenario Manager.
  • Scenario Summary Reports.

Validating

  • Whole Number.
  • Decimal Number.
  • List.
  • Date.
  • Time.
  • Text Length.
  • Validation Input Message and Error Alert.
  • Removing Data Validation.

Auditing

  • Tracing Precedent Cells.
  • Tracing Dependent Cells.
  • Identifying Cells With Missing Dependents.
  • Showing All Formulas In a Worksheet.
  • Comments..

Macros

  • Using Macros
  • Assigning a Macro to a Button on the Quick Access Toolbar.
  • Deleting Macros.

Passwords & Security Issues

  • Password Protection.
  • Password Protecting Cells and Worksheets.
  • Hiding Formulas.
  • Un-Hiding Formulas.

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