eXPerience

1
Excel XPPreparation for the Microsoft Office
Specialist Certification

• eXPerience

eXPerience
eXPerience
By Professor Corinne Hoisington
2
Excel 2002

• Worksheet Tab Colors
• Border Drawing Tool
• Expanded AutoSum Feature
• Pictures in Headers/Footers
• Error Checking smart tags
• Watch window and Evaluate Formula dialog box

3
(No Transcript)
4
(No Transcript)
5
Excel Smart Tag
6
(No Transcript)
7
(No Transcript)
8
Top Ten Topics in Excel Expert Certification Test

• 10. Importing and Exporting Data
• Import Data To Excel (Access/Query)
• EX-172/174
• Publish Worksheets to the Web
• EX-186/188

9
Managing Workbooks

• 9. Create Workspaces
• EX-200
• Use Data Consolidation
• EX-204

10
Formatting Numbers

• 8. Apply Custom Number Formats
• EX-210
• Conditional Formats
• EX-216

11
Working with Ranges

• 7. Using Named Ranges in Formulas
• EX-224
• Using Lookup and Reference Functions
• EX-226

12
Auditing Worksheets

• 6. Audit Formulas
• EX-248
• Identify Dependencies in Formulas
• EX-252

13
Summarizing Data

• 5. Use Subtotals with Lists and Ranges
• EX-262
• Custom Filters
• EX-264/266

14
Retrieve External Data

• 4. Create a Web Query to Import Web Data
• EX-274
• Using XML to Share Excel Data on the Web
• EX-276

15
Analyzing Data

• 3.Create a PivotTable Report PivotChart Report
• EX-282/290
• Create a Trendline
• EX-292

16
Passwords, Protection, and Properties

• 2. Protect Worksheets
• EX-304
• Create a Shared
• Workbook
• EX-312

17
Workgroup Collaboration

• 1. Track, Accept, and Reject Changes to Workbooks
• EX-316
• Merge Workbooks
• EX-318