MO-200 Microsoft Excel 365/2019 Associate Certification from Udemy

New. Udemy for Business Students

Please note that our course entitled MO-200 Excel Associate Practice Tests and Video Solutions is now available to supplement your learning path to success in the MO-200 Certification exam. This course has an additional two practice exams together with video solutions to allow you to ensure your certification at the first attempt. Just search for MO-200 and you should see it listed.

NEW. Complete MO-200 Practice Exam and Video Solution Added

The course now includes a Practice Exam and Video Solution. The exam has 6 individual projects with 5 or 6 tasks per project. Video solutions are provided for every task. As MOS Examiners and University Lecturers we really know what is required to pass at the 1st attempt. These practice exam projects are set to the standard and style of the exam and will ensure that you are completely familiar with the style and terminology used in the actual MO-200 exam.

Reviews Update 1 - Two Students scores 1000/1000 in MO-200 exam.

"I like having multiple project tasks to be able to complete/practice; with a good variety in questions. Its also extremely helpful to my learning to then to be able to watch the video solutions after. Update: I took the certification exam and scored 1000/1000. Using this course, I was completely prepared for the questions. Definitely recommend."

"Hi Dave,

Just wanted to say a quick thank you as I've just completed the MO-200 exam with 1000/1000. I had been putting the training and exam off for far too long but eventually found the time to complete it and am incredibly pleased having done so at last. Your course is brilliant and gave me absolutely everything I needed for the exam as well as some great new techniques I can use on a daily basis at work.

Thanks again,

Danny"

Reviews Update 2 - Student wins UK & Ireland MOS Excel Championship. Qualifies for World Championship.

One of our students has completed against 30,000 other competitors to win the UK & Ireland MOS Championship in Excel. She will now go on to compete in the World Championship in November. This is a major achievement and we are proud to have been part of this students preparation and success.

The above level of achievement doesn't happen without effort and the correct preparation. Our instructors REALLY know what is required if you are to succeed in your MOS exam at the 1st attempt. Don't risk your exam fees. MOS University will make sure that you have the best possible chance to obtain these valuable certifications. Our expert instructors are all MOS Masters and University Professors with many years experience in preparing students to take MOS exams. Up to date materials, expert tuition, focused exercises and sample exam questions will all ensure that your pathway to success is assured.

Microsoft Office Specialist (MOS)

The Microsoft Office Specialist: Excel Associate Certification 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-200 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-200 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-200 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-200 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-200 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 objective domain for the MO-200 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.

We have also provided a COMPLETE practice exam set to the standard of the MO-200. This will ensure that on the day of the exam you will be fully confident that your preparation is complete and that you are FULLY ready to get that certification.

When you pass the MO-200 exam, Microsoft issue you with the MOS, or 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-200 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 Objective Domain is 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/2019.

What's inside

Learning objectives

How to successfully pass the mo-200 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/2019
Guarantee potential employers of your competence in microsoft excel 365/2019

How to successfully pass the mo-200 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/2019
Guarantee potential employers of your competence in microsoft excel 365/2019

Syllabus

Introducing the Excel User Interface

Essential Navigation Skills

Introduction

Explains what the Microsoft Office Specialist programme is and why it is an important certification.

Note that if you are registered as a 'Udemy for Business' student make sure to check out our MO-200 Practice Exams and Video Solutions course which will provide you with additional practice opportunities.

Explains the Objective Domain for the exam, and why it is so important that you are familiar with it and use it to monitor your progress in the course.

Please note that remote testing arrangements have been established in most countries. See the last two links for interim testing arrangements.

Try It Yourself Exercises

Introducing the Microsoft Excel User Interface

Entering Information

1.1 Import Data into Workbooks

See Part 2 for TIY Exercises

1.1.1 and 1.1.2 (Part 2) Import Data from .txt and .csv Files

1.2 Navigate Within Workbooks

1.2.1 and 1.2.2 Search for Data within a Workbook

This brief lecture explains the difference between comments and notes in respect of Excel 365 compared to Excel 2019.

1.2.3 Insert and Remove hyperlinks

1.3 Format Worksheets and Workbooks

1.3.1 Modify Page Setup

1.3.2 Adjust Row Height and Column Width

1.3.3 Customise Headers and Footers

1.4 Customise Options and Views

1.4.1 Customise the Quick Access Toolbar

