Microsoft Excel – Advanced - Level 4 - Accredited
Short course
Online
Description
-
Type
Short course
-
Methodology
Online
-
Duration
12 Months
The online Microsoft Excel 2013 Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.
Facilities
Location
Start date
Start date
About this course
The Microsoft Excel 2013 Advanced course from Oplex Careers is perfect if you’re just starting out in the industry or simply fancy learning something new.
There a no specific entry requirements to enroll on the Microsoft Excel Level 4 course. You need basic numeracy and literacy skills, so everyone is welcome to join the course.
Upon finishing the Microsoft Excel Level 4 course you will receive a CPD Accredited Certificate from Oplex Careers.
Your recognised CPD Certificate can be used to showcase to any potential employers you have acquired a certain level of skills or keep for your own records as part of your portfolio of evidence.
One receiving your request about this course, a member of our friendly team will send you all the details about the course and help answer any questions you may have.
You can also see the full course details at: https://deals.oplexcareers.com/course/microsoft-excel-advanced-course/?id=6
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Excel
- Microsoft Excel
- Accredited
- Microsoft excel training
- MS Excel
- Macros
- Templates
- Formats
- Tracking
- Custom
- Merging
Teachers and trainers (1)
Oplex Careers
Support Team
Course programme
Introduction to Excel Advanced
Using Text to Columns
The Paste Special Function
Data Validation
Subtotals and Grouping
Consolidating Data
Scenario Analysis
Data Tables in Scenario Analysis
What-if Analysis
Mats and Trig Functions
Text Functions in Excel
Using Lookup Functions
Vlookups
HLookups
Using Statistical Functions
Databse Functions
Formaula Auditing and Error Tracing
Hyperlinks in Excel
Linking Data
Understanding Pivot Tables
Using Pivot Charts
Workbook Properties
Protecting and Sharing Worksheets
Data Encrypting and Finalising Workbooks
Understanding to Macros
Custom Number Formats in Excel
Using Custom Lists
Working with Templates
Tracking Changes in Excel
Merging and Compare Excel Workbooks
Final Assessment
Microsoft Excel Software
This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.
Assessment
To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Advanced 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.
Additional information
Microsoft Excel – Advanced - Level 4 - Accredited