Excel 2016 Essentials Certificate of Completion

Excel 2016 Essentials

Course

Online

£ 150 VAT inc.

Description

  • Typology

    Course

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    80h

  • Start

    Different dates available

  • Delivery of study materials

    Yes

  • Personal tutor

    Yes

Description

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.

Facilities

Location

Starts

Online

Starts

Different dates availableNow taking bookings

To take into account

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

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Achievements for this centre

2016
2015

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 11 years

Subjects

  • 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.

Call the centre

Excel 2016 Essentials

£ 150 VAT inc.