 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2002 (XP) Intermediate
Course Aims
MS Excel 2002 (XP) is the latest version of the popular spreadsheet from Microsoft. This course aims to show the reader how to create more sophisticated worksheets, incorporating advanced formatting options and formulae, charts and graphics. You will also learn to use productivity and time-saving features to speed up the creation of workbooks. The course also demonstrates use of internet features, allowing you to publish a worksheet as HTML or send it by email. |
Assumed Knowledge
A working knowledge of using PCs, a keyboard and mouse, Windows 95/98 and some experience of creating basic spreadsheets is assumed. You should be able to use MS Excel to create, format and print a worksheet and be able to use basic functions, such as SUM, AVERAGE, MAX and MIN. |
Course Audience
This course will benefit users with some previous experience of Microsoft Excel, such as that gained at work or by reading our "MS Excel 2002 (XP) Introduction" training course. |
|
Table of Contents
|
Borders and shading and other formatting
|
Apply cell borders and shading
|
|
Modify alignment and orientation of cells
|
|
|
|
Using styles in a workbook
|
Apply a style to worksheet cells
|
|
Remove a style from cells
|
|
Copy styles between workbooks
|
|
|
|
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
|
|
|
|
Using more advanced formulae
|
Use date and time functions
|
|
Use statistical functions
|
|
Create a formula using nested functions
|
|
|
Excel productivity tools
|
Protect the worksheet or parts of the worksheet
|
|
Hide and unhide rows and columns
|
|
Check spelling across the worksheet
|
|
|
|
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
|
|
|
|
Excel and the Internet
|
Save a worksheet/workbook as a web page
|
|
Send a workbook via email
|
|
|
|
|
Glossary
|
|
|
|
|
