1 / 17

Excel XPPreparation: Expert Certification Guide

Get ready for the Microsoft Office Specialist Certification with Professor Corinne Hoisington's comprehensive guide. Learn essential Excel features, from worksheets to data analysis, to ace the exam. Master Excel skills and boost your career prospects.

narcisse-gauthier
Download Presentation

Excel XPPreparation: Expert Certification Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. Error Checking Smart Tag Excel Smart Tag

  4. 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

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

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

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

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

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

  10. 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

  11. Analyzing Data • 3.Create a PivotTable Report & PivotChart Report • EX-282/290 • Create a Trendline • EX-292

  12. Passwords, Protection, and Properties • 2. Protect Worksheets • EX-304 • Create a Shared Workbook • EX-312

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

More Related