Excel 2016 Advanced Level 4 Course
Oplex Careers
Summary
- Tutor is available to students
Add to basket or enquire
Overview
The online Excel 2016 Advanced Level 4 Course from Oplex Careers aims to provide further insight and understanding into the functions related to working working with spreadsheet software, and more specifically Microsoft Excel 2016 software.
CPD
Course media
Description
The online Excel 2016 Advanced Level 4 Course will further provide learners with a strong and thorough understanding into the key skills important when working with the most recent version of popular spreadsheet software. This course will discuss the key functions and actions within Excel 2016, from Tables, Charts, Formatting and more. This course will provide a great insight into working with clients using practical examples throughout the course.
Whether working in this field already, you want to get started working in marketing, or just interested in this field of study, this course will cover a range of modules and provide multiple examples for assessment.
Course Syllabus
The Excel 2016 Advanced Level 4 Course is split into the following modules:
- Custom Number Formats
- Custom Lists
- Formula Auditing and Error Tracing
- Text to Columns
- Data Validation Question
- Consolidate Data
- Text Functions
- Maths and Trig Functions
- Statistical Functions
- Lookup Functions
- Database Functions
- What-If Analysis – Goal Seek
- What-If Analysis – Data Tables
- What-If Analysis – Scenarios
- Paste Special
- Subtotals and Grouping
- Getting External Data
- Pivot Tables and Pivot Charts
- Workbook Properties and Inspection
- Protecting Workbooks
- Sharing Workbooks
- Tracking Changes
- Compare and Merge Workbooks
- Linking Data
- Hyperlinks
- Illustrations
- An Introduction to Macros
- Final Assessment
Assessment
To assess the learners ability and knowledge to effectively understand the topics contained within the Excel 2016 Advanced Level 4 Course, the course features a number of end of module interactive quiz questions.
Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Certificate
On successful completion of this Excel 2016 Advanced Level 4 Course students will receive a CPD Certification. This certificate will be produced in PDF format, hard copies of the certificate will be available at an additional fee of £9.99.
Course Format
This course is delivered online through eLearning. Learners of the course will receive instant access to our interactive student learning portal, which offers 24/7 access to the Excel 2016 Advanced Level 4 Course.
Course Duration
The online Excel 2016 Advanced Level 4 Course requires 27 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.
Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.
Tutor Support
When you are studying a course it is always useful to know that you have the help and support of tutors that want you to succeed in your studies.
As part of the Excel 2016 Advanced Level 4 Course you will receive access to our dedicated tutor support service. The academic tutors will be able to provide you with unlimited online email support to help answer any questions that you may have whilst you are studying the course.
Course Compatibility
Our Excel 2016 Advanced Level 4 Course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices.
We know that more and more people are using the web whilst they are on the move, so we have designed this Excel 2016 Advanced Level 4 Course to be fully compatible across tablet and smartphone devices. You will be able to access the same content from the course, just over a 3G or 4G network whilst on the move.
Requirements
There are no specific entry requirements to join this course with Oplex Careers. All you need to study this course is an internet connection.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.