Mos Excel 2010 Course
|
Summary
|
|
|||||||||||
Mos Excel 2010 Course
The MOS (Microsoft Office Specialist) Microsoft Excel 2010 Course will help students to master Microsoft Excel 2010.
The course is ideal for beginners and takes users to an advanced level of proficiency. Designated as Approved Courseware 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.
Please Note: This course is not compatible with Apple Mac Computers.
The Course Consists of the Following Items:
A four-colour, tri-fold, six-sided Course Card
Officially endorsed MOS Courses books with accompanying CD Rom�s containing exercise files
Online CertBlaster Exam Preparation Software
- MOS Excel 2010 Course Card:
The course card gives important information you need quickly and easily. The Course Card contains vital information for both basic and advanced skills and offers something for students of all levels.
- 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 by this lesson: 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 by this lesson: 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 by this lesson: 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.
- Exercise Files CD Rom�s:
A CD Rom is included in each course book which contains all of the exercise files required to successfully complete your study and aim towards your MOS examinations.
- CertBlaster Online Exam Preparation Software
The course also comes with DTI Publishing�s Online CertBlaster exam preparation software absolutely free. CertBlaster covers mock examination questions in multiple choice or multiple answer formats. This software is the perfect addition to help preparefor your exam.
Pre-Requirements:
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:
On Completion of Course, you can apply for your Microsoft MOS Excel 77-882 Examination.
Examinations must be sat at a registered Certiport testing centre. Exam Vouchers can be bought directly from Prodigy UK for �65.00 and you can locate testing centres and schedule appointments on their Website: www.prodigyuk.co.uk.
Please Note: Exam Centre�s will usually charge an additional proctoring fee (Approximately �20.00) for sitting exams.
If you want to find out more about Mos Excel 2010 Course, you can make an information request below and the school will contact you with further information.
Approximate Delivery Time
Course Format
Distance Learning Centre
The Distance
Learning Centre is one of the leading and longest established
suppliers of
distance learning courses, open learning, home study, and correspondence
courses in the UK. Providing distance
learning courses since 1994, the Distance Learning Centre has grown to
be one
of the UK’s leading distance learning
providers.
The Distance Learning Centre offers a wide variety of subjects which you can study at your own pace from home or work. Each year, thousands of students sign up for our distance learning courses and gain relevant nationally-recognised qualifications to assist their career and improve their employability. Become one of them. Contact The Distance Learning Centre.
As well as our large range of Contemporary Distance Learning Courses, a small range of Online E Learning Courses are provided.
How do the distance courses work?
It's all really very simple. The Distance Learning Centre supplies you with appropriate study materials to head for a particular qualification or exams. You receive your course materials in one go so you know exactly what you are getting for your money. You then receive support through a personal tutor to help you get through the course materials.
What are the advantages of Distance Learning?
|
There are many advantages to Distance Learning, but the main advantages have to be cost and flexibility. When studying via Distance Learning, there is no need to attend a classroom, so there is no waste of time or other resources spent commuting to specific location for each class. Distance learning is also a great advantage for those with restricted mobility. Distance Learning allows you to study at own pace, as quickly or slowly as you please, and of course the costs are also a lot less! |
|
Why are your course fees smaller than other companies?
Distance Learning allows smaller fees for you because we do not have the large overheads that some over companies have. We do not spend thousands of pounds on expensive television and radio campaigns and do not employ a large sales team.
Are the courses tutor supported?
You can get help from your dedicated tutor 7 days a week by email, or post. Some courses also come with telephone support.
Interested in taking a distance learning course? Request Information and our advisors will help you
Show all courses with
Distance Learning Centre
Request information - obligation free
Contact information for Distance Learning Centre
Phone no: 0845 129 7238 
To request information from Mos Excel 2010 Course, please fill out the following details:
