 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
CLAIT Level 2 - Spreadsheets, Graph, and Chart Solutions with Excel 2002
Course Aims
This course is designed to help people to obtain the skills and knowledge required for New CLAIT Unit 2 "Spreadsheets", New CLAIT Unit 9 "Graphs and Charts", and CLAIT Plus Unit 10 Spreadsheet Solutions. Readers will learn to use Excel to create worksheets and charts. Readers will learn to create formulas incorporating different functions, create and format charts, and use data analysis tools. |
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 either have basic previous experience with a computer or completed a "Using the Computer" course. |
Course Audience
This course is intended for people who are pursuing the New CLAIT or CLAIT Plus qualifications and seeking basic skills in spreadsheets. |
|
Table of Contents
|
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 - Editing a Formula
|
Create a formula using functions
|
|
Use basic arithmetic functions (SUM, AVERAGE, COUNT, MIN, MAX)
|
|
Recognise and resolve common error messages
|
|
|
|
Excel 2002 - Formatting Cell Contents
|
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)
|
|
Use the Format Painter to copy cell formats
|
|
Clear cell content and formats
|
|
|
|
Excel 2002 - Formatting Cell Values
|
Apply value formats (currency, percent, dates, and comma)
|
|
Change the currency symbol
|
|
Apply other formats (accounting, time, text, general)
|
|
|
|
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 - Structuring a Worksheet
|
Modify the size of columns and rows
|
|
Insert and delete rows and columns
|
|
Insert and delete selected cells
|
|
|
|
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 - Borders and Shading
|
Apply cell borders and shading
|
|
|
|
Excel 2002 - Viewing a Large Worksheet
|
Go To a specific cell or named range
|
|
Split a worksheet into different viewing panes
|
|
Freeze and unfreeze worksheet titles
|
|
View a workbook in multiple windows
|
|
Hide and unhide rows and columns
|
|
Hide and unhide worksheets and workbooks
|
|
|
Excel 2002 - Using Named Ranges
|
Apply a name to a range of cells
|
|
Apply a name to a constant value
|
|
Modify and delete range names
|
|
Print a list of range names
|
|
Use a range names and labels in formulas
|
|
|
|
Excel 2002 - Data Lists
|
Use a form to view, sort, and enter records
|
|
Perform single and multi-level sorts
|
|
|
|
Excel 2002 - Linking Worksheets and Workbooks
|
Create a formula to link worksheets and workbooks
|
|
Manage and update linked workbooks
|
|
Use Paste Special to link worksheets and workbooks
|
|
Consolidate data using 3D references in common functions
|
|
|
|
Excel 2002 - Mathematical Functions
|
Use other arithmetical functions (PRODUCT, RAND, PI, SQRT)
|
|
|
|
Excel 2002 - Logical and Nested Functions
|
Use the IF, AND, OR, and NOT functions in formulas
|
|
|
|
Excel 2002 - Statistical and Database Functions
|
Use other statistical functions (MIN, MAX, MEDIAN, MODE, STDEV)
|
|
Use Dfunctions to perform calculations on a data list
|
|
|
|
Excel 2002 - Using Analysis Tools
|
Use one - and two-input data tables to resolve What-If? calculations
|
|
Solve a problem using Goal Seek
|
|
Use Solver to calculate complex problems
|
|
Create What-If analyses using the Scenario Manager
|
|
|
|
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
|
|
|
|
Excel 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, and line width)
|
|
Format data series (scale, shading, spacing, and width)
|
|
|
|
Excel 2002 - Customising a Chart
|
Reposition chart elements (titles, legend and labels)
|
|
Explode segments of a pie chart
|
|
Change the source data for a chart and modify data series
|
|
Add a trendline to a chart
|
|
Create a combination chart
|
|
Insert an image into a chart
|
|
Store a custom chart as a chart template
|
|
|
|
Excel 2002 - Distributing a Workbook
|
Save a workbook as a plain text file
|
|
Save a workbook for a different application
|
|
Save a workbook as a template
|
|
|
|
|
|
