Microsoft Excel enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. To validate your Excel skills Microsoft offers the Excel certification in two levels: Word Core and Word Expert.

Microsoft Office Certification can help you prepare for one or both exams. To become a Master Microsoft Office Specialist you will need to pass the Excel Expert exam.

Some of the things a Microsoft Office Specialist in Excel must know are the following:

Enter and edit cell content
Navigate to specific cell content
Locate, select and insert supporting information
Insert, position, and size graphics
Use subtotals
Define and apply advanced filters
Group and outline data
Use data validation
Create and modify list ranges
Add, show, close, edit, merge and summarize scenarios
Perform data analysis using automated tools
Create Pivot Table and Pivot Chart reports
Use Lookup and Reference functions
Use Database functions
Trace formula precedents, dependents and errors
Locate invalid data and formulas
Watch and evaluate formulas
Define, modify and use named ranges

For help deciding which level of certification is right for you, complete the form to request more information and a training representative will get back to you.

Does your school teach Office? Click here to list your school on
Microsoft Office Certification.