MOS Excel 2019 and 365 Expert

Industry recognised MOS certification

Course Code

DLC022

Do you want to enhance your skills and knowledge on Excel and 365 to further your career? Then this MOS Excel 2019 and 365 Expert course could be perfect for you.

Boost your CV with vital Microsoft Excel skills that employers look for.
Expert knowledge in the advanced aspects of Excel.
Industry recognised MOS certification.
Valuable skills needed for preparing for the MOS exam.
Learn how to create advanced formulas and macros.
Manage advanced charts and tables.
Access to GMetrix range of MOS exam practice questions.
Online Excel course.
Need to have Microsoft Excel 2019.

Course Options	Please choose a course option to see prices	Course Material
Study Options	This course is only available to study online.
Payment Options	Pay Upfront Pay Monthly Pay Monthly is not available in your currency.

Request a call back

Impress your current or future employers with expert skills in Microsoft Excel. This course will help you stand out from other candidates or get you the promotion you need!

For those who use Excel regularly but want a more in depth, expert knowledge in Excel, our MOS Excel 2019 Expert course is perfect to help you understand a more skilled approach to using the programme.

With our comprehensive curriculum, you will learn how to harness the full power of Excel, boosting your productivity and career aspects in today’s data-driven world.

During the course, you will examine managing workbooks, formatting and validating data, performing data analysis, and much more.

Become fully skilled in using Microsoft Excel and choose to sit an exam to receive the full qualification.

Study for this course online and study whenever, wherever you want.

What next?

Upon successful completion of this course, you will able to use it towards your university application. We recommend that you check with your chosen University that they accept this qualification as part of their entry requirements. If after, you’re looking to enhance your IT knowledge even further, take a look at the other IT and computer courses we offer.

Here are some job titles that frequently use Microsoft Excel:

Financial analyst
Sales representative
Data analyst
Marketing professional
Project manager
HR professional
Operations manager
Business analyst
Entrepreneur

Course Duration

Up to 1 year.

Study Hours

Approximately 80 hours.

Course Outcome

You will be exam ready for your MOS Excel Expert exam.

Entry Requirements

You will need to have Microsoft Excel 365 or 2019.

Assessment

Tutor-marked assessments.

Introduction
Managing workbooks
Preparing workbooks for collaboration
Using and configuring language options
Lesson review and quiz
Assignment 1 – workbook options & settings exercises

Introduction
Fill cells based on existing data
Formatting and validating data
Advanced conditional formatting and filtering
Lesson review and quiz
Assignment 2 – custom data formatting exercises

Introduction
Performing logical operations in formulas
Lookup data using functions
Using advanced date and time functions
Performing data analysis
Troubleshooting formulas
Creating and modifying macros
Lesson review and quiz
Assignment 3 – advanced formula exercises

Introduction
Creating and modifying advanced charts
Creating and modifying pivot tables
Managing pivot tables
Create and modifying pivot charts
Lesson review and quiz
Assignment 4 – advanced table and chart exercises
The MOS examination

Course requirements

You must have Microsoft Excel 2019 in order to complete this course. The course covers the use of either Microsoft Excel 2019 or 365 which is a pc version of the software.

It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office which will differ from Mac versions.

Course duration

You will have up to 1 year to complete your course, which allows you to study in as much or as little time as you like. The course will take approximately 80 hours of study time but you don’t have to stick to this.

Study method

Your course will be studied online, through an online training portal so you have access to your course materials all in one place. You will have access to your personal tutor support throughout your course through email, so help is available at any point.

GMetrix Skills Management System is also included in your course, which will allow you to practice for your exam effectively.

Overview of test features

Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
All tests have both a testing and a training mode providing step-by-step help on each question.
Progress at your own pace, save the test to resume later, and return to skipped questions.
Detailed, printable score report highlighting areas requiring further review.

Assessment

For your assignments, you will need to edit and create various Excel files to present your understanding of the course. You will need to submit your assignments online to your tutor. These will be marked and returned to you with feedback.

This course prepares you for the official Microsoft Office Specialist (MOS) Excel Associate MO-201 exam. If you want to take the exam to receive the full official qualification, you will need to book and pay for this separately. They must be sat at a registered Certiport Testing Centre.

Course outcome

On successful completion of this course, students will receive a Certificate of Completion with feedback from their tutor. Students can also apply for the Microsoft Office Specialist (MOS) Excel Expert MO-201 exam.

Progression

Proficiency in Microsoft Office products, and Excel in particular, is increasingly important in today’s competitive business environment and, whether students are currently employed or a job seeker, Microsoft Office Specialist certification proves to employers and prospective employers that they have the necessary skills to become an important member of their team.

Dedicated personal tutor support
Dedicated learner services
GMetrix Skills Management System
Assignment marking and feedback
FREE CV critique service
FREE employability guide to help you impress future employers
FREE XO Student Discounts membership

It's not a problem. We offer a course replacement service, so if you get into trouble and your course pack is lost or damaged, our Student Support Team can provide you with a new set of materials for a one-time additional fee.