Single Courses
 
Contact Us

  • Address :
  • 123 King Street
    Hammersmith
    W6 9JG

  • Contact No. :
  • 0800 232 1806
    0208 455 9585

ECDL v4: Module 4 Spreadsheets

Aims and Objectives

To enable students to take the ECDL Spreadsheets modular test

Know how to use Excel in order to sit the ECDL modular test

The flexibility and value of self-study course designed to enable you to work at your own pace

A personalised workbook to use as a reference guide on completion of the course

The opportunity to gain the widely recognised Pitman Training Certificate

Target Audience

Those who wish to learn how to use this popular spreadsheet program to the ECDL syllabus

Prerequisites

Knowledge of Windows and using a mouse

Course Content

Chapter 1: Introduction to Spreadsheets - First Steps with Spreadsheets, Opening Excel, Examining Excel, Saving an Excel File, Closing Excel, Opening Multiple Excel Files, Switching Between Worksheets, Obtaining Help

Chapter 2: Data Entry - Inserting Data, Editing Cell Data, Saving with a Different Name, Inserting Row and Columns, Date and Time Format, Selecting Data, Delete, Undo and Redo, Autofill, Cell Formats, Changing Column Widths, Changing Row Heights

Chapter 3: Data Organisation – Worksheet Organisation, Renaming Worksheets, Copy, Cut and Paste, Sorting Data

Chapter 4: Configuring Excel – Magnification, Customising the Toolbar, Splitting and Freezing Windows, Preferences

Chapter 5: Manipulating Data - Basic Calculations, Cell Referencing, Functions, Using References between Worksheets, Logical Functions, Function Errors, Find and Replace, Spell Checker

Chapter 6: Formatting - Font Type and Size, Font Effects, Adding Colour, Copying Formatting, Content Alignment, Adding Borders

Chapter 7: Charts - Creating a Column Chart, Creating a Bar Chart and Changing Chart Type, Creating a Pie Chart, Creating a Line Chart, Changing Colours, Editing/Deleting Chart Text, Resizing Charts, Deleting Charts, Moving Charts

Chapter 8: Workbook Presentation and Printing – Print Preview, Margins, Page Orientation and Size, Page Scaling, Setting the Print Area, Headers and Footers, Output Preparation, Save As, Printing

Course Duration: 20 hours

Course Code: 1010190740