MOS Excel 2019 and 365 Expert

Course code: DLC022
Industry recognised MOS certification

For those who want to advanced knowledge of using Microsoft Excel, this course teaches all you need to know about the components of Excel…

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.

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.

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 & Quiz
Assignment 1 – Workbook Options & Settings Exercises

Introduction
Fill Cells Based on Existing Data
Formatting & Validating Data
Advanced Conditional Formatting & Filtering
Lesson Review & Quiz
Assignment 2 – Custom Data Formatting Exercises

Introduction
Performing Logical Operations in Formulas
Lookup Data Using Functions
Using Advanced Date & Time Functions
Performing Data Analysis
Troubleshooting Formulas
Creating & Modifying Macros
Lesson Review & Quiz
Assignment 3 – Advanced Formula Exercises

Introduction
Creating & Modifying Advanced Charts
Creating & Modifying Pivot Tables
Managing Pivot Tables
Create & Modifying Pivot Charts
Lesson Review & Quiz
Assignment 4 – Advanced Table & 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 own pace, save test to resume later, 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.