Module 4 - Spreadsheets

Aims and Objectives
To enable students to take the ECDL Spreadsheets modular test.
Know how to use Excel 2000 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 Audiences
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
Module 1: Introduction to Spreadsheets - First Steps with Spreadsheets, Opening Excel, Office Assistant, Examining Excel, Task Pane, Title Bar and Windows Controls, Menu Bar, Tool Bar, Status bar, Saving an Excel File, Closing Excel, Opening Multiple Excel Files, Switching Between Worksheets, Obtaining Help.

Module 2: Data Entry - Inserting Data, Opening the Previously Saved Excel File, Entering Text into Cells, Entering Numbers into Cells, Editing Cell Data, Appending 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, Selecting Data, Selecting Adjacent and Non-Adjacent Cells, Selecting Non-Adjacent Columns, Selecting Non-Adjacent Rows, Selecting a Worksheet, Cell Formats, Number Formats.

Module 3: Data Organisation - Worksheet Organisation, Deleting Worksheets, Moving and Copying Worksheets, Adding a Worksheet, Moving and Copying Worksheets, Renaming Worksheets, Copy, Cut and Paste, Copying a cell, Copying Between Worksheets, Copying Between Workbooks, Moving cells, Sorting Data, Sorting Alphabetically, Sorting Numerically.

Module 4: Configuring Excel - Magnification, Customising the Toolbar, Viewing extra buttons, Moving the Default Toolbars to Two Rows, Displaying and Hiding Toolbars, Adding and Removing Buttons, Splitting and Freezing Windows, Preferences, properties, Options, Changing the Default File Location and User Name.

Module 5: Manipulating Data - Basic Calculations, Cell Referencing, Relative References, Absolute Referencing, Mixed References, Functions, The SUM Function, The Count Function, The Minimum and Maximum Functions, The Average Function, Column and Row Referencing, Using References between Worksheets, Logical Functions, Function Errors, Find and Replace, Spell Checker.

Module 6: Formatting - Preparing the Workbook, Font Type and Size, Font Effects, Bold, Italic and Underscore, Double Underscore, Adding Colour, Cell Background Colour, Text Colour, Copying Formatting, Content Alignment, Text Wrapping, Cell Content Alignment, Cell meging, Content Orientation, Adding Borders.

Module 7: Charts - What is a chart?, Chart Types, Creating a Column Chart, Creating a Bar Chart and Changing Chart Type, Creating a Pie Chart, Creating a Line Chart, Changing Colours, Pie Cgart Segments, Changing the colour of a Column Chart, Changing the Colour of a Line Chart, Changing the Background Chart Colour, Editing/Deleting Chart Text,Deleting titles, Removing Tick Marks, Adding Data Labels, Adding and Removing Titles, Resizing Charts, Deleting Charts, Deleting a Chart when as a Sheet, Deleting a Chart Object, Moving Charts.

Module 8: Workbook Presentation and Printing - Print Preview, Margins, Page Orientation and Size, Page Scaling, Setting the Print Area, Headers and Footers, Adding a Header and Footer, Customising Headers and Footers, Applying Identical Headers and Footers to a Workbook, Output Preparation, Proofing, Configuring the Excel View, Printing Gridline and Column/Row Titles, Applying Automatic Title Rows, Save As, Older Versions, Saving as a Lotus 1-2-3 File, Saving as a Text File, Saving as a HTML, Saving as a Template, Printing, Printing a Cell Range, Printing a Worksheet, Printing a Workbook, Printing Copies, Printing a Chart, Printing and Embedded Chart.