Select your region:   Australia | UK | UNESCO | Malta | Egypt | Jamaica | South Africa

 ECDL / ICDL
Courseware Training Materials

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

Main Site Home Page                                                
ECDL / ICDL Courseware materials & resources for use at your IT training center
 

ECDL / ICDL Training Courseware Outline
ECDL Courseware Training Materials - ECDL 5 and ECDL Advanced ECDL / ICDL Syllabus Five - Module 4 
Using Microsoft Excel 

Approved Courseware Training Resources


A FIRST LOOK AT EXCEL

  • Starting the Excel program

  • What is the Active Cell?

  • The Excel cell referencing system

  • Entering numbers and text

  • Default text and number alignment

  • Adding a column of numbers

  • Worksheets and Workbooks

  • Saving a workbook

  • Closing a workbook

  • Creating a new workbook

  • Opening a workbook

  • Switching between workbooks

  • Saving a workbook using another name

  • Saving a workbook using a different file type

HELP

  • Getting help

  • Searching for Help

  • The Help 'Table of Contents'

  • Printing a Help topic

  • Alt key help

SELECTION TECHNIQUES

  • Why are selection techniques important?

  • Selecting a cell

  • Selecting a range of connecting cells

  • Selecting a range of non-connecting cells

  • Selecting the entire worksheet

  • Selecting a row

  • Selecting a range of connecting rows

  • Selecting a range of non-connected rows

  • Selecting a column

  • Selecting a range of connecting columns

  • Selecting a range of non-connecting columns

  • Good practice when creating of editing lists

MANIPULATING ROWS AND COLUMNS

  • Inserting rows into a worksheet

  • Inserting columns into a worksheet

  • Deleting rows within a worksheet

  • Deleting columns within a worksheet

  • Modifying column widths

  • Modifying column widths using 'drag and drop'

  • Automatically resizing the column width to fit contents

  • Modifying row heights

COPYING, MOVING AND DELETING

  • Copying a cell or range contents within a workbook.

  • Deleting cell contents

  • Moving the contents of a cell or range within a workbook

  • Editing cell content

  • Undo and Redo

  • Copying the contents of a cell or range between worksheets (within the same workbook)

  • Moving the contents of a cell or range between worksheets (within the same workbook)

  • Moving the contents of a cell or range between worksheets (in different workbooks)

  • Copying the contents of a cell or range between worksheets (in different workbooks)

  • AutoFill

  • Sorting a cell range

SEARCHING

  • Searching and replacing data

MANIPULATING WORKSHEETS

  • Switching between worksheets

  • Renaming a worksheet

  • Good practice with naming worksheets

  • Inserting a new worksheet

  • Deleting a worksheet

  • Copying a worksheet within a workbook

  • Moving a worksheet within a workbook

  • Copying or moving worksheets between workbooks

FONT FORMATTING

  • Font type

  • Font size

  • Bold, italic, underline formatting

  • Cell border formatting

  • Formatting the background colour

  • Formatting the font colour

ALIGNMENT FORMATTING

  • Aligning contents in a cell range

  • Centering a title over a cell range

  • Cell orientation

  • Text wrapping

  • Format painter

NUMBER FORMATTING

  • Number formats

  • Decimal point display

  • Applying and removing comma style formatting (to indicate thousands)

  • Currency symbol

  • Date styles

  • Percentages

  • Applying Percentage formatting to a cell or range

FREEZING ROW AND COLUMN TITLES

  • Techniques for freezing row and column titles

FORMULAS

  • Creating formulas

  • Good Practice: The easy way to create formulas

  • Copying formulas

  • Operators

  • Formula error messages

RELATIVE & ABSOLUTE CELL REFERENCING

  • Relative cell referencing within formulas

  • Absolute cell referencing within formulas

FUNCTIONS

  • What is a function?

  • Common functions

  • Sum function

  • Average function

  • Max function

  • Min function

  • Count function

  • The COUNTA function

  • The COUNTBLANK function

  • What are 'IF functions'?

  • Using the IF function

USING CHARTS

  • Inserting a column chart

  • Inserting a line chart

  • Inserting a bar chart

  • Inserting a pie chart

  • Resizing a chart

  • Deleting a chart

  • Chart title or labels

  • Chart background colour

  • Changing the column, bar, line or pie slice colours in a chart

  • Modifying the legend fill colour

  • Changing the chart type

  • Modifying charts using the Layout tab

  • Copying and moving charts within a worksheet

  • Copying and moving charts between worksheets

  • Copying and moving charts between workbooks

CUSTOMISING EXCEL

  • Modifying basic Excel options

  • Minimising the Ribbon

  • AutoCorrect options

WORKSHEET SETUP

  • Worksheet margins

  • Worksheet orientation

  • Worksheet page size

  • Headers and footers

  • Header and footer fields

  • Scaling your worksheet to fit a page(s)

PREPARING TO PRINT A WORKSHEET

  • Visually check your calculations

  • Displaying gridlines when printing

  • Printing titles on every page when printing

  • Printing the Excel row and column headings

  • Spell checking

  • Previewing a worksheet

  • Comparing workbooks side by side

  • Zooming the view

  • Printing options

    


ECDL | European Computer Driving Licence
ICDL | International Computer Driving Licence


Other ECDL / ICDL Courseware Training materials

 


 HomeECDL / ICDL 5 Courseware Samples | Site Map |  ECDL 5.0 | ECDL Advanced 2.0
  ECDL Modules
 |  What's New | Download Sample ECDL / ICDL Training Materials / Workbooks |
  NewsletterContact UsAbout Us |  ECDL Courses | 
   Microsoft Office 2010 Courseware Training Materials for Computer Trainers

UK ECDL 5 Irish ECDL 5 training resourses  USA Canada ECDL 5.0 for Australia International ICDL Materials for ITC  trainers  Privacy Policy   Terms & Conditions
© 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. 
Course content subject to change without notice. 100% Australian owned training company
ECDL Coursebooks for ICT Teachers covering all ECDL ModulesWebsite SEO Perth - Internet Marketing by http://www.websiteseoaustralia.com.au
     More about Cheltenham Courseware ...       Get Acrobat Reader

Download Computer Training Sample Courses

Contact Cheltenham Courseware

   ECDL & ICDL courseware training materials & resources:  
   Editable manuals for schools, colleges, IT trainers & computer training companies.

ECDL 5 and ICDL 5.0 Educational training materials for schools, colleges, universities & ITC training companies