Computer Training Materials

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

Region |
UK/Ireland | USA/Canada Australia/International

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

Training Courses

Microsoft Office 2010
Word 2010 Foundation
Word 2010 Intermediate
Word 2010 Advanced
Word 2010 Basics
Word 2010 Expert
Excel 2010 Foundation
Excel 2010 Intermediate
Excel 2010 Advanced
Excel 2010 Expert
Excel 2010 Basics
PowerPoint 2010 Foundation
PowerPoint 2010 Intermediate
PowerPoint 2010 Advanced
PowerPoint 2010 Basics
PowerPoint 2010 Expert
Access 2010 Foundation
Access 2010 Intermediate
Access 2010 Advanced
Access 2010 Basics
Access 2010 Expert
Outlook 2010 Basics

Microsoft Office 2007
Word 2007 Foundation
Word 2007 Intermediate
Word 2007 Advanced
Word 2007 Basics
Word 2007 Expert
Excel 2007 Foundation
Excel 2007 Intermediate
Excel 2007 Advanced
Excel 2007 Basics
Excel 2007 Expert
PowerPoint 2007 Foundation
PowerPoint 2007 Intermediate
PowerPoint 2007 Advanced
PowerPoint 2007 Basics
PowerPoint 2007 Expert
Access 2007 Foundation
Access 2007 Intermediate
Access 2007 Advanced
Access 2007 Basics
Access 2007 Expert
Outlook 2007 Basics

Microsoft Office 2003
Word 2003 Foundation
Word 2003 Intermediate
Word 2003 Advanced
Word 2003 Basics
Word 2003 Expert
Excel 2003 Foundation
Excel 2003 Intermediate
Excel 2003 Advanced
Excel 2003 Basics
Excel 2003 Expert
PowerPoint 2003 Foundation
PowerPoint 2003 Intermediate
PowerPoint 2003 Advanced
PowerPoint 2003 Basics
PowerPoint 2003 Expert
Access 2003 Foundation
Access 2003 Intermediate
Access 2003 Advanced
Access 2003 Basics
Access 2003 Expert
Outlook 2003 Basics

ECDL / ICDL COURSEWARE
UK/ BCS ECDL
International ECDL/ ICDL

ICT/WINDOWS COURSEWARE
PC Basics
Internet Explorer 8
Windows XP Basics
Windows Vista Basics
Windows 7 Basics

SEO Training Courses

Microsoft Excel 2010 Advanced

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

  Privacy Policy Terms & Conditions
© 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged.
Course content subject to change without notice. 100% Australian owned company.
HTML Formatted Sample      Microsoft Word - Microsoft Excel - Microsoft PowerPoint - Microsoft Access
Microsoft Windows |Prices / Ordering | SAMPLES | FAQs | Clients | What's New | Company Profile
Contact Us | ECDL / ICDL Courseware | Site Map | Home Page |
SEO Services Perth Australia | SEO training seminars, Perth, WA | SEO Perth Video |

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