1.4.2 Display and Modify Workbook Content in different Views

1.4.3 Freeze Worksheet Rows and Columns

1.4.4 Change Window Views

1.4.5 Modify Basic Workbook Properties

1.4.6 Display Formulas

1.5 Configure Content for Collaboration

1.5.1. Set a Print Area

1.5.2 Save Workbooks in Alternative File Formats

1.5.3 Configure Print Settings

1.5.4 Inspect Workbooks for Issues

Manage Worksheets & Workbooks Exam Seminar

This is a recording of the first in a series of 5 seminars aimed at preparing students for the Microsoft Excel Associate (MO-200) & Core (77-727) exams. Check out the Bonus Lecture (last section of the course) for details on the seminar series and how you can access all 5 seminars. In this seminar we focused on the Manage Worksheets & Workbooks section of the Skills Measured by Microsoft.

2.1 Manipulate Data in Worksheets

2.1.1 Paste Data by Using special Paste Options

2.1.2 Fill Cells by using Auto Fill

Some extra clarification on fill series.

2.1.3 and 2.1.4 Insert and Delete Multiple Columns, Rows and Cells

2.2. Format Cells and Ranges

See 2.2.4 for TIY Exercises

Project 1 Solution

2.2.4 Wrap Text Within Cells

2.2.5 Apply Number Formats

See 2.2.7 for TIY Exercises

2.2.7 Apply Cell Styles

2.2.8 Clear Cell Formatting

2.3 Define and Reference Named Ranges

See 2.3.2 for TIY Exercises

2.3.2 Name a Table

2.4 Summarise Data Visually

2.4.1 Insert Sparklines

2.4.2 Apply Built-in Conditional Formatting

2.4.3 Remove Conditional Formatting

3.1 Create and Format Tables

3.1.1 & 3.1.3 Create Excel Tables and Convert Tables from and to Cell Ranges

See 3.2.1 For TIY Exercises

3.2 Modify Tables

3.2.1 Add or Remove Tables Rows and Columns

3.3 Filter and Sort Table Data

3.3.1 Filter Records

3.3.2 Sort Data by Multiple Columns

4.1 Insert References

See Part 2 for TIY Exercises

4.1.1 (Part 2) Insert Relative, Absolute and Mixed References

4.1.2 Reference Named Ranges and Named Tables in Formulas

4.2 Calculate and Transform Data

See 4.2.2 for TIY Exercises

4.2.2 Count Cells using the COUNT(), COUNTA() and COUNTBLANK() functions

4.2.3 Perform Conditional Operations by using the IF() Function

4.3 Format and Modify Text

See 4.3.3 for TIY Exercises

4.3.3 Format Text by using the CONCAT() and TEXTJOIN() Functions

5.1 Create Charts

See 5.1.2 for TIY Exercises

5.1.2 Create Chart Sheets

5.2 Modify Charts

See 5.2.3 For TIY Exercises

5.2.3 Add and Modify Chart Elements

5.3 Format Charts

5.3.1 and 5.3.2 Apply Chart Layouts and Styles

5.3.3 Add Alternative Text to Charts for Accessibility

Special Lecture RANDBEWEEN() Function

These functions are not on the MO-200 syllabus but it has been reported to me that the RANDBETWEEN() function has appeared as a task. Review the lecture ......just in case, and if a task does appear in your test which requires either of these functions report it at the end.

MO-200 Practice Exam

This lecture explains how to download and use the practice exam file. This practice exam is one of three which are available in our MO-200 Practice Exams and Video Solutions courses. So if you want the other two you will find them on MOS University or on Udemy. Remember that if you purchase any course on the MOS University site you will be eligible to access all of our Exam Prep Seminars. These are currently available for the MO-200 and 77-727 Exams and we plan to provide seminars on Excel Expert, Word Associate/Core and Word Expert in the near future.

Project 2 Solution

Project 3 Solution

Project 4 Solution

Project 5 Solution

Project 6 Solution

Solutions to Course Exercises

Objective Domain 1.1

Objective Domain 1.2

Objective Domain 1.3

Objective Domain 1.4

Objective Domain 1.5

Objective Domain 2.1

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Mirrors the structure and style of the MO-200 exam, familiarizing learners with the exam's format and terminology, which reduces test anxiety and improves performance

