 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2000 Professional
Course Aims
MS Excel 2000 is the popular version of the spreadsheet from Microsoft, designed specifically for the networked office environment. This course is designed to give users an understanding of advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those reading will get practice in using advanced features of Excel 2000 to analyse and share spreadsheet data and create spreadsheet databases. This Excel 2000 course also instructs users in Year 2000 best practice. |
Assumed Knowledge
A good working knowledge of Excel, plus Windows 95/98/NT is assumed, gained from the workplace or by prior reading our "MS Excel 2000 Advanced" course. |
Course Audience
Existing users of MS Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time. |
|
Table of Contents
|
|
Microsoft Excel 2000 Professional
|
|
|
Auditing a worksheet
|
Using worksheet auditing tools
|
|
Validating the whole worksheet
|
|
Finding and replacing data
|
|
|
|
|
Working with data Lists
|
|
|
Data management
|
Searching for data with advanced filters
|
|
Summarising data with outlines
|
|
Controlling formatting and layout
|
|
|
PivotTables
|
Creating a PivotTable chart
|
|
Creating interactive PivotTables for the Web
|
|
|
|
|
Using analysis tools
|
|
|
Collaborating with workgroups
|
Applying worksheet protection
|
|
Password protecting a file
|
|
Changing workbook properties
|
|
Adding comments to the worksheet
|
|
e-mailing workbooks for review
|
|
|
|
|
|
