Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 34 Minute(s)
Language
English
Taught by
Dave Murphy
Rating
1 views
Course Overview
Microsoft Excel (Office 2019) Expert Certification - Comprehensive lectures, exercises and video solutions.
Important Course Update March 2023 - Complete Practice Exam with Video Solutions!
We've added some very valuable resources to the course in 2023. An additional section entitled "Practice Exam and Video Solutions" has been included at the end of the course. This section includes a complete practice exam set to the standard of the MO-201 exam. This consists of 5 exam projects together with a video solution for each. Don't review the solutions until you make an attempt at the exam project exercises. This will give you a very real sense of how well prepared you are for the MO-201 expert certification exam.
We've also added a new lecture within this section entitled "Special Exam Considerations". This lecture summarizes some important points about this specific exam that you need to consider carefully. The suggestions are based on direct student experience in taking the exam. In particular we focus on:
Technical issues which arise with the exam interface
Being strategic in your preparation and focus
The best approach to the use of formulas
Use of shortcut keys
Coping with nerves
Lots of really good practical exam advice!
Become a Microsoft Certified Excel (365/2019) Expert
Become an Expert by learning from the Experts!
This course will make you an expert in Microsoft Excel, a skill that is highly valued by ALL employers and one which will make you stand out from the crowd.
All of the key advanced Excel skills are covered in depth in this course with the added major benefit of preparing you to take the only official Microsoft Certification exam in Excel Expert (Office 2019) - the MO-201 Microsoft Office Specialist Expert exam.
Every aspect of the MO-201 exam is covered in detail, together with a selection of exercises and video solutions.
Delivered by a University Lecturer with many years experience in teaching Excel to undergraduate students, and who is also a MOS Master and Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will significantly enhance your chances of obtaining this valuable independent certification from Microsoft.
MOS Excel Expert certification is highly regarded by employers because it is independent proof that you have the skills to become productive straight away. That saves a lot of time and effort on the employers part and they value that very highly indeed! Our mission is to make you succeed in passing the MO-201.
Course Content
- 10 section(s)
- 70 lecture(s)
- Section 1 Introduction
- Section 2 1.1 Manage Workbooks
- Section 3 1.2 Prepare Workbooks for Collaboration
- Section 4 1.3 Use and Configure Language Options
- Section 5 2.1 Fill Cells Based on Existing Data
- Section 6 2.2 Format and Validate Data
- Section 7 2.3 Apply Advanced Conditional Formatting and Filtering
- Section 8 3.1 Perform Logical Operations in Formulas
- Section 9 3.2 Look Up Data by using Functions
- Section 10 3.3 Use Advanced Date and Time Functions
What You’ll Learn
- You will be fully prepared to take the MO-201 MOS exam in Excel Expert
- Be familiar with every aspect of the Objective domain for the MO-201 exam
- Be expert in the advanced use of Microsoft Excel 2019
- Be ready to pass the MO-201 exam
Skills covered in this course
Reviews
-
AALISON SCARLETT AVILA CALDERON
111111111111111111111111111111111111111111111111
-
UUmar Mukdhar S
Good
-
JJacqueline de Kock
This course is well-structured and videos with explanations are clear, aimed at tackling each Objective Domain and ultimately, the MO-201 exam. What I would like to recommend most importantly, is to level up all exercises and challenge the candidate more. The added practice exam is a great addition to the course in that sense. Another point is to please look into improving on the captions. Even though I am fluent in English, I like to read the captions when I am uncertain about some words and don't want to replay video sections over and over. Candidates who are not fluent in the language will not be able to rely on the captions to grasp what is being explained in the videos. Overall, I thank you for a great course; it helped me pass the MO-201 exam.
-
VVinnie Dermody
Fantastic course, no way I could have passed my test without it. Covers all main areas covered in the exam. Highly recommended!
