MO-201 Complete Techniques for the MOS Excel Expert Exam
MO-201 Complete Techniques for the MOS Excel Expert Exam
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 365/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! The messages and reviews on our other Excel Expert Course for Excel 2016 speak for themselves. Our mission is to make you succeed in passing the MO-201. You can do it with our help!
What you will learn...
Create and Modify Pivot Tables
Create Pivot Tables
Modify Pivot Table Field Selections and Options
Create Slicers for Data Analysis
Group Pivot Table Data
Add Pivot Table Calculated fields
Format Data in Pivot Tables
Create and Modify Pivot Charts
Create Pivot Charts
Manipulate Options in Existing Pivot Charts
Apply Styles to Pivot Charts
Drill Down into Pivot Chart Details
Perform Logical Operations in Formulas
Perform Logical Operations by using Nested Functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR() and NOT() Functions
Look Up Data by using Functions
Look Up Data by using VLOOKUP(), HLOOKUP(), MATCH() and INDEX() Functions
Use Advanced Date and Time Functions
Reference Date and Time by using the NOW() and TODAY() Functions
Calculate Dates by using the WEEKDAY() and WORKDAY() Functions
Perform Data Analysis
Summarise Data from Multiple Ranges by using the Consolidate Feature
Perform What-if Analysis by using Goal Seek and Scenario Manager
Forecast Data by using the AND(), IF() and NPER() Functions
Troubleshoot Formulas
Trace Precedence and Dependence
Monitor Cells and Formulas by using the Watch window
Validate Formulas by using Error Checking rules
Evaluate Formulas
Manage Macros and Workbooks
Create and Modify Simple Macros
Copy Macros Between Workbooks
Reference Data in Other Workbooks
Enable Macros in a Workbook
Manage Workbook Versions
Prepare Workbooks for Collaboration
Restrict Editing
Protect Worksheets and Cell Ranges
Protect Workbook Structure
Configure Formula Calculation Options
Manage Comments
Use and Configure Language Options
Configure Editing and Display Languages
Use Language Specific Features
Advanced AutoFill Options
Fill Cells by using Flash Fill
Fill Cells by using Advanced Fill Series Options
Format and Validate Data
Create Custom Number Formats
Configure Data Validation
Group and Ungroup Data
Calculate Data by Inserting Sub Totals and Totals
Apply Advanced Conditional Formatting and Filtering
Create Custom Conditional Formatting Rules
Create Conditional Formatting Rules That Use Formulas
Manage Conditional Formatting Rules
Here are some recent messages and reviews from our students about our Microsoft Excel 2016 Expert certification courses.....
From Delia
I've covered the Excel Expert syllabus using other courses from LinkedIn and I've also tried the Microsoft books on the subject. This is the most comprehensive coverage of the syllabus for the Excel Expert exam. All of the topics are covered in depth with great examples for getting used to the way the questions are posed in the test. Extremely highly recommended!
From Amanda
"I studied Lynda and took the Excel Expert Exam and made a 389. I regrouped and bought Dave's study material, including the practice exams. I learned so much more material that wasn't covered on Lynda through Dave's videos. I took the exam three weeks after studying Dave's tutorials and passed the exam with a 795."
From Christie
"Dave,
Thanks for the great course! I easily passed the Excel Expert exam a couple weeks ago thanks to the materials covered in your course! The lectures were easy to understand and all of the content from your course very relevant in preparing for the exam.
Cheers!
Christie"
From Aicha
" I just passed the test today with 769 !! :) Just can't be happier. The course is really well structured and helpful especially the exercises at the end of each objective !! Thanks Dave , You did a great Job"
From Branislav
"Very specific and targeted topics. I believe it a must for all who attempt the exam."
From Taylor
I can't post it here but I will show my badge earned in the Facebook group. I've been studying for roughly a month, with basic data entry experience, and a BCIS course I took in highschool. Needless to say I wasn't very well versed in excel to begin with, and now im an Excel Expert. Im always skeptical about what I buy and strive to recommend as little as possible to friends and family through fear of worth. But this course here is incredible and I can't thank Dave enough for the time and effort he put into it. I'm a bit of a talker to, and Dave was able to get back to me with answers regarding questions I had about the Exam in a very timely manner. Regards, Taylor"
Microsoft Excel (365/2019) Expert Certification - Comprehensive lectures, exercises and video solutions.
Url: View Details
What you will 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
Rating: 4.8
Level: All Levels
Duration: 7 hours
Instructor: Dave Murphy
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.
View Sitemap