You have no items in your shopping basket.
We have supported over one million learners to reach their potential through e-learning courses and qualifications using our interactive online learning portal.
Excel 2016 Essentials - Online Training Course - Intermediate Level - CPDUK Accredited.
Welcome to the Mandatory Training Group's online Excel 2016 Essentials training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
You will gain a fundamental understanding of the Excel environment and the ability to complete tasks independently. This online Excel 2016 Essentials training course will help learners know and demonstrate the correct application of the principal features of Excel 2016. You will learn how to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
This online Excel 2016 Essentials training course covers the following modules:
Module One: Create and Manage Worksheets and Workbooks
Module Two: Manage Data Cells and Ranges
Module Three: Create tables
Module Four: Perform operations with formulas and functions
Module Five: Create charts and objects
This online Excel 2016 Essentials training course is suitable for anyone who wants to improve their knowledge of Excel 2016. These skills will enhance the learner’s knowledge and employability opportunities.
This online Excel 2016 Essentials training course can be purchased as an individual course or as part of our integrated Microsoft Office training programs and certification.
The online Excel 2016 Essentials training course is designed for both students who are interested in gaining a broad knowledge of the Excel 2016 application and for experienced word users who wish to undertake a refresher course.
This online Excel 2016 Essentials training course follows the Microsoft Office Specialist (MOS) syllabus, and more, and is the ideal study guide for those wishing to gain the industry-recognised MOS certification.
On completion of this online Excel 2016 Essentials training course, learners will gain a fundamental understanding of the Excel environment and the ability to complete tasks independently. This online Excel 2016 Essentials training course will help learners know and demonstrate the correct application of the principal features of Excel 2016.
Learners will create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
✓ Gain instant access to your course(s) upon purchasing through our website
✓ Login credentials are sent immediately to the customer to the email address provided during the checkout process
✓ We also advise all customers to check their spam and junk mail folders in case your mail server has diverted the email there
✓ Learn at your own pace, at a time and place convenient to your circumstances
✓ Individual learners can access their course material(s) 24/7 for 365 days from the date of purchase
✓ In the case of organisations that order multiple licences for future use, the countdown will start when learners are allocated to the training course(s)
✓ Unlimited attempts to complete end of course assessments
✓ On successful completion, download, print/save quality-assured CPD certificate
✓ Customer service teams interact with clients through email and live chat support
✓ We want you to be completely satisfied with your training. We offer a 14-day money-back guarantee if you are not 100% satisfied
✓ To request a refund, you should email our support team with your receipt stating why you would like to be reimbursed
✓ You, or your learners, must not complete the training to make a valid refund claim. Any courses that have been completed and those with certificates achieved will not be valid for a refund
✓ CPDUK accredited e-learning provider
✓ Ofqual approved training centre (UK qualifications)
✓ Internationally recognised CPD and Ofqual approved certificates
✓ Wide range of courses and qualifications that meet UK legislation and guidelines
✓ Over 500 online courses and programmes that cover multiple sectors
✓ Free blended learning environment for individuals and organisations
✓ Immediate access to online courses and programmes
✓ Highly interactive e-learning portal
✓ Substantial cost reductions (no travel fees and other expenses)
✓ Self-paced online learning
✓ Low carbon footprint through e-learning
✓ Repository of online learning materials and assessments
✓ Fully qualified and experienced trainers, instructors and assessors
✓ Experienced subject matter experts and content developers
✓ Conversion of existing classroom courses to e-learning courses
✓ All training courses meet the latest guidance and best practice recommendations.
To enrol on this e-learning course, please add the course to your basket. From there, you will be redirected to our secure checkout page to complete your booking.
If you are booking the course for someone else, please click the ‘Buy For Others’ button at the upper right hand of this page.
Once your payment has been confirmed, you will receive a booking confirmation email with a receipt. Immediately after purchase, you will receive an email with further instructions and unique login credentials to access your learner account. Next, you will need to follow the instructions and login to your learner account.
Our courses are divided into six units. You can either read or listen to the course materials. At the end of each unit is a ‘knowledge check’ section. This section helps the learners remember what they have learnt.
Our online training courses can be completed on your desktop computer/Mac, laptop, tablet or mobile device. These online courses are easily accessible as long as there is an internet connection.
These online training courses are self-paced. Therefore, learners have full control and flexibility on when they wish to complete the material.
There is no deadline for completion. The course will expire from a learner’s account after 365 days, whether it has been accessed or not.
Yes. All end of course assessments are completed online.
Learners are required to achieve a passing rate of 80% or more to complete the course and gain a CPD certificate.
To obtain your certificate, you need to complete the end of course assessment first. A passing rate of 80% or more is required to gain a CPD certificate.
Obtained certificates can be downloaded from the learner’s profile page.
We want you to be completely satisfied with your training. Thus, we offer a 14-day money-back guarantee if you are not 100% satisfied.To request a refund, you should email our Support Team with your receipt stating why you would like to be refunded. Any courses that have been completed and those with certificates will not be valid for a refund.
Yes, you can access the learning materials from any electronic device that has an internet connection. However, we recommend that you use a desktop or laptop device for the best learning experience. These online courses can also be taken on tablet and mobile devices, such as iPads, iPhone and Android mobile phones.
Obtained certificates can be downloaded from the learner’s profile page.
For the best possible experience, we recommend that learners use Google Chrome, Microsoft Edge, Internet Explorer 11 or Firefox. Please ensure no updates are pending on your browser.
There is no estimated completion time for this course. Learners can study in their own time at their speed. Learners may pause, leave and come back to the system to continue the training at any time.
The CPD hours depend on how long each learner takes to complete the course materials and assessments. Each course will indicate the anticipated completion time. This gives a general indication of the CPD hours for those who are required to submit their continuing professional development hours.