Excel 2000 MOS Expert

This series is designed to help users prepare for the MOS Excel 2000 Expert examination. It covers expert-level Excel topics such as importing and exporting data, working with templates, linking workbooks, and using the Report Manager. It also covers advanced worksheet formatting, including page setup and printing, and sorting and filtering data. More advanced topics covered include ranges, macros and customization, validating and auditing data, and creating and using charts, graphs, and pivot tables. Data analysis, file sharing, and security issues are also discussed.

Syllabus

IMPORTING AND EXPORTING DATA

Shows users how to import data from Excel to other applications, query a database application to extract data, and export data from other applications into Excel.

• Importing Data Using the Text Import Wizard
• Importing Text by Other Methods
• Importing Data from an Application or File
• Querying a Database
• Exporting Data to an Application

WORKING WITH TEMPLATES, LINKS AND REPORT MANAGER

Shows users how to create, apply, and edit templates; use a workspace; link workbooks; preview and print worksheets; and use the Report Manager.

• Working with Templates
• Using a Workspace and Linking Workbooks
• Previewing, Printing, and Report Manager

FORMATTING, SORTING AND FILTERING DATA

Shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.

• Formatting Numbers
• Using and Applying Conditional Formats
• Sorting and Grouping Data
• Using a Data Form
• Using a Data Filter

NAMING RANGES, WORKING WITH MACROS AND CUSTOMISING TOOLBARS

Shows users how to add and delete a named range and use a named range in a formula; use the HLOOKUP and VLOOKUP functions; record, run, and edit a macro, assign a macro to a toolbar button; and hide, display, and customize toolbars.

• Adding, Using and Deleting a Named Range
• Using Lookup Functions
• Recording and Running a Macro
• Editing a Macro
• Working with Toolbars

VALIDATING AND AUDITING DATA

Shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.

• Validating Data
• Using the Auditing Toolbar
• Tracing Precedents and Dependents

ANALYSING DATA AND USING PIVOTTABLES

Shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts.

• Using Goal Seek
• Using Solver
• Working with Scenarios
• Using Data Analysis and PivotTables
• Using PivotTables and PivotCharts
• Using a PivotTable with the Web

SHARING WORK AND ADDING SECURITY

Shows users how to add comments to cells, change workbook properties, apply and remove worksheet and workbook protection and file passwords, track changes, create a shared workbook, and merge workbooks.

• Working with Comments and Properties
• Adding Security
• Tracking Changes
• Sharing Work

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.