Course Information
Course Overview
Learn every technique for the MO-210 Excel Associate (365 Apps) exam. Comprehensive test exercises and video solutions.
Microsoft Office Specialist (MOS)
The Microsoft Office Specialist: Excel Associate Certification (365 Apps) demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.
Use your knowledge to become a certified Microsoft Excel Associate by preparing for the MO-210 Microsoft Office Specialist exam. The course provides an overview of the exam, the objective requirements set by Microsoft, tips on how to prepare and what to expect on the day of the test. It includes a comprehensive bank of test exercises which reflect the style of questions asked in the MO-210 Microsoft Excel Associate exam. A comprehensive series of lectures are provided which cover every step needed to succeed.
Become a Microsoft Office Specialist and Enhance Your Career
Use your knowledge to obtain certified status
Understand the MO-210 Exam
Learn how to correctly prepare for the test
Get advice from a seasoned professional who knows how to pass the exam
Microsoft Excel Associate with the MO-210 Exam
This course is suitable for people at all levels of proficiency in Microsoft Excel. If you are new to the subject, then the course will lead you step by step through every single technique which is tested in the MO-210 exam. If you are already proficient in the use of Excel to some extent, then this course will help you to understand what is required in order to obtain a valuable certification in the subject.
Every element of the skills measured by Microsoft for the MO-210 exam is comprehensively covered, together with exercises designed to ensure that you know the style and types of questions which you are required to answer in the exam.
When you pass the MO-210 exam, Microsoft issue you with the Microsoft Office Specialist Associate certification status, in Excel. Obtaining this certification provides tangible evidence that you are proficient in your use of Microsoft Excel and your LinkedIn profile will be automatically adjusted by Microsoft to reflect this achievement.
If you follow and complete the course and exercises you will optimise your chances of gaining that qualification, you will enhance your status in your existing job and boost your job prospects in the marketplace.
Content and Overview
Suitable for beginners or for anyone who has a reasonable knowledge of Microsoft Excel, this course is aimed at you obtaining certification status from Microsoft by passing the MO-210 exam. Rather than simply provide sample questions, the course explains how the exam is structured, the way that the questions should be approached and how to study successfully to pass. The course also includes invaluable advice on the best way to prepare and what to expect from the testing process. A comprehensive exercise book covering each section of the skills measured provided. Video solutions for all of the exercises are also included. Having completed this course you will be confident in your skills to become a Microsoft Excel Associate in Excel 365 Apps.
Course Content
- 10 section(s)
- 76 lecture(s)
- Section 1 Introduction
- Section 2 Introducing the Microsoft Excel User Interface
- Section 3 Import Data Into Workbooks
- Section 4 Navigate Within Workbooks
- Section 5 Format Worksheets and Workbooks
- Section 6 Prepare Workbooks for Collaboration and Distribution
- Section 7 Manipulate Data in Worksheets
- Section 8 Format Cells and Ranges
- Section 9 Define and Reference Named Ranges
- Section 10 Summarize Data Visually
What You’ll Learn
- How to successfully pass the MO-210 Microsoft Certified Excel Associate Exam
- Be confident and competent in your use of Microsoft Excel for everyday business use
- Be ready to begin to study to become a certified Microsoft Office Specialist Associate in Excel 365 Apps
- Guarantee potential Employers of your competence in Microsoft Excel 365 Apps
Skills covered in this course
Reviews
-
DDeborah Traylor
Occasionally I have to listen too closely to know what he is saying or I can understand after hearing him say the word several times. He is not enunciating words clearly. For example, the word "column".
-
TTanitra Thomthong
Very detail, make me comfortable to the test.
-
AAlexander KARSEN
Excellent course for preparing for the exam. Especially in going through the exercises and learning what you need to do to quickly navigate through the questions. I sometimes found myself knowing what to do, but blanked out as to where to find the command and/or option. Going through these exercises and lectures greatly helped.
-
FFrank Rodgers
Very understandable. Learning exactly what it takes to pass the exam. Clear and to the point.