 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL Spreadsheets with MS Excel 2002
Course Aims
This course is designed to prepare readers for the ECDL/ICDL module 4 examination. The course will allow readers to create, edit, format, calculate on and print spreadsheets with Microsoft Excel 2002. Readers will get an introduction to worksheet features, using basic functions to create formulae, using format options to present data clearly, creating charts and graphics, and printing. The course has been designed to cover the learning objectives of ECDL Syllabus Version 3.0 Module 4 Spreadsheets. |
Assumed Knowledge
Readers should be confident users of the computer (start computer, use a mouse, keyboard and printer) and the Windows operating system (start applications and manage files and folders). |
Course Audience
Intending, new or recent users of Excel 2002 who want to get to grips with the basics of this package in a short space of time. |
|
Table of Contents
|
Getting Started with Excel 2002
|
Identify the different elements of the Excel screen
|
|
Display and select items from menus and toolbars
|
|
Get assistance using Excel
|
|
|
|
Creating a Workbook
|
Move around the worksheet using the mouse and keyboard
|
|
Select cells using the mouse and the keyboard
|
|
Enter text, values and dates in cells
|
|
Insert symbols and special characters into a worksheet
|
|
Work with series of data and custom lists
|
|
Work with AutoFill smart tag
|
|
Save an AutoRecover file automatically
|
|
Recover a workbook if Excel stops working
|
|
Locate and open an existing workbook
|
|
|
|
Creating a Formula
|
Understand what a formula is and how to create simple calculations
|
|
Enter a formula by typing or by using the Formula bar
|
|
Enter a range within a formula using the mouse
|
|
Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX)
|
|
Use relative and absolute cell references
|
|
Recognise common error messages
|
|
|
|
Formatting a Worksheet
|
Apply font styles (typeface, size, colour and styles)
|
|
Modify the alignment and orientation of cell contents
|
|
Merge and unmerge cells (to centre headings across columns)
|
|
Apply cell borders and shading
|
|
Apply value formats (currency, percent, dates and comma)
|
|
Modify the size of columns and rows
|
|
Clear cell content and formats
|
|
|
|
Editing and Structuring a Worksheet
|
Go To a specific cell or named range
|
|
Move, copy and paste cells using the Windows or Office Clipboard
|
|
Insert and delete rows and columns
|
|
Insert and delete selected cells
|
|
Insert and delete worksheets
|
|
Move and copy a worksheet
|
|
Change the colour of a worksheet tab
|
|
|
Printing a Worksheet
|
Preview and print a worksheet
|
|
Change page orientation and scaling
|
|
Set page margins and centring
|
|
Setup headers and footers
|
|
Set, print and clear a print area
|
|
Insert and remove a page break
|
|
Print column and row titles and set other options
|
|
|
|
Navigating Worksheets and Workbooks
|
Open more than one workbook
|
|
Switch between open workbooks
|
|
Divide a worksheet into panes
|
|
Switch between panes in a worksheet
|
|
Freeze and unfreeze worksheet panes
|
|
Copy data from one workbook to another
|
|
Consolidate data using 3D references
|
|
|
|
Adding Charts and Pictures to a Workbook
|
Use the Chart Wizard to create a chart
|
|
Move and size worksheet charts
|
|
Change the source data for a chart
|
|
Insert, move and delete clip art and picture objects
|
|
Create and modify lines and objects
|
|
|
|
Working with Other Applications
|
Share workbooks with other applications
|
|
Save a worksheet as a web page
|
|
View a worksheet in web page preview
|
|
Create hyperlinks between workbooks and files
|
|
|
|
|
Glossary
|
|
|
|
|
