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.
Course Content
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
Who is this course for?
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.
Course aims
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.
Learning outcomes
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.
Access 2016 Essentials - Online Training Course - Intermediate Level - CPDUK Accredited. Welcome to The Mandatory Training Group's online Access 2016 Essentials training course. All our online training courses,...
Creating a Great Webinar – Online Training Course – Intermediate Level - CPDUK Accredited. Welcome to The Mandatory Training Group's online Creating a Great Webinar training course. All our online...
Cyber Security – Online Training Course – Intermediate Level - CPDUK Accredited. Welcome to The Mandatory Training Group's Cyber Security online training course for all sectors. All our online training...
Digital Citizenship – Online Training Course – Intermediate Level - CPDUK Accredited. Welcome to The Mandatory Training Group's online Digital Citizenship training course. All our online training courses, programmes and...
Excel 2016 Expert - Online Training Course - Intermediate Level - CPDUK Accredited. Welcome to the Mandatory Training Group's online Excel 2016 Expert training course. All our online training courses, programmes and...
Outlook 2016 Essentials - Online Training Course - Intermediate Level - CPDUK Accredited. Welcome to the Mandatory Training Group's online Outlook 2016 Essentials training course. All our online training courses, programmes...
PowerPoint 2016 Essentials - Online Training Course - Intermediate Level - CPDUK Accredited. Welcome to the Mandatory Training Group's online PowerPoint 2016 Essentials training course. All our online training courses,...
The Cloud and Business – Online Training Course – Intermediate Level - CPDUK Accredited. Welcome to The Mandatory Training Group's online The Cloud and Business training course. All our online...