Includes practice exams with video solutions, which allows learners to self-assess their knowledge and identify areas for improvement before taking the actual certification exam

Covers every element of the MO-200 exam objective domain, ensuring learners receive comprehensive instruction on all topics tested in the certification exam

Provides advice from seasoned professionals on how to prepare for the test, which helps learners develop effective study habits and test-taking strategies

Requires learners to have access to Microsoft Excel 365/2019, which may require a purchase or subscription if learners do not already have access

Includes material that is specific to the MO-200 exam, so learners should be aware that the content may not be as broadly applicable to other areas of Excel

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MO-200 Microsoft Excel 365/2019 Associate Certification with these activities:

Review Excel Fundamentals

Show steps

Solidify your understanding of fundamental Excel concepts before diving into the MO-200 specific material. This will make learning advanced topics easier.

Browse courses on Excel Basics

Show steps

Review basic Excel terminology and interface elements.
Practice entering and formatting data in a worksheet.
Familiarize yourself with basic formulas and functions.

Practice Data Importing and Exporting

Show steps

Reinforce your ability to import and export data in various formats. This is a key skill tested in the MO-200 exam.

Show steps

Import data from .txt and .csv files into Excel.
Export Excel data to different file formats.
Practice cleaning and transforming imported data.

Read 'Excel Formulas and Functions'

Show steps

Deepen your understanding of Excel formulas and functions to enhance your data analysis skills. This will help you solve complex problems and automate tasks.

