 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
e-Quals: Level 2 Spreadsheets with Excel 2002
Course Aims
This course is designed to help you to obtain the skills and knowledge required for e-Quals Level 2 Unit 023 "Spreadsheets". You will learn to use Excel 2002 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 an "IT Principles" course. |
Course Audience
Students training to obtain a Diploma for IT Users or those wanting to become proficient in use of spreadsheets. |
|
Table of Contents
|
Excel 2002 - What is Excel?
|
Understand the functions of spreadsheet application
|
|
Recognise the different elements of the Excel screen
|
|
|
|
Excel 2002 - 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
|
|
|
|
Excel 2002 - Entering and Editing Data
|
Enter text, values, and dates in cells
|
|
|
|
Excel 2002 - 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 2002 - Moving and Copying Data
|
Use Drag-and-Drop to move or copy cell contents
|
|
Move, copy, and paste data using the Windows Clipboard
|
|
|
|
Excel 2002 - 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 2002 - 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 2002 - Formatting Cell Values
|
Apply value formats (currency, percent, date, comma)
|
|
Change the currency symbol
|
|
Apply other formats (accounting, time, text, general)
|
|
|
|
Excel 2002 - Structuring a Worksheet
|
Modify the size of columns and rows
|
|
Insert and delete rows and columns
|
|
Insert and delete selected cells
|
|
|
|
Excel 2002 - 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 2002 - 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 2002 - Designing a Spreadsheet
|
Identify data inputs, processing, and output
|
|
Identify the design steps and spreadsheet functions required to produce an accurate spreadsheet
|
|
Describe different methods of testing a spreadsheet
|
|
|
|
Excel 2002 - Data Lists
|
Use a form to view, sort, and enter records
|
|
Perform single and multi-level sorts
|
|
Filter a list using AutoFilter
|
|
|
|
Excel 2002 - 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 2002 - 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
|
|
Change the colour of a worksheet tab
|
|
|
|
Excel 2002 - Protecting Data
|
Apply and remove worksheet protection
|
|
Lock and unlock cell ranges
|
|
Apply and remove file passwords to open or change a workbook
|
|
|
|
Excel 2002 - Proofing Tools
|
Check spelling across the worksheet
|
|
|
|
Excel 2002 - Borders and Shading
|
Apply cell borders and shading
|
|
|
|
Excel 2002 - Creating a Chart
|
Use the Chart Wizard to create different chart types
|
|
Reposition, resize, and delete a chart
|
|
Preview and print a chart
|
|
|
|
Office 2002 - 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)
|
|
|
|
Office 2002 - Scatter and Combination Charts
|
Create an XY (Scatter) or Bubble chart
|
|
Add a trendline to a chart
|
|
Create a combination chart
|
|
Add a second value axis to a chart
|
|
|
|
Excel 2002 - Logical and Nested Functions
|
Use the IF, AND, OR, and NOT functions in formulas
|
|
|
|
Office 2002 - Recovering Office Data
|
Save an AutoRecover file automatically
|
|
Recover a document if the application stops working
|
|
|
|
|
|
