| ECDL v4: Module 4 Spreadsheets |
|
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
Those who wish to learn how to use this popular spreadsheet program to the ECDL syllabus
Knowledge of Windows and using a mouse
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
1010190740
Accounts
