Microsoft Excel 2010: Complete

This course accurately and creatively provides an introductory audience with an understanding of the needed information to pass the Microsoft Office Specialist Certification Series. Its uniqueness and accuracy of content stands out among other courseware, (Procert, November 2011) Students learn the commands in practical, real world applications. Perfect for office workers, professionals, and students who want to know both how and when to best apply Microsoft Excel.

This course teaches the exam objectives for the following certification tests:

Excel® 2010 Core: Exam 77-882

Excel® 2010 Expert: Exam 77-888

In this course, learn how to:

• Enter data and text
• Create formulas that use Relative and Absolute values and audit the formulas
• Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
  
• Create and use Lookup Tables and use the IF functions
• Analyze data visually with a PivotChart
  
• Create a PivotChart and Show the Field List
  

Course Prerequisites: Students who enroll in the Complete Guide to Microsoft Excel 2010 should have basic computer skills, including how to turn on the computer, how to use an Internet browser, and how to select commands from a menu or toolbar. Students should know how to save files and send attachments by email as well.