 |
 |
|
 Spreadsheets
using MS Excel For ECDL Syllabus
|
|
Who
Should Attend: This course is suitable for users who
would like to understand more about spreadsheet packages and/or are
studying for the ECDL qualification. This is Module 4 of 7
Pre-Requisites:
The
delegate need not have any prior knowledge of MS Excel
Course Length: Two Day Exam Information: The exam is paper
based and the exam paper is marked by a qualified instructor.
The pass is 75%. The exam will be taken at the end of
the course.
|
| Delegates
will learn:
- First Steps with
Spreadsheets including Basic Operations
- How to Create
and Edit Formulas and Functions
- How to Format
the spreadsheet
- How to Print the
spreadsheet
- Importing Objects
- Creating and working
with graphs
|
|
Excel Basics
The workbook environment
Entering and
correcting data
Saving a file
Saving a file in
different formats
Using formulas
Opening a second file
Navigation and
movement techniques
Modifying a Worksheet
Working with ranges
Working with functions
Editing cell contents
Error handling and
the Auditing features
Using Excel Help
Moving and
Copying Data
Inserting rows and ranges
Moving data and
copying data
Absolute references
Using the Fill
Series feature |
Formatting a Worksheet
Formatting a worksheet
Number formats and
text alignment
Copying and
pasting formats
Special and custom formatting
Printing a Worksheet
Checking spelling
Using Print Preview
Printing a large worksheet
Additional print options
Introduction to workbooks
Using a
multi-sheet workbook
Creating a chart
Customise toolbars
Sorting and
Filtering Data
Single and
multi-level sorting
Filtering a data list
Multiple condition criteria
Importing Objects
Importing images
and text files
Importing graphs
from other spreadsheets |
|
|
 |
|
Desktop Courses