
Each of the projects in the course uses an Excel Macro Enabled file to display the project tasks involved.. You have to download the files and unblock them so that the macro will run. This lecture provides instructions on how to prepare these macro enabled files.
This lecture explains how to access the project files, how to display the videos at the best resolution and when to use the Udemy review system.
This lecture explains how to register to take the exam and how the exam is conducted.
This section of the course elaborates on any specific issues which we believe will be important in the exam. While we have covered the vast majority of the skills you will examined on, there are some specific tricky techniques which we detail in the lectures which follow.
If you would prefer to have the project tasks available as a printed document we have provided all project tasks in pdf format.
This lecture provides all of the macro enabled project files as a zipped resource.
These resources are those required in addition to the Macro Enabled Project files
This 'Problem Solving' approach of this course emphasizes the need to be able to complete Excel tasks rapidly in the exam. In the process of taking this course you will be exposed to the correct approach to completing standard exam projects.
In our sister course entitled 'Complete Techniques for Excel (365 Apps) MO-210 Exam' (https://www.udemy.com/course/complete-techniques-for-mo-210-excel-365-apps-certification/) we focus on providing a detailed explanation of every technique specified in the Microsoft syllabus for the MO-210 exam. In this section we have provided a sample lecture which covers all of the techniques you need to understand for the Import Data section of the syllabus. The course also includes sample exam questions for every technique involved, together with solutions.
So if you are in any doubt about your abilities in any of the required techniques, then it may be useful for you to review the above course and ensure that you are ready to use the correct methods.
Course Overview
Many students are familiar with Excel and its interface, but very few are actually properly prepared for the types of tasks expected in certification exams and very few are properly prepared for the time limits imposed on the day of the test.
This course will prepare you to succeed in the MO-210 Microsoft Excel (365 Apps) certification exam at the 1st Attempt.
Aimed at those who have some familiarity with the Microsoft Excel (365 Apps) software interface, the approach taken is to provide tasks which mirror the skills measured sections of the MO-210 syllabus, and then to explain how to approach the answers in the actual exam.
This problem solving approach to the course is designed to ensure that you are ready to solve the project tasks which are set in the MO-210 exam. These tasks are designed by Microsoft to test your ability to use the skills measured in the exam. By following this course, you will learn precisely which skills are already within your skill set, which ones you need to develop, and which elements of the Skills Measured by Microsoft you need to work on.
The approach taken is to give you the opportunity to test yourself with 18 projects and 105 project tasks all set to the standard of the MO-210 exam. Attempt a project task, assess your competence in the techniques involved and then review the solution which explains both the techniques and the best approach to completing the tasks posed.
Advice on preparation, how to approach the exam, what the interface will look like and which areas of the Skills Measured is provided by lecturers who have taken many thousands of students through to Microsoft Office Specialist certification success.
Be confident in your abilities to master the MO-210 Excel Associate exam by taking this course and passing at the 1st attempt!