Microsoft Excel 2000: Advanced Course (1 day)

Course Overview

This advanced course is designed for delegates who are already proficient in the basic and intermediate features and now wish to learn the more advanced features of the product. This two-day course will enable the delegate to add more complex functionality to their spreadsheets.

On completion of the course, you will be able to quickly analyse raw data and produce reports using Excels built in database functions, consolidation and pivot tables. You will also be able to automate repetitive tasks using recorded macros.

Audience

Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel.

Skills Gained

This course will enable delegates to:

• Use database functionality.
• Work with analytical tools.
• Create and work with Pivot Tables.
• Import and Export data.
• Record and edit Macros.
• Customise Excel.

Examinations

This course, along with Fundamentals and Intermediate, covers the curriculum for the ECDL spreadsheet exam.

Prerequisites

This course is designed for students who have completed the Microsoft Excel 2000 Intermediate [E3M2] course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.

Course Outline

Advanced Formulas

• Using Names.
• Decision-making.
• Nesting.
• Financial functions.

Data Tables

• MATCH and INDEX.
• Data Tables.

Advanced List Management

• Subtotals.
• Data validation.
• Database functions.
• Data Forms.

Analytical Options

• Goal Seek and Solver.
• Scenarios.
• Views.
• Reports.

Pivot Tables

• Creating a pivot table.
• Rearranging pivot tables.
• Formatting pivot tables.
• Pivot charts.

Templates

• Using templates.
• Built-in templates.
• Creating and managing templates.

Importing and Exporting

• Importing data.
• Exporting data.
• Querying external databases.

Macros

• Recording and running a macro.
• Editing vba code.

Charts

• Creating combination charts.

Advanced Web Topics

• Creating interactive web spreadsheets.
• Pivot tables on the web.

Follow On Courses

For those who wish to exploit Excel's full potential by creating interactive user interfaces, or automating repetitive procedures for speed and consistency attend

• Excel VBA Overview

Microsoft Excel 2000: Advanced Course (1 day) / MEX00-21