Microsoft Excel – Advanced - Level 4 - Accredited

Short course

Online

Save 90%
£ 24 VAT inc.

Description

  • Type

    Short course

  • Methodology

    Online

  • Duration

    12 Months

Special Offer - CPD Accredited - NUS Eligible

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

Online

Start date

Different dates availableEnrolment now closed

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

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

Oplex Careers

Support Team

Course programme

The Microsoft Excel Advanced course is split into the following modules:

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

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.

Microsoft Excel – Advanced - Level 4 - Accredited

£ 24 VAT inc.