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 Foundation

Courseware Training Materials

Training Course Outline

Using Excel 2010

The Excel Cell Referencing System
Entering Numbers and Text
Summing a Column of Numbers
Entering a Date
Worksheets and Workbooks
Saving a Workbook
Creating a New Workbook
Opening a Workbook
Switching between Workbooks
Help

Selection Techniques

Selecting a Cell, cell range, row & column.

Manipulating Rows and Columns

Inserting Rows & Columns
Deleting Rows& Columns
Column Widths
Row Heights

Manipulating Cells and Cell Content

Copying a Cell or Range Contents
Deleting Cell Contents
Moving the Contents of a Cell or Range.
Editing Cell Content
Undo and Redo
AutoFill
Sorting
Searching and Replacing

Worksheets

Renaming a Worksheet
Inserting a New Worksheet
Deleting a Worksheet
Copying and moving a Worksheet

Font Formatting

Font Type
Font Size
Bold, Italic, Underline
Cell Border Formatting
Background Colour
Font Colour

Alignment Formatting

Aligning cell contents
Centring a Title Over a Cell Range
Cell Orientation
Text Wrapping
Format Painter

Number Formatting

Decimal Point Display
Comma Style Formatting
Currency Symbol
Date Styles
Percentages

Freezing Row and Column Titles

Freezing Row and Column Titles

Formulas

Creating Formulas
Copying Formulas
Operators
Using Operators In Formulas
Formula Error Messages
Relative Cell Referencing
Absolute Cell Referencing

Functions

Sum Function
Average Function
Max Function
Min Function
Count Function
The Counta Function
The Countblank Function
Using the If Function

Charts

Inserting different chart types.
Resizing and deleting a Chart
Chart Title or Labels
Chart Background Colour
Column, Bar, Line or Pie Slice Colours
Copying and Moving Charts

Customising Excel

Modifying Excel Options
Minimising the Ribbon
Autocorrect Options

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.