What Will I Learn?

Learn this software bundle which consists of Microsoft Excel 2016 Introduction, Microsoft Excel 2016 Beginner and Microsoft Excel 2016 Advanced courses

Gain a full introduction to Excel and be able to navigate thought the software with total ease

Learn the intermediate level functions of Microsoft Excel such as creating tables, conditional formatting, and the quick analysis button

Study the advanced level functions of Microsoft Excel such as data validation, slicers and timelines, and running macros.

Become an Excel expert in the industry

Learn many different formulas which could benefit your daily operations immensely

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 Diploma in Microsoft Excel 2016 Beginner to Advanced Training.
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

456 STUDENTS ENROLLED

Diploma in Microsoft Excel 2016 (Beginner to Advanced)

What Will I Learn?

Overview:

Course Curriculum

Inquiry Now

Accredited Qualification

Unit Summary

Accredited by CPD & iAP

Buy with Confidence

TOTUM Card

Paypal Credit

Course Reviews

4.6

Microsoft Excel 2013 Dashboard Design

COBIT® 5 Foundation, COBIT® 5 Implementation and ...

COBIT® 5 Foundation and COBIT® 5 Assessor Officia...

COBIT® 5 Foundation and COBIT® 5 Implementation O...

RESILIA™ Foundation and RESILIA™ Practitioner Off...

RESILIA™ Practitioner Official Exam

RESILIA™ Foundation Official Exam

COBIT® 5 Foundation Official Exam

COBIT® 5 Implementation Official Exam

COBIT® 5 Assessor Official Exam

ITIL® 4 Foundation Official Exam

CHOOSE HOW YOU WANT TO PAY

ITIL®Foundation Certification

Related Courses

CHOOSE HOW YOU WANT TO PAY

Marketing for Business

Mastering Event Planning, Designing, and Decorating

CHOOSE HOW YOU WANT TO PAY

Diploma in Business and Management – Level 3

CHOOSE HOW YOU WANT TO PAY

Level 3 Certificate in Teaching Assistant –...

Professional Receptionist Training

Mastering Telephone Etiquette and Communication S...

IT Management

CHOOSE HOW YOU WANT TO PAY

Diploma in Human Resource Management – Level 4

CHOOSE HOW YOU WANT TO PAY

Diploma in Business Economics – Level 3

CHOOSE HOW YOU WANT TO PAY

Level 3 Certificate in Teaching Assistant –...

CHOOSE HOW YOU WANT TO PAY

Diploma in Collection Operation and Maintenance &...

Diploma in Interior Designing – Level 2

CHOOSE HOW YOU WANT TO PAY

CACHE Level 3 Award in Preparing to Work in Home-...

CHOOSE HOW YOU WANT TO PAY

Diploma in Office Administration and PA – L...

CHOOSE HOW YOU WANT TO PAY

Diploma in Macroeconomics – Level 3

CHOOSE HOW YOU WANT TO PAY

Diploma in Counselling Skills – Level 2

COBIT® 5 Foundation Official Exam

Diploma in Social Media & Business Strategy

Cisco 200-355: CCNA Wireless Network Fundamental ...

Free Microsoft Word 2016 – Beginner

CHOOSE HOW YOU WANT TO PAY

Level 3 Award in Coaching and Mentoring

CHOOSE HOW YOU WANT TO PAY

Diploma in Strategic Marketing – Level 3

CHOOSE HOW YOU WANT TO PAY

Diploma In Mastering SPSS Software And Analysis &...

MoP® Foundation Official Exam

CHOOSE HOW YOU WANT TO PAY

Complete Cisco Networking Course Bundle

Diploma in Small Business Accounting

Diploma in Improving Critical Business Skills – L...

Diploma in Everyday Budgeting

CHOOSE HOW YOU WANT TO PAY

Diploma in Leadership and Management – Level 3

CHOOSE HOW YOU WANT TO PAY

Diploma in Banking – Level 3

Popular Courses

CHOOSE HOW YOU WANT TO PAY

CHOOSE HOW YOU WANT TO PAY

CHOOSE HOW YOU WANT TO PAY

CHOOSE HOW YOU WANT TO PAY

CHOOSE HOW YOU WANT TO PAY