Course Highlights
- Price: Guaranteed Low Price
- Level: Level 2, 3 and 4 CPD Award
- Course Type: 100% Online Course
- Syllabus: 64 course modules
- Duration: 120 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 Course level 2, 3 and 4 from Oplex Careers has been designed to introduce learners to working with a popular spreadsheet software – Microsoft Excel and get to grips with performing a range of basic yet important functions. From using worksheets, to cell alignment, this course will discuss key concepts with using Microsoft Excel.
Enroll in our Excel Course Bundle to gain a new perspective on Microsoft Excel. Our course covers working with worksheets, functional tasks and basic options of this spreadsheet software. Whether you’re looking to improve your job prospects or simply interested in learning more about Excel, our course is designed to cover a range of modules and provide multiple assessment opportunities for a well-rounded learning experience. Enhance your Excel skills today!
The Excel Course Bundle is divided into 64 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 2, 3 and 4 Excel Course is easy, just click to ‘Add to Basket’ button to start your learning journey.
Course Syllabus
As part of the Excel Beginner Course students will learn:
In this module of the course we will cover:
- What is a spreadsheet program
In this module of the course we will cover:
- Getting started with Microsoft Excel
In this module of the course we will cover:
- Workbook Window and Views
In this module of the course we will cover:
- Basic Spreadsheet Skills
In this module of the course we will cover:
- Selecting Cells
In this module of the course we will cover:
- Edit, Copy, and Move Cells
In this module of the course we will cover:
- Tell me and Help
In this module of the course we will cover:
- Opening and Saving Workbooks
In this module of the course we will cover:
- Using OneDrive
In this module of the course we will cover:
- New Workbooks and Templates
In this module of the course we will cover:
- Absolute and Relative Cell References
In this module of the course we will cover:
- AutoSum and Auto Fill
In this module of the course we will cover:
- Formatting Numbers
In this module of the course we will cover:
- Cell Alignment
In this module of the course we will cover:
- Cell Rows and Columns
In this module of the course we will cover:
- Working with Worksheets
In this module of the course we will cover:
- Page Layout
In this module of the course we will cover:
- Printing and Previewing Workbooks
In this module of the course we will cover:
- Sharing Workbooks
In this module of the course we will cover:
- Basic options
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.
Course Syllabus
As part of the Excel Intermediate Course students will learn:
In this module of the course we will cover:
- Defined Names
In this module of the course we will cover:
- Sorting Date
In this module of the course we will cover:
- Excel Tables
In this module of the course we will cover:
- Filtering Data and Slicers
In this module of the course we will cover:
- Chart Basics
In this module of the course we will cover:
- Chart Design Tools
In this module of the course we will cover:
- Chart Format Tools
In this module of the course we will cover:
- More About Charts
In this module of the course we will cover:
- Introduction to Functions
In this module of the course we will cover:
- Date Functions
In this module of the course we will cover:
- Logical Functions
In this module of the course we will cover:
- Information Function
In this module of the course we will cover:
- Financial Functions
In this module of the course we will cover:
- Find and Replace
In this module of the course we will cover:
- Headers and Footers
In this module of the course we will cover:
- Adding Comments
In this module of the course we will cover:
- Conditional Formatting
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.
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
Upon successful completion of this Excel Course student will be awarded with a CPD Accredited Certification in:
Level 2 CPD Award in Excel Beginner
Level 3 CPD Award in Excel Intermediate
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 2, 3 and 4 Excel 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.
As part of the online Excel Level 2, 3 and 4 Course you will receive full access to our tutor and student support services. Our friendly student support team want you to succeed in your studies and achieve the best possible grade. We are here to help!
Students will have full 24/7 unlimited access for 12 months from the date of joining on the Excel Level 2, 3 and 4 Course.
This online Excel Level 2, 3 and 4 Course will work on all major web browsers and smartphone devices. All you need is an internet, 3G, 4G or 5G connection.
Reviews
There are no reviews yet.