Course Highlights
- Price: Guaranteed Low Price
- Level: Level 4 CPD Award
- Course Type: 100% Online Course
- Syllabus: 27 course modules
- Duration: 27 hours, guided
- Exams: Yes, included
- Accreditation: CPD Certification
- Certificate: Digital PDF Certificate included, optional Hard Copies £9.99
- Tutor Support: Support included
- Access: 12 Months, 24/7 Unlimited
- Compatibility: Any Browser Device
Course Overview
The online Excel 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.
The online Excel 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, 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.
The Excel Advanced Course is divided into 27 carefully selected modules making it easy to follow along in your own time and at your own pace.
You’ll have 24/7 access to the online course materials, assessment test, online exams, introductory video tutorial, study resources and our amazing student support services.
Enrolling on the Level 4 Excel Advanced Course is easy, just click to ‘Add to Basket’ button to start your learning journey.
Course Syllabus
As part of the Excel Advanced Course students will learn:
In this module of the course we will cover:
- Custom Number Formats
In this module of the course we will cover:
- Custom Lists
In this module of the course we will cover:
- Formula Auditing and Error Tracing
In this module of the course we will cover:
- Text to Columns
In this module of the course we will cover:
- Data Validation Question
In this module of the course we will cover:
- Consolidate Data
In this module of the course we will cover:
- Text Functions
In this module of the course we will cover:
- Maths and Trig Functions
In this module of the course we will cover:
- Statistical Functions
In this module of the course we will cover:
- Lookup Functions
In this module of the course we will cover:
- Database Functions
In this module of the course we will cover:
- What-If Analysis – Goal Seek
In this module of the course we will cover:
- What-If Analysis – Data Tables
In this module of the course we will cover:
- What-If Analysis – Scenarios
In this module of the course we will cover:
- Paste Special
In this module of the course we will cover:
- Subtotals and Grouping
In this module of the course we will cover:
- Getting External Data
In this module of the course we will cover:
- Pivot Tables and Pivot Charts
In this module of the course we will cover:
- Workbook Properties and Inspection
In this module of the course we will cover:
- Protecting Workbooks
In this module of the course we will cover:
- Sharing Workbooks
In this module of the course we will cover:
- Tracking Changes
In this module of the course we will cover:
- Compare and Merge Workbooks
In this module of the course we will cover:
- Linking Data
In this module of the course we will cover:
- Hyperlinks
In this module of the course we will cover:
- Illustrations
In this module of the course we will cover:
- Planning Small and Private Client Events
The final assessment test is an online interactive examination containing 50 questions to be completed within a 60 minute time frame.
The final assessment will contain questions from all modules and topics covered within the course.
The results from the final assessment test will count 100% towards the final grade for the course.
The results are instantaneous so learners will be informed straight away as to how they have performed on the assessment.
If for any reason you don’t pass first time around you have unlimited exam retakes.
Accreditation for Excel Advanced
Upon successful completion of this Excel Advanced Course student will be awarded with a CPD Accredited Certification in:
Level 4 CPD Award in Excel Advanced
Here at Oplex Careers we are an accredited CPD training provider and your certificate will include the recognised CPD stamp from our awarding organisation.
The CPD certificate will showcase your achievement in this course and provide proof to any future employers or academic institutions that you have gained the skills from this course and are now certified.
Certificate
On successful completion of this Level 4 Excel Advanced Course you will receive your CPD Certificate.
You can add the certification to your CV and include it as part of your portfolio of evidence.
The certificate will include the course you have undertaken, the grade you have achieved, your full name, date of completion, and a certificate verification number.
This certificate will be produced in Digital PDF format, hard copies of the certificate will be available at an additional fee of £9.99.
Reviews
There are no reviews yet.