Overview:
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.
This bundle consists of the following courses:
- Microsoft Excel 2016 Introduction
- Microsoft Excel 2016 Intermediate
- Microsoft Excel 2016 Advanced
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.
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.
Certification:
Learners who successfully complete this course will be awarded a Microsoft Excel 2016 Beginner to Advanced.
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.
PLEASE NOTE: We do not provide any software with this course, please acquire Microsoft Excel 2016 before you undertake the course.
Career Path:
As Excel is so widely used this course provides transferable skills that will be useful in a wide range of job roles, and could help you land your next job, or get a pay rise. The qualification will be of particular interest to anyone hoping to work in administration, accounting or bookkeeping.
Course Curriculum
| ---------- Beginner ---------- | |||
| MICROSOFT EXCEL 2016 INTRODUCTION | |||
| Microsoft Excel 2016 Introduction | 00:00:00 | ||
| Module 01: Introduction to Excel | |||
| Module One – Introduction to Excel | 00:00:00 | ||
| Module 02: Creating a worksheet | |||
| Module Two – Creating a worksheet | 00:00:00 | ||
| Module 03: Managing workbooks | |||
| Module Three – Managing workbooks | 00:00:00 | ||
| Module 04: Formulas and basic functions | |||
| Module Four – Formulas and basic functions | 00:00:00 | ||
| Module 05: Spreadsheet presentation | |||
| Module Five – Spreadsheet presentation | 00:00:00 | ||
| Module 06: Rearranging data | |||
| Module Six – Rearranging data | 00:00:00 | ||
| Module 07: Printing | |||
| Module Seven – Printing | 00:00:00 | ||
| EXERCISE FILES | |||
| Exercise Files_Excel 2016 | 00:00:00 | ||
| ---------- Intermediate ---------- | |||
| MICROSOFT EXCEL 2016 INTRODUCTION | |||
| Microsoft Excel 2016 Intermediate – Introduction | 00:00:00 | ||
| Module 01: Statistical And Logical Functions | |||
| Module One – Statistical And Logical Functions | 00:00:00 | ||
| Module 02: Working With Multiple Sheets & Books | |||
| Module Two – Working With Multiple Sheets & Books | 00:00:00 | ||
| Module 03: Sorting, Filtering & Subtotaling Lists | |||
| Module Three – Sorting, Filtering & Subtotaling Lists | 00:00:00 | ||
| Module 04: Formulas and basic functions | |||
| Module Four – Conditional Formatting | 00:00:00 | ||
| Module 05: Charts | |||
| Module Five – Charts | 00:00:00 | ||
| Module 06: Using The Worksheet Efficiently | |||
| Module Six – Using The Worksheet Efficiently | 00:00:00 | ||
| Module 07: Printing Large Spreadsheets | |||
| Module Seven – Printing Large Spreadsheets | 00:00:00 | ||
| Module 08: The Quick Analysis Button 8 | |||
| Module Eight – The Quick Analysis Button 8 | 00:00:00 | ||
| EXERCISE FILES | |||
| Exercise Files – Microsoft Excel 2016 Intermediate | 00:00:00 | ||
| ---------- Advanced ---------- | |||
| Module 01: Text Functions | |||
| Module 1 – Text Functions | FREE | 00:36:58 | |
| Module 02: Date & Time Functions | |||
| Module 2 – Date & Time Functions | 00:28:38 | ||
| Module 03: Understanding the functions | |||
| Module 3 – Part 1 – Recap | 00:01:44 | ||
| Module 3 – Part 2 – Nested IF with =MAX() Function | 00:07:14 | ||
| Module 3 – Part 3 – Max & Ifs – & And & OR Using If Function | 00:05:38 | ||
| Module 3 – Part 4 – Nested IF with multiple Ifs | 00:06:26 | ||
| Module 3 – Part 5 – IF functions with =AND() & =OR() functions | 00:09:06 | ||
| Module 04: Working with VLOOKUP | |||
| Module 4 – Part 1 – VLOOKUP To find the nearest match | 00:09:40 | ||
| Module 4 – Part 2 – VLOOKUP To find an exact match | 00:17:04 | ||
| Module 05: MATCH & INDEX Functions | |||
| Module 5 – MATCH & INDEX Functions | 00:21:36 | ||
| Module 06: Data Validation | |||
| Module 6 – Data Validation | 00:12:14 | ||
| Module 07: Protecting Worksheets & Workbooks | |||
| Module 7 – Protecting Worksheets & Workbooks | 00:07:58 | ||
| Module 08: Working With Templates | |||
| Module 8 – Working With Templates | 00:09:55 | ||
| Module 09: Exploring Pivot Tables | |||
| Module 9 – Part 1 – Creating, rearranging and updating a Pivot Table | 00:17:51 | ||
| Module 9 – Part 2 – Filtering and grouping data in a Pivot Table | 00:15:46 | ||
| Module 9 – Part 3 – Slicers and timelines | 00:11:11 | ||
| Module 9 – Part 4 – Creating a Pivot chart | 00:12:30 | ||
| Module 10: How to work with a Macro? | |||
| Module 10 – Part 1 – Recording a macro in a macro-enabled workbook (using relative references) | 00:11:12 | ||
| Module 10 – Part 2 – Running a macro and assigning it to objects | 00:06:35 | ||
| Module 10 – Part 3 – Editing and deleting a macro | 00:11:37 | ||
| Module 11: Conclusion | |||
| Module 11 – Conclusion | 00:01:16 | ||
| EXERCISE FILES | |||
| Exercise Files – Microsoft Excel 2016 Advanced | 00:00:00 | ||
| Mock Exam | |||
| Mock: Diploma in Microsoft Excel 2016 (Beginner to Advanced) | 01:00:00 | ||
| Final Exam | |||
| Exam: Diploma in Microsoft Excel 2016 (Beginner to Advanced) | 01:00:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
ACCREDITED CERTIFICATE
Buy with Confidence
Accredited by CPD & iAP
CPD Membership No: 10582
Study independently accredited and recognised CPD courses. Gain your certification today
All students enrolled with Global Edulink are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.
MORE INFO
If you need career support Global Edulink is here for you. We provide excellent career support through our Career Support Service.
MORE INFO
NUS Extra Card
Every student of Global Edulink is eligible to apply for an NUS Extra card, allowing you to enjoy great saving by top brands on the high-street and online.
© Globaledulink Ltd, 2017