Dale Rainwater Consulting
Microsoft Excel 97

Home Services Experience Certifications Skills Training About Us Contact Information Site Map

 

Description

Microsoft Excel 97 is a spreadsheet program included with Microsoft Office 97 suite.  A Microsoft Excel 97 Microsoft Office Specialist certificate validates a consultant's skills in using Microsoft Excel 97.  The Microsoft Office Specialist program offers confidence to clients while choosing a consultant.  A Microsoft Office Specialist certificate provides a qualitative assessment of a consultant's abilities skills using Microsoft Excel 97.

The Microsoft Office Specialist Excel 97 exam contents and objectives are provided below.  In addition to meeting the Microsoft Office Specialist Excel 97 certification requirements, Dale Rainwater holds Microsoft Office Specialist certifications in Microsoft Excel 2002 and Microsoft Excel 2000.  

The Microsoft Excel 97 Microsoft Office Specialist exam evaluates a candidates skills using an Excel 97 spreadsheet's templates, formulas, formats, Visual Basic for Applications macros and other advanced functionality.

Dale Rainwater Consulting offers computing services in New York City, NY and Northwest Arkansas.

Exam Contents / Objectives

Microsoft Excel 97

 
Formatting Worksheets
bulletApply formats (accounting, fraction, and scientific)
bulletCreate custom formats
bulletUse styles and autoformats
Using Lists
bulletSorting data
bulletQuery from a list
Printing Workbooks
bulletPreview workbooks
bulletPrint workbooks
Auditing a Worksheet
bulletCheck and review data
bulletFind cells referred to in a specific formula
bulletFind formulas that refer to a specific cell
bulletFind errors
Using Advanced Functionality
bulletQuery databases
bulletExtract data
bulletUse filters
bulletUse data analysis tables created with Microsoft PivotTable®
bulletUse data map
bulletUse data validation
bulletUse conditional formatting
bulletPerform multilevel sorts
Using Macros
bulletCreate and record macros
bulletEdit macros
bulletRun macros
Importing and Exporting Data
bulletImport from other applications
bulletExport to other applications
Using Templates
bulletWork with existing templates
bulletCreate templates
bulletEdit templates
Using Multiple Workbooks
bulletLink workbooks
bulletUse multiple workbooks
Using Workgroup Functions
bulletUse cell tips
bulletShare lists
bulletTrack changes
bulletResolve conflicts
bulletShow history of changes
bulletMerge workbooks

 

Home ] Services ] Experience ] Certifications ] Skills ] Training ] About Us ] Contact Information ] Site Map ]