Transcript MOS Excel Expert - Computer Science Technology
Excel XP
Preparation for the Microsoft Office Specialist Certification
e
XP
erience
By: Professor Corinne Hoisington
Excel 2002
Embrace Empower Engage Enhance XP
Worksheet Tab Colors
Border Drawing Tool
Expanded AutoSum Feature
Pictures in Headers/Footers
Error Checking smart tags
Watch window and Evaluate Formula dialog box
Embrace Empower Engage Enhance XP
Embrace Empower Engage Enhance XP
Excel Smart Tag
Embrace Empower Engage Enhance XP
Error Checking Smart Tag
Embrace Empower Engage Enhance XP
Embrace Empower Engage Enhance XP
Top Ten Topics in Excel Expert Certification Test
10. Importing and Exporting Data
• •
Import Data To Excel (Access/Query) EX-172/174
Embrace Empower Engage Enhance XP • •
Publish Worksheets to the Web EX-186/188
Embrace Empower Engage Enhance XP
Managing Workbooks
9. Create Workspaces
•
EX-200
•
Use Data Consolidation EX-204
Formatting Numbers
8. Apply Custom Number Formats
•
EX-210
Embrace Empower Engage Enhance XP
Conditional Formats
•
EX-216
Working with Ranges
7. Using Named Ranges in Formulas
•
EX-224
Embrace Empower Engage Enhance XP
Using Lookup and Reference Functions
•
EX-226
Auditing Worksheets
6. Audit Formulas
•
EX-248
Embrace Empower Engage Enhance XP
Identify Dependencies in Formulas
•
EX-252
Summarizing Data
5. Use Subtotals with Lists and Ranges
•
EX-262
Embrace Empower Engage Enhance XP
Custom Filters
•
EX-264/266
Retrieve External Data
4. Create a Web Query to Import Web Data
•
EX-274
Embrace Empower Engage Enhance XP
Using XML to Share Excel Data on the Web
•
EX-276
Analyzing Data
3.Create a PivotTable Report & PivotChart Report
•
EX-282/290
Embrace Empower Engage Enhance XP
Create a Trendline
•
EX-292
Passwords, Protection, and Properties
2. Protect Worksheets
•
EX-304
Embrace Empower Engage Enhance XP
Create a Shared Workbook
•
EX-312
Workgroup Collaboration
1. Track, Accept, and Reject Changes to Workbooks
•
EX-316
Embrace Empower Engage Enhance XP
Merge Workbooks
•
EX-318