Dale Rainwater Consulting
Microsoft Excel 2002

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

 

Description

Microsoft Office xp suite includes Microsoft Excel 2002, which is a spreadsheet program that includes limited database functionality.  The Microsoft Office Specialist certification in Microsoft Excel 2002 ensures productive and efficient using Excel 2002 functionality such as data import and export, managing workbooks, auditing worksheets, and analyzing and summarizing data.  The Microsoft Office Specialist Exam 2002 exam contents and objectives are provided below.

Microsoft Office Specialist certificates in Microsoft Excel 2002, Microsoft Excel 2000 and Microsoft Excel 97 are held by Dale Rainwater. 

Microsoft Excel 2002 can be automated using Microsoft Visual Basic for Applications (VBA).

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

Exam Contents / Objectives

Microsoft Excel 2002

 
Importing and Exporting Data
bulletImport data to Excel
bulletExport data from Excel
bulletPublish worksheets and workbooks to the Web
Managing Workbooks
bulletCreate, edit, and apply templates
bulletCreate workspaces
bulletUse data consolidation
Formatting Numbers
bulletCreate and apply custom number formats
bulletUse conditional formats
Working with Ranges
bulletUse named ranges in formulas
bulletUse Lookup and Reference functions
Customizing Excel
bulletCustomize toolbars and menus
bulletCreate, edit, and run macros
Auditing Worksheets
bulletAudit formulas
bulletLocate and resolve errors
bulletIdentify dependencies in formulas
Summarizing Data
bulletUse subtotals with lists and ranges
bulletDefine and apply filters
bulletAdd group and outline criteria to ranges
bulletUse data validation
bulletRetrieve external data and create queries
bulletCreate Extensible Markup Language (XML) Web queries
Analyzing Data
bulletCreate a Microsoft PivotTable®, Microsoft PivotChart®, and PivotTable/PivotChart Reports
bulletForecast values with what-if analysis
bulletCreate and display scenarios
Workgroup Collaboration
bulletModify passwords, protections, and properties
bulletCreate a shared workbook
bulletTrack, accept and reject changes to workbooks
bulletMerge workbooks

 

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