MOS Excel 2019 and 365 Associate

Course code: DLC021
Idustry recognised MOS certification

For those looking to get to grips with the latest version of Microsoft Excel, get a certification that proves your competence…

Boost your CV with vital Microsoft Office skills that employers look for
Broad knowledge of the latest version of Microsoft Excel
Industry recognised MOS certification
Provides you with necessary skills needed to show competence in Excel
Valuable skills needed for preparing for the MOS exam
Access to GMetrix range of MOS exam practice questions
Learn for your course online
Ensure you have a version of 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

If you’re looking to get to grips with the latest version of Microsoft Excel and perhaps need it for your job role to prove your competence, our Microsoft Excel 2019 365 Associate course can help you stand out!

Learn how to manipulate data in worksheets, perform operations using tables and understand how to manage charts and objects.

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

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 Associate exam.

Entry Requirements

You will need to have Microsoft Excel 365 or 2019.

Assessment

Tutor marked assignments.

Unit 1

Managing Worksheets and Workbooks

Introduction
The Excel Application
Managing Worksheets & Workbooks
Navigating Worksheets & Workbooks
Formatting Worksheets & Workbooks
Customisation Option & Views
Configuring Content For Collaboration
Lesson Review & Quiz
Assignment 1 – Worksheet & Workbook Exercises

Unit 2

Managing Data Cells and Ranges

Introduction
Manipulating Data in Worksheets
Formatting Cells & Ranges
Summarising Data Visually
Applying Formulas
Lesson Review & Quiz
Assignment 2 – Data Cell & Range Exercises

Unit 3

Managing Tables and Table Data

Introduction
Creating & Formatting Tables
Modifying Tables
Filtering & Sorting Table Data
Introducing Pivot Tables & Charts
Lesson Review & Quiz
Assignment 3 – Table Exercises

Unit 4

Perform Operations Using Functions

Introduction
Inserting References
Calculating & Transforming Data
Using Conditional Logic In Functions
Formatting & Modifying Text With Functions
Introducing Maths Functions
Introducing Date & Time Functions
Lesson Review & Quiz
Assignment 4 – Function Exercises

Unit 5

Managing Charts and Objects

Introduction
Creating & Modifying Charts
Formatting Charts
Working With Objects
Lesson Review & Quiz
Assignment 5 – Charts & Object Exercises
The MOS Examination Explained

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.

Course Duration

You will have up to 1 year to complete your course. The course study time should take approximately 80 hours, so 1 year will allow flexible learning. You can complete your course in as little or as much time as you like.

Study Method

Your course will be studied online, so you have access to your course materials through an online training portal. 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

Your assignments will involve you working on, editing and creating 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.

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

You will receive a certificate of completion with feedback from your tutor. You will also be exam ready, so you’ll be able to apply to sit the Microsoft Office Specialist Excel Associate 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 you have the necessary skills to become an important member of their team.

Do I have to sit an exam?

If you want to receive the full official certification, you will need to sit an exam. This will need to be booked and paid for separately by you. Examinations must be sat at a registered Certiport Testing Centre.

What’s included in the cost of my course?

Dedicated personal tutor support
Dedicated student support
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 card

Are there any additional costs?

If you want to sit the exam, this will need to be booked and paid for separately by you.

What if I still have questions?

That's not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Adviser Team a call on 03300 563 100 and they’ll do their best to help.