View Microsoft Excel Formulas and Functions (Office... on Amazon

Show steps

Study different categories of Excel functions.
Practice using formulas to perform calculations and data manipulation.
Explore advanced formula techniques such as array formulas.

Three other activities

Expand to see all activities and additional details

Show all six activities

Create a Personal Budget Spreadsheet

Show steps

Apply your Excel skills to a real-world scenario by creating a personal budget spreadsheet. This will help you internalize the concepts learned in the course.

Show steps

Design a spreadsheet to track income and expenses.
Use formulas to calculate totals and balances.
Create charts to visualize spending patterns.

Read 'Microsoft Excel 2019 Bible'

Show steps

Expand your knowledge of Excel features and functionalities beyond the scope of the MO-200 exam. This will provide a more complete understanding of the software.

View Putting Knowledge to Work on Amazon

Show steps

Read chapters related to data analysis and visualization.
Experiment with advanced formulas and functions.
Explore different chart types and customization options.

Develop an Interactive Dashboard

Show steps

Create an interactive dashboard to showcase your Excel skills and data visualization abilities. This project will solidify your understanding of charts, tables, and data manipulation techniques.

Show steps

Identify a dataset suitable for creating a dashboard.
Design the layout and structure of the dashboard.
Implement interactive elements such as slicers and filters.
Present the dashboard to an audience and gather feedback.

Career center

Learners who complete MO-200 Microsoft Excel 365/2019 Associate Certification will develop knowledge and skills that may be useful to these careers:

Data Analyst

A data analyst uses programs like Excel to interpret numerical data and identify trends. This course provides a clear path to developing crucial skills for a data analyst, such as creating tables, applying formulas, and creating charts to visually represent data. The course's focus on practical exercises and exam-style questions directly translates to the real-world data manipulation and analysis that a data analyst performs every day. This course will help you build a foundation in Excel, a vital tool for this role.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial analysts use financial data to provide guidance to companies and individuals. The skills taught in this course, such as using formulas, creating charts, and managing worksheets and workbooks, are all directly applicable to the work of a financial analyst. This course's emphasis on creating professional-looking budgets and financial statements makes it a valuable resource for aspiring analysts. The training in Excel offered by this course will help develop a needed skill to succeed in any financial role.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business analysts use data to improve processes, products, services, and software. The techniques, skills, and knowledge taught in this course, such as data import, data manipulation, and data visualization, are all essential for a business analyst. The course provides a deep understanding of how Excel can be used to analyze and present data; the same skills this role uses every day. This course may be helpful in building analytical skills which one will need in this role.

See salaries and explore the career path for Business Analyst

Sales Analyst

Sales analysts examine sales data to improve a company's sales performance. Sales analysts often use Excel to track sales, analyze trends, and create sales reports. The skills taught in this course, particularly creating tables, applying formulas, and creating charts, are directly applicable to the daily work of a sales analyst. The practice exercises in this course will help build a foundation in excel; a vital tool for a sales analyst.

See salaries and explore the career path for Sales Analyst

Junior Consultant

Junior consultants assist senior consultants and work on data collection, analysis, and presentation. Junior consultants often use Excel to analyze data, create reports, and develop presentations. The skills developed in this course, including data import, data manipulation, and data visualization, are helpful for junior consultants. This course may help develop the necessary skills for a junior consultant.

See salaries and explore the career path for Junior Consultant

Market Research Analyst

Market research analysts study market conditions to examine the potential sales of a product or service. This role relies heavily on data analysis and the ability to present findings visually. This course will be helpful to a market research analyst. These analysts use Excel to organize and analyze data, create charts to visualize trends, and manage workbooks for large data sets. This course, with its emphasis on practical Excel skills, can help develop the foundation for this job.

See salaries and explore the career path for Market Research Analyst

Accountant

Accountants prepare and examine financial records. The accounting profession regularly uses Excel for preparing financial reports and statements, tracking financial data, and performing reconciliations. This course, with its focus on creating professional-looking financial statements and using formulas, may be helpful for an aspiring accountant. This course will help build proficiency with the software that accountants use on a daily basis.

See salaries and explore the career path for Accountant

Auditor

Auditors examine financial records to verify their accuracy. Auditors use Excel to analyze financial data, prepare audit reports, and track financial information. This course will assist those who wish to become auditors. The course's focus on using formulas and managing workbooks may be useful for a perspective auditor.

See salaries and explore the career path for Auditor

Logistics Coordinator

Logistics coordinators oversee the transportation and storage of goods. These professionals utilize Excel to track inventory, schedule deliveries, and analyze logistics data. This course may be helpful for aspiring logistics coordinators. The skills taught in this course, such as managing worksheets, using formulas, and creating tables, are relevant to the work of a logistics coordinator. This course will assist in becoming proficient in the software.

See salaries and explore the career path for Logistics Coordinator

Project Coordinator

Project coordinators oversee project tasks to ensure projects are completed on schedule. The organizational and data management skills taught in this course are relevant to a project coordinator. Project coordinators will use Excel to track project timelines, manage budgets, and creating team performance charts. This course may be useful to learn the skills needed to be a succesful project coordinator.

See salaries and explore the career path for Project Coordinator

Administrative Assistant

Administrative assistants perform clerical and administrative duties and often use Excel for data entry, scheduling, and creating basic reports. This course, which covers essential Excel skills such as managing worksheets, formatting cells, and using basic formulas, may be helpful. The course's practical exercises and focus on using charts to represent data visually make this a good starting point for an administrative assistant to develop spreadsheet skills.

See salaries and explore the career path for Administrative Assistant

Operations Analyst

Operations analysts use data to improve an organization's efficiency. This role requires a strong understanding of spreadsheet software, and this course will be helpful to develop those skills. An operations analyst must use data to understand and analyze all aspects of a business's processes; this course helps provide the necessary excel skills that this role requires. This course may be a useful resource.

See salaries and explore the career path for Operations Analyst

Inventory Specialist

Inventory specialists are responsible for tracking and managing a company's inventory of products. These professionals utilize Excel for tracking stock levels, analyzing inventory data, and creating reports. The skills taught in this course, such as using tables, formulas, and charts, are applicable to the daily work of an inventory specialist. This course may be useful to develop necessary excel skills.

See salaries and explore the career path for Inventory Specialist

Research Assistant

Research assistants often collect, manage, and analyze data as part of their work. This course may be useful for research assistants. This role often uses Excel to organize and format data, perform calculations, and create charts to visualize findings. The course's emphasis on managing workbooks, using formulas, and creating charts and tables makes it a great resource for aspiring research assistants. This course may be valuable for a research assistant.

See salaries and explore the career path for Research Assistant

Human Resources Specialist

Human resources specialists manage employee data, compensation, and benefits. This position often utilizes Excel to maintain employee records, analyze compensation data, and create reports. This course provides foundational skills in Excel, which may be valuable for professionals in this role. The course's emphasis on managing worksheets and using formulas may help someone seeking to enter this field.

See salaries and explore the career path for Human Resources Specialist

MO-200 Microsoft Excel 365/2019 Associate Certification

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses