Loader
Course Image
Institution Image

Diploma in Microsoft Excel 2016 (Beginner to Advanced)

Global Edulink

CPD - General Qualifications , Computing Systems

Course Description

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.

Learning with Global Edulink has many advantages. The course material is delivered straight to you, and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months). An effective support service and study materials will build your confidence to secure your qualification.

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

Read More

Course Content

---------- Beginner ----------

Microsoft Excel 2016 Introduction

Module 01: Introduction To Excel

Module 02: Creating A Worksheet

Module 03: Managing Workbooks

Module 04: Formulas And Basic Functions

Module 05: Spreadsheet Presentation

Module 06: Rearranging Data

Module 07: Printing

Exercise Files

---------- Intermediate ----------

Microsoft Excel 2016 Introduction

Module 01: Statistical And Logical Functions

Module 02: Working With Multiple Sheets & Books

Module 03: Sorting, Filtering & Subtotaling Lists

Module 04: Formulas And Basic Functions

Module 05: Charts

Module 06: Using The Worksheet Efficiently

Module 07: Printing Large Spreadsheets

Module 08: The Quick Analysis Button 8

Exercise Files

---------- Advanced ----------

Module 01: Text Functions

Module 02: Date & Time Functions

Module 03: Understanding The Functions

Module 04: Working With Vlookup

Module 05: Match & Index Functions

Module 06: Data Validation

Module 07: Protecting Worksheets & Workbooks

Module 08: Working With Templates

Module 09: Exploring Pivot Tables

Module 10: How To Work With A Macro?

Module 11: Conclusion

---------- Beginner ---------- Microsoft Excel 2016 Introduction Module 01: Introduction To Excel Module 02: Creating A Worksheet Module 03: Managing Workbooks Module 04: Formulas And Basic Functions Module 05: Spreadsheet Presentation Module 06: Rearranging Data Module 07: Printing Exercise...

Read More

 

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.

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.

Assessment Methods

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.

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.

Additional Information

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

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