The MOS (Microsoft Office Specialist) Microsoft Excel 2010 Course will help students to master the Microsoft Excel 2010 software package.

The course is ideal for beginners and takes users to an advanced level of proficiency. Designated as Approved Course materials for the Microsoft Office Specialist program, this course will help students prepare for the Excel 2010 exam (77-882).

This Microsoft certification credential demonstrates proficiency in the newest standard of the world's foremost desktop computing applications. MOS certifications are primarily for anyone who uses Microsoft Office programs as a vital part of their job functions. These certifications cover the entire Microsoft Office Suite.

SPECIAL OFFER: Purchase 3 MOS 2010 Courses for only £450.00. Check out using the following code to apply your £75.00 discount: DLCMOS10.

The Course Consists of the Following Items:

  • MOS Excel 2010 Basics Course Book:

The Basics course book teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

The following topics are covered in this book: Getting Started; Entering & Editing Data; Modifying a Worksheet; Using Functions; Formatting; Printing; Charts; Managing Large Workbooks and Graphics & Screenshots.

  • MOS Excel 2010 Intermediate Course Book:

Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts.

The following topics are covered in this book: Using multiple worksheets and workbooks; Advanced formatting; Outlining and subtotals; Cell and range names; Tables; Web & Sharing features; Advanced charting; Documenting and auditing; Templates and settings; and PivotTables and PivotCharts.

  • MOS Excel 2010 Advanced Course Book:

Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

The following topics are covered in this book: Logical and statistical functions; Financial and date functions; Lookups and data tables; Advanced data management; Exporting and importing; Analytical tools; and Macros and custom functions.

  • Student Exercise Files:

Once enrolled students will receive a support email giving them access to their student files and to PowerPoint presentations relevant to the content of each unit. These files are also available through a student page and can be sent on disk on request.

  • GMetrix Exam Preparation Software:

The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

Overview of Test features:

  • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives
  • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience
  • All tests have both a testing and a training mode providing step-by-step help on each question
  • Progress at own pace, save test to resume later, return to skipped questions
  • Detailed, printable score report highlighting areas requiring further review

Please Note: You will need a version of Microsoft Office 2010 to be able to use the GMetrix software package.

Prerequisites:

There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2010 to complete the course.

Course Duration & Support:

Students may register at any time. The courses are designed as self-study courses but if you have any problems you can email our email support. As the course is self study you can complete in as little or as long a time as you prefer, and we do not impose a cut-off date for study.

Assessment:

Assessment is in the form an MOS Examination. Examinations are in a multiple choice/multiple answer format. Earning a Microsoft Office Specialist certification can help you differentiate yourself in today's competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Microsoft Office Specialist certification can also lead to increased job satisfaction. Research indicates that certified individuals have increased competence, productivity, and credibility with their employers, co-workers, and clients.

Qualification:

MOS Excel 2010 CourseOn Completion of Course, you can apply for your Microsoft MOS Excel 2010 - 77-882 Examination.

Exams must be sat at a registered Certiport testing centre. Exam vouchers (Valid for 12 Months) can be purchased via our website for £65.00. We advise buying this when you are ready to sit your test, although you can add this to your order when you purchase your course.

Please Note: Exam Centre’s will usually charge an additional proctoring fee (Approximately £20.00) for sitting exams.

View Testimonials
Submit a Testimonial