Excel 2016 Essentials



£ 150 VAT inc.


  • Type


  • Level


  • Methodology


  • Class hours


  • Start date

    Different dates available

  • Delivery of study materials


  • Personal tutor


Excel 2016 Essentials Certificate of Completion

Would you like to learn how to use Excel? Undoubtedly, it would be very useful in your professional life! Emagister presents a course for you to achieve that goal.

This is the Excel 2016 Essentials online course, which is designed for students interested in receiving extensive knowledge of the Excel application and for experienced Excel users who wish to take an update course. The course follows the Microsoft Office Specialist (MOS) curriculum and is the perfect study guide for those who wish to obtain the MOS certification recognized in the industry.

Mastering Microsoft Office products, and Excel in particular, is increasingly important in today's competitive business environment, and whether you're working or looking for work, the Microsoft Office Specialist certification demonstrates to employers and potential employers who have enough skills to become an important Member of your team.

The Excel 2016 Essentials course teaches you everything you need to know about the main components of the Excel 2016 application and is presented in a modern online multimedia format, with the constant support and guidance of your designated course tutor, who is at your as you progress in the program.

Do not miss this learning opportunity. If you are interested in this course, please request more information on the Emagister website.



Start date


Start date

Different dates availableEnrolment now open

About this course

There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2016 to complete the course. Please Note: The course covers the use of Microsoft Excel 2016 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.

On successful completion of this course students will receive our Excel 2016 Essentials Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) 77-727 exam.

Based on the proven "learn-by-example” principle which, as the name implies, provides real-world examples to illustrate a particular topic or technique, the courses are delivered through the Distance Learning Centre's highly-acclaimed on-line training portal via a standard web browser, such as Internet Explorer, Firefox, Chrome, Opera, or Safari. You will also be supported by a personal tutor who is available to provide feedback on your work at any time throughout the period of study.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question


This centre's achievements


All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 13 years


  • Excel
  • Office IT
  • Ms Office
  • MS Excel
  • Microsoft Office
  • Functions
  • Creating Tables
  • Ranges
  • Objects
  • Inserting Data
  • Grouping
  • Inserting Charts
  • Time functions
  • Excel Functions
  • Configuration Options
  • Formatting worksheets
  • Creating A Chart
  • Managing Cells
  • Applying Formulas
  • Modifying A Table
  • Customisation Options
  • Sort A Table
  • Modify Text With Functions
  • Formatting A Chart

Course programme

Lesson 1 - Worksheets & Workbooks

  • Introduction;
  • The Excel 2016 Application;
  • Managing Worksheets & Workbooks;
  • Navigating Worksheets & Workbooks;
  • Formatting Worksheets & Workbooks;
  • Customisation Options;
  • Configuration Options;
  • Lesson Review & Quiz;
  • Assignment 1 - Worksheet & Workbook Exercises.

Lesson 2 - Managing Cells & Ranges

  • Introduction;
  • Inserting Data;
  • Formatting Data;
  • Ordering & Grouping;
  • Applying Formulas;
  • Lesson Review & Quiz;
  • Assignment 2 - Cell & Range Exercises.

Lesson 3 - Managing Tables

  • Introduction;
  • Creating Tables;
  • Modifying A Table;
  • Filter & Sort A Table;
  • Pivot Tables & Charts;
  • Lesson Review & Quiz;
  • Assignment 3 - Table Exercises.

Lesson 4 - Excel Functions

  • Introduction;
  • Summarise Data With Functions;
  • Use Conditional Logic In Functions;
  • Format & Modify Text With Functions;
  • Useful Maths Functions;
  • Date & Time Functions;
  • Lesson Review & Quiz;
  • Assignment 4 - Function Exercises.

Lesson 5 - Inserting Charts & Objects

  • Introduction;
  • Creating A Chart;
  • Formatting A Chart;
  • Working With Objects;
  • Lesson Review & Quiz;
  • Assignment 5 - Charts & Object Exercises;
  • The MOS Examination Explained.

Additional information

Exam Centres will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.

Excel 2016 Essentials

£ 150 VAT inc.