Microsoft Excel Expert 365 Apps and Office 2019

Table of Contents

Microsoft Excel Expert 365 Apps and Office 2019

Audience

The Microsoft Excel Expert 365 Apps and Office 2019, MOS MO-201 certification demonstrates competency in creating, managing and distributing professional spreadsheets for a variety of specialised purposes and situations. The exam covers the ability to customise Excel environments to meet business needs and to enhance productivity. Expert workbook examples include custom templates, multiple-axis financial charts, amortisation tables and inventory schedules. Excel Expert exam vouchers are available from Mouse Training, you need to purchase a voucher before taking the exam.

An individual earning the MOS (Microsoft Office Specialist) certification has approximately 150 hours of instruction and hands-on experience with Excel 365/ Excel 2019 and has proven competency at an industry expert level. They can demonstrate the correct application of the principle features of Excel and can complete tasks independently.

Microsoft Excel Expert 365 Apps and Office 2019 Exams

Microsoft Office Specialist certification MOS MO-201 exams use a performance-based format, testing a candidate’s knowledge, skills and abilities using the Microsoft Excel 365 or Excel 2019 application.

Microsoft Office Specialist (MOS) exam task instructions generally do not include the command name. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the functionality in order to successfully complete the tasks in each of the projects.

The Microsoft Office Specialist MOS exam format incorporates multiple projects, as in previous versions, while using enhanced tools, functions, and features from the latest versions.

Microsoft Excel Expert 365 Apps and Office 2019

Course Materials

Our Excel Expert specialist MOS MO-201 training materials are published by CCI Learning.

CCI Manuals 

Titles include Word Associate MO-100, Word Expert MO-101, Excel Associate MO-200, Excel Expert MO-201, Access Expert MO-500, PowerPoint MO-300, and Outlook Associate MO-400 

These manuals can be purchased from ourselves as part of the official study MOS Excel / Excel 2019 kit or you can buy the manual only – you do not need to attend our courses to purchase these fantastic manuals.

Manuals for other Office versions are available – Office 2010, 2013 and 2016.

Excel Expert Exam Vouchers 

We can supply exam vouchers for Microsoft Excel Expert 365 Apps and Office 2019 MO-201 and they include a thirty day exam retake. You will not have to pay an exam administration fee when you purchase your exam voucher from Mouse Training.

To purchase please complete our voucher order form & self-study kit  

Once your order has been received you will receive an order confirmation and invoice.

Microsoft Excel Expert 365 Apps and Office 2019

 

Vouchers: Our Excel Expert exam vouchers include a thirty day retake option.

Certification Guide: Spiral bound study manuals are Published by CCI Learning. Manual contents are separated into lessons, at completion of each lesson there is a summary and review questions.

Exam kit Microsoft Excel Expert MO-201 includes, exam voucher with a thirty day retake option, Certification Guide and Gmetrix test prep – read more

Vouchers and Exam Kits rates include exam test centre fees.

Sample Manual

Manual Lesson Answers

Microsoft Excel Expert 365 Apps and Office 2019

Microsoft Excel Expert 365 Apps and Office 2019 Exam Format

Microsoft Excel Expert 365 Apps and Office 2019 Online Exams

Microsoft Excel Expert Online Exams. We schedule exams weekly at 11am on Friday’s. Additional online dates can be scheduled on request, Monday to Saturday.

Requirements – PC or MAC, Web browser and Internet connection and an exam voucher. Excel Expert MOS exam vouchers order forms are available on our homepage

Before the exam – Photo ID driving licence or passport and Certiport registration, www.certiport.com

On Exam day – Before your exam you will be sent an exam link via email.

Exam Schedule – Online exam schedule is available on our homepage

Microsoft Excel Expert 365 Apps and Office 2019 Exams In-Person

In-person exams are available at our admin office seven days a week, to book please call or email our team.

Microsoft Excel Expert 365 Apps and Office 2019 Exam Certification

Microsoft Excel Expert 365 Apps and Office 2019

 

Mouse MOS Test Venue

You will need to sit your exam at an authorised test centre. Mouse Training London is a Microsoft Office MOS test centre and we can schedule your exam seven days a week. We accept exam vouchers either purchased from us or other other suppliers.

Testing available online (call for dates) and at our centres.

To Schedule an Exam, please call 020 7920 9500

Microsoft Excel Expert 365 Apps and Office 2019 Course Outline

Accreditation Available: MOS MO-201 Microsoft Excel Expert 365 Apps and Office 2019

Course Duration: 2/3 days, our three day course includes an option to sit the MOS Microsoft Excel Expert 365 Apps and Office 2019 exam MO-201

Course Types: Group bookings and 1-2-1 sessions

Course Location: This Microsoft Excel Expert 365 Apps and Office 2019 exam training course can be delivered either at our London training venue or at your offices.

  • Copy macros between workbooks
  • Reference data in other workbooks
  • Enable macros in a workbook
  • Manage workbook versions
  • Restrict editing
  • Protect worksheets and cell ranges
  • Protect workbook structure
  • Configure formula calculation options
  • Manage comments
  • Configure editing and display languages
  • Use language-specific features
  • Fill cells by using Flash Fill
  • Fill cells by using advanced Fill Series options
  • Create custom number formats
  • Configure data validation
  • Group and ungroup data
  • Calculate data by inserting subtotals and totals
  • Remove duplicate records
  • Create custom conditional formatting rules
  • Create conditional formatting rules that use formulas
  • Manage conditional formatting rules
  • 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 the VLOOKUP, HLOOKUP, MATCH, and INDEX functions
  • Reference date and time by using the NOW and TODAY functions
  • Calculate dates by using the WEEKDAY and WORKDAY functions
  • 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
  • Calculate financial data by using the PMT function
  • Trace precedents and dependents
  • Monitor cells and formulas by using the Watch Window
  • Validate formulas by using error checking rules
  • Evaluate formulas
  • Record simple macros
  • Name simple macros
  • Edit simple macros
  • Create and modify dual axis charts
  • Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst and Waterfall charts
  • Create Pivot Tables
  • Modify field selections and options
  • Create slicers
  • Group Pivot Table data
  • Add calculated fields
  • Format data
  • Create Pivot Charts
  • Manipulate options in existing Pivot Charts
  • Apply styles to Pivot Charts
  • Drill down into Pivot Chart details

MOS Associate & Expert Accreditations

Required Courses for Microsoft Office Specialist Expert – Choose 2

Microsoft Excel Expert 365 Apps and Office 2019
Excel Expert MO-201
Microsoft Excel Expert 365 Apps and Office 2019
Word Expert MO-101
Microsoft Excel Expert 365 Apps and Office 2019
Access Expert MO-500

Required Courses for Microsoft Office Specialist Associate – Choose 3

Microsoft Excel Expert 365 Apps and Office 2019
Outlook Associate MO-400
Microsoft Excel Expert 365 Apps and Office 2019
PowerPoint Associate MO-300
Microsoft Excel Expert 365 Apps and Office 2019
Excel Associate MO-200
Microsoft Excel Expert 365 Apps and Office 2019
Word Associate MO-100
Microsoft Excel Expert 365 Apps and Office 2019
Microsoft Office Specialist Associate
Microsoft Excel Expert 365 Apps and Office 2019
Microsoft Office Specialist Expert
Microsoft Excel Expert 365 Apps and Office 2019
Microsoft Excel Expert 365 Apps and Office 2019
Microsoft Excel Expert 365 Apps and Office 2019