About this Course

This qualification is designed to teach learners of the many different functions and tools that can be used in Microsoft Word and, upon completion of the examination, students acquire Microsoft Word 2013 Specialist accreditation. With many different aspects that normal users rarely see, the course gives a very deep understanding of one of the worlds most used software packages.

Upon completion of this qualification students earn an OLC Diploma and can enter themselves for the Microsoft examination which will result in full certification when the necessary third party exams are passed.

Qualification

This qualification is designed to teach students essential skills when working in a job role working with Microsoft software. It covers all of the functionality that Microsoft Word offers to users so that learners can achieve a formal qualification as a Microsoft Word 2013 Specialist. The examination for this course contains 40 – 60 questions and you have 50 minutes to complete the test. The required pass percentage is 70%.

Qualification code: 77-418

Method

Students are able to access their course materials at any time and the qualification includes the following:

Expert Instructor-Led Training

Uses the content from the finest publishers and only the IT industry’s finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

Interactive Exercises

Our courseware includes include real world, interactive exercises. Focusing on real world scenarios and skill-set development.

Exercises, Quizzes & Flashcards

This course houses exercises, quizzes and flashcards that prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcards and exercises after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.

Practice Test Sets

This course also include full length practice test sets designed to test your knowledge under real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exam Simulators

Online labs to supplement your training. Labs are inexpensive and a safe way to explore and learn. The labs on this course are versatile – labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Course Content

This course assesses the following topics:

Lesson 1: Introducing Excel

Lesson 2: Entering and Editing Worksheet Data

Lesson 3: Essential Worksheet Operations

Lesson 4: Working with Cells and Ranges

Lesson 5: Introducing Tables

Lesson 6: Worksheet Formatting

Lesson 7: Understanding Excel Files

Lesson 8: Using and Creating Templates

Lesson 9: Printing Your Work

Lesson 10: Introducing Formulas and Functions

Lesson 11: Creating Formulas That Manipulate Text

Lesson 12: Creating Formulas That Count and Sum

Lesson 13: Getting Started Making Charts

Lesson 14: Learning Advanced Charting

Lesson 15: Visualizing Data Using Conditional Formatting

Lesson 16: Creating Sparkline Graphics

Lesson 17: Enhancing Your Work with Pictures and Drawings

Lesson 18: Customizing the Excel User Interface

Lesson 19: Using Custom Number Formats

Lesson 20: Using Data Validation

Lesson 21: Creating and Using Worksheet Outlines

Lesson 22: Excel and the Internet

Lesson 23: Importing and Exporting Data

Lesson 24: Introducing Visual Basic for Applications

Lesson 25: Appendix

Assessments

This qualification includes all of the lessons and materials you will need to learn the syllabus and then enter for your examination. Exams are taken at a specific testing centre and are subject to additional charges when you are sitting the test.

For more information on taking a Microsoft examination please click here and search for the correct qualification code. Exam centres do charge an additional fee for sitting the test and students are required to organise their own examinations should they wish to opt for formal Microsoft certification as well as the OLC Diploma which is included in the course fees.

You can find your nearest testing centre using the Certiport locator tool before you enrol on this course.

Support

On this qualification you will receive full tutor support throughout the 12 month course duration. This course is taught on the Online Learning College area of the uCertify platform which has been created by IT professionals and caters for students throughout the world. Students are not automatically enrolled on this qualification but after purchasing the course you will receive login details for you to access the course within 2 working days.