 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2000 Intermediate
Course Aims
MS Excel 2000 is the popular version of the spreadsheet from Microsoft. This course is designed to advance users' knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those reading will get practice in creating and modifying actual spreadsheets, enhancing them with charts and graphics and using more advanced formulae. This Excel 2000 course also instructs users in Year 2000 best practice. |
Assumed Knowledge
A working knowledge of using PCs, a keyboard and mouse, Windows 95/98 and some experience of creating basic spreadsheets is assumed, gained from the workplace or by reading our "Windows 95/98 User Introduction" or "MS Excel 2000 Introduction" course. |
Course Audience
Users with a basic understanding of MS Excel 2000 who want to consolidate and expand on their knowledge of the basic features in a short space of time. |
|
Table of Contents
|
Excel 2000 Intermediate
|
Intermediate spreadsheet functions and features
|
|
|
|
Formatting the worksheet
|
Adding borders and shading
|
|
|
|
Using styles
|
Creating and applying a new style
|
|
|
|
Navigating worksheets and workbooks
|
Opening a second workbook
|
|
Working with large sheets
|
|
|
|
Using more advanced formulae
|
Preventing rounding errors
|
|
Conditional formulae (IF, AND and OR)
|
|
Financial functions (PMT, FV, PV)
|
|
|
|
Productivity features
|
|
|
Charts and pictures
|
Inserting ClipArt and pictures
|
|
|
|
Excel and the Internet
|
Saving a worksheet as a Web page
|
|
Sending worksheets and workbooks via e-mail
|
|
|
|
|
|
