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.
MOS Excel 2019 and 365 Expert
DLC022Up to £200 off all courses! Ends in
Buy now, pay later
Pay monthly options available in checkout.
Course overview
- 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.
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 content
- 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
Extra Information
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.
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.
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.
Approximately 80 hours.
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.
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.
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.
FAQs
If you want to receive the full official qualification, 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.
- 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
If you want to sit the exam, this will need to be booked and paid for separately by you.
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 team of education specialists a call on 03300 563 100 and they'll do their best to help.
Related courses
- SALE!
MOS Word 2019 and 365 Expert
Single Course
DLC024 - SALE!
MOS Access 2019 and 365 Expert
Single Course
DLC026 - SALE!
MOS Powerpoint 2019 and 365 Associate
Single Course
DLC027