Certification

Microsoft Office Specialist Exam Skill Standards: Excel 2000 Expert

Importing and Exporting Data

• Import data from text files by using the insert and drag-and-drop operations
• Import data from other applications
• Import a table from an HTML file (insert and drag and drop operations, including HTML round tripping)
• Export data to other applications

Using Templates

• Apply templates
• Edit templates
• Create templates

Using Multiple Workbooks

• Use a workspace
• Link workbooks

Formatting Numbers

• Apply number formats such as accounting, currency, and number formats
• Create custom number formats
• Use conditional formatting

Printing Workbooks

• Print and preview multiple worksheets
• Use the Report Manager feature

Working with Named Ranges

• Add and delete a named range
• Use a named range in a formula
• Use Lookup Functions, such as Hlookup or Vlookup

Working with Toolbars

• Hide and display toolbars
• Customize a toolbar
• Assign a macro to a command button

Using Macros

• Record macros
• Run macros
• Edit macros

Auditing a Worksheet

• Work with the Auditing Toolbar
• Trace errors (find and fix errors)
• Trace precedents (find cells referred to in a specific formula)
• Trace dependents (find formulas that refer to a specific cell)

Displaying and Formatting Data

• Apply conditional formats
• Perform single and multilevel sorts
• Use grouping and outlines
• Use data forms
• Use subtotaling
• Apply data filters
• Extract data
• Query databases
• Use data validation

Using Analysis Tools

• Use the Microsoft PivotTable autoformat
• Use Goal Seek
• Create Microsoft PivotChart reports
• Work with Scenarios
• Use Solver
• Use data analysis and PivotTable
• Create interactive tables for the Web with PivotTable
• Add fields to a table using the Web browser

Collaborating with Workgroups

• Create, edit, and remove a comment
• Apply and remove worksheet and workbook protection
• Change workbook properties
• Apply and remove file passwords
• Track changes (highlight, accept, and reject)
• Create a shared workbook
• Merge workbooks

Back to Microsoft Office Specialist Exams