 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL 4 Spreadsheets with Excel 2000
Course Aims
This course is designed to help you to obtain the skills and knowledge required for ECDL 4 Module "Spreadsheets" (Syllabus 4.0). You will learn to use Excel to create, edit, format, and print a simple spreadsheet.
You will also learn to use Excel to create and format charts and graphs of different types based on data stored in a spreadsheet. |
Assumed Knowledge
You should be able to use a personal computer, mouse, and keyboard to create a file and enter and edit data. Typically, you will have either basic previous experience with a computer or completed a "Using the Computer" course. |
Course Audience
Students training to obtain an ECDL or those wanting to become proficient in use of spreadsheets. |
|
Table of Contents
|
Excel 2000 - What is Excel?
|
Understand the functions of spreadsheet application
|
|
Recognise the different elements of the Excel screen
|
|
|
|
Excel 2000 - Creating a Workbook
|
Move around the worksheet using the mouse and keyboard
|
|
Select cells using the mouse and the keyboard
|
|
Use zoom to view a worksheet at different magnification
|
|
|
|
Office 2000 - Managing Office Files
|
Use Save to create a file with a specified name and location
|
|
Use Save As to create a copy of a file with a different name and location
|
|
Create a new folder in which to save a file
|
|
Locate and open an existing file
|
|
Switch between file windows
|
|
Close or save all open documents
|
|
|
|
Excel 2000 - Application Options and File Properties
|
View and change application options
|
|
View and change workbook properties
|
|
|
|
Excel 2000 - Entering and Editing Data
|
Enter text, values, and dates in cells
|
|
|
|
Excel 2000 - Moving and Copying Data
|
Use Drag-and-Drop to move or copy cell contents
|
|
Move, copy, and paste data using the Windows Clipboard
|
|
|
|
Excel 2000 - 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 relative and absolute cell references
|
|
|
|
Excel 2000 - Editing a Formula
|
Create a formula using functions
|
|
Use basic arithmetic functions (SUM, AVERAGE, COUNT, MIN, MAX)
|
|
Recognise and resolve common error messages
|
|
Interpret spreadsheet data
|
|
|
|
Excel 2000 - Formatting Cell Contents
|
Apply font styles (typeface, size, colour, enhancements)
|
|
Modify the alignment and orientation of cell contents
|
|
Merge and unmerge cells (to centre headings across columns)
|
|
Use the Format Painter to copy cell formats
|
|
Clear cell contents or formats
|
|
|
|
Excel 2000 - Formatting Cell Values
|
Apply value formats (currency, percent, date, comma)
|
|
Change the currency symbol
|
|
Apply other formats (accounting, time, text, general)
|
|
|
|
Excel 2000 - Structuring a Worksheet
|
Modify the size of columns and rows
|
|
Insert and delete rows and columns
|
|
Insert and delete selected cells
|
|
|
|
Excel 2000 - Page Layout
|
Change paper size and orientation
|
|
Set page margins and alignment
|
|
Scale print output to fit a defined number of pages
|
|
Print column and row titles and set other options
|
|
View a worksheet in Print Preview
|
|
Change margin and column widths in Print Preview
|
|
Insert and remove a page break
|
|
Set up headers and footers
|
|
Add fields in headers and footers (page number, date/time, file information)
|
|
|
Excel 2000 - Printing Worksheets and Workbooks
|
Print a workbook (all sheets in book)
|
|
Display formulas in worksheet cells
|
|
Set, print, and clear a print area
|
|
Print a group of worksheets
|
|
|
|
Excel 2000 - Proofing Tools
|
Check spelling across the worksheet
|
|
|
|
Excel 2000 - Borders and Shading
|
Apply cell borders and shading
|
|
|
|
Excel 2000 - Data Lists
|
Use a form to view, sort, and enter records
|
|
Perform single and multi-level sorts
|
|
Filter a list using AutoFilter
|
|
|
|
Excel 2000 - Logical and Nested Functions
|
Use the IF, AND, OR, and NOT functions in formulas
|
|
|
|
Excel 2000 - Viewing a Large Worksheet
|
Go To a specific cell or named range
|
|
Split a worksheet into different viewing panes
|
|
Freeze and unfreeze panes as worksheet titles
|
|
View a workbook in multiple windows
|
|
Hide and unhide rows and columns
|
|
Hide and unhide worksheets and workbooks
|
|
|
|
Excel 2000 - Managing Worksheets
|
Switch between worksheets
|
|
Enter and edit data on multiple worksheets
|
|
Copy data between worksheets and workbooks
|
|
Insert and delete worksheets
|
|
Move and copy a worksheet
|
|
|
|
Excel 2000 - Creating a Chart
|
Use the Chart Wizard to create different chart types
|
|
Reposition, resize, and delete a chart
|
|
Preview and print a chart
|
|
|
|
Office 2000 - Formatting a Chart
|
Add, remove, move, resize, and modify chart elements (titles, labels, legend, axes, gridlines)
|
|
Format chart elements (borders, patterns, font, values)
|
|
Format chart axes (number format, text, line width)
|
|
Format data series (scale, shading, spacing, width)
|
|
|
|
Excel 2000 - Distributing a Workbook
|
Save a workbook as a plain text file
|
|
Save a workbook for a different application
|
|
Save a workbook as a template
|
|
|
|
Excel 2000 - Publishing to a Web Page
|
Create and edit hyperlinks
|
|
Save a worksheet or workbook as a web page
|
|
|
|
|
|
