Excel 2000 Professional

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 attending will get practice in using advanced features of Excel 2000 to analyze and share spreadsheet data and create spreadsheet databases. This Excel 2000 course also instructs users in Year 2000 best practice.

Target audience

Users with a basic understanding of Excel 2000 who want to consolidate and expand on their knowledge of the basic features in a short space of time. A good working knowledge of Excel, plus Windows 95/98/NT/2000 is assumed, gained from the workplace or by prior attendance on an "Excel 2000 Advanced" course.

Course content

Microsoft Excel 2000 Professional Year 2000 Best Practice . Review Exercise

Auditing a worksheet Using worksheet auditing tools . Data entry validation . Validating the whole worksheet . Auditing data dependency . Finding and replacing data

Working with data lists Setting up lists . Sorting lists . Filtering lists . Using forms

Data management Searching for data with advanced filters . Compiling consolidations . Summarising data with outlines . Querying a database . Data sources . Controlling formatting and layout . Refreshing external data

PivotTables Creating a PivotTable . Modifying a PivotTable . Creating a PivotTable chart . Creating interactive PivotTables for the Web

Using analysis tools Goal Seeking . Using Solver . The Scenario Manager . Scenario Summaries . Merging Scenarios

Collaborating with workgroups Applying worksheet protection . Password protecting a file . Changing workbook properties . Adding comments to the worksheet . Shared workbooks . Tracking changes . Resolving conflicts . Merging workbooks . e-mailing workbooks for review

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today