Show e-learning-courses.co.uk as: Mobile

Diploma in Microsoft Excel 2016 (Beginner to Advanced) - Accredited by CPD

Global Edulink
Course summary
Length: 14 hours
Price: 49 GBP excl. VAT
Language: English
Location: Distance
Next available date: This course is available to purchase anytime of the year. - Distance
Last application: This course is available to register anytime of the year.
Course type: e-learning / Online / Distance

Course description

Diploma in Microsoft Excel 2016 (Beginner to Advanced) - Accredited by CPD

Created by a highly skilled professional, this bundle will guide learners through Microsoft Excel 2016. The bundle consists of our Microsoft Excel 2016 Introduction, Microsoft Excel 2016 Beginner, and Microsoft Excel 2016 Advanced courses, so if you want to become an advanced user, this bundle is for you. Buying all three courses at the same time is a cheaper option, so to save money get them in a bundle format, and you’ll be on your way to becoming an Excel genius.

This bundle will provide you with a full introduction to Excel, so you’ll be able to navigate it with total ease. Then move onto the intermediate level functions of Microsoft Excel, such as creating tables, conditional formatting, and the quick analysis button. Finally, you’re ready to study the advanced level functions of Microsoft Excel, such as data validation, slicers and timelines, and running macros.

This bundle consists of the following courses:

  • Microsoft Excel 2016 Introduction
  • Microsoft Excel 2016 Intermediate
  • Microsoft Excel 2016 Advanced

Suitability - Who should attend?

Who is it for?

This course is introduction level, so will be suitable for those who have never used Excel before, or who would like an introduction to the programme.

Entry Requirements:

Learners on this course must be over the age of 16 and should have a basic grasp of English, Maths and ICT. In addition you will need Microsoft Excel 2016 installed onto your computer / laptop / tablet.

Outcome / Qualification etc.

Learners who successfully complete this course will be awarded a Microsoft Excel 2016 Beginner to Advanced.

Training Course Content

Course Description:

This online training course is comprehensive and designed to cover the topics listed under the curriculum.

Method of Assessment:

At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Course Curriculum

---------- BEGINNER ----------

MICROSOFT EXCEL 2016

INTRODUCTION

01.

  • Introduction to Excel

02.

  • Creating a worksheet

03.

  • Managing workbooks

04.

  • Formulas and basic functions

05.

  • Spreadsheet presentation

06.

  • Rearranging data

07.

  • Printing

EXERCISE FILES

---------- INTERMEDIATE ----------

MICROSOFT EXCEL 2016

INTRODUCTION

01.

  • Statistical And Logical Functions

02.

  • Working With Multiple Sheets & Books

03.

  • Sorting, Filtering & Subtotaling Lists

04.

  • Conditional Formatting

05.

  • Module Five – Charts

06.

  • Using The Worksheet Efficiently

07.

  • Printing Large Spreadsheets

08.

  • The Quick Analysis Button 8

EXERCISE FILES

---------- ADVANCED ----------

01.

  • Text Functions

02.

  • Date & Time Functions

03

  • Recap
  • Nested IF with =MAX() Function
  • Max & Ifs – & And & OR Using If Function
  • Nested IF with multiple Ifs
  • IF functions with =AND() & =OR() functions

04.

  • VLOOKUP To find the nearest match
  • VLOOKUP To find an exact match

05.

  • MATCH & INDEX Functions

06.

  • Data Validation

07.

  • Protecting Worksheets & Workbooks

08.

  • Working With Templates

09.

  • Creating, rearranging and updating a Pivot Table
  • Filtering and grouping data in a Pivot Table
  • Slicers and timelines
  • Creating a Pivot chart

10.

  • Recording a macro in a macro-enabled workbook (using relative references)
  • Running a macro and assigning it to objects
  • Editing and deleting a macro

11.

  • Conclusion

EXERCISE FILES

  • Exercise Files – Microsoft Excel 2016 Advanced

Benefits you will gain:

By enrolling in to this course, you’ll get:

  • High quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • Includes step-by-step tutorial videos and an effective, professional support service.
  • 24/7 Access to the Learning Portal.
  • Benefit of applyingNUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Access Course Content on Mobile, Tablet or Desktop.
  • Study in a user friendly, advanced online learning platform.
  • Excellent customer service and administrative support.

Expenses

Now £49

Was £249

About provider

Global Edulink Training - together, shaping your future

Global Edulink - together, shaping your future

Global Edulink is an established provider for professional skills training in the United Kingdom. Courses are designed for a wide audience of professionals seeking A-Level training in education, IT, security, English language and office administration. Global Edulink training courses focus on...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Diploma in Microsoft Excel 2016 (Beginner to Advanced) - Accredited by CPD.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award 2019

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact info

Global Edulink

28, Leman Street
E1 8ER London

 Show phone number
globaledulink.co.uk

Request Information

Find out more about this Diploma in Microsoft Excel 2016 (Beginner to Advanced) - Accredited by CPD course - simply fill out your details: