/

Microsoft Excel Advanced Course

(3.4)13 reviews
Recent reviews of this course provider

CBT

Really very good I recommend it...more

See all reviews
Add to shortlistShortlisted by 34 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-Advanced-Course-courses/56143184/

Course description

Microsoft Excel Advanced Course:

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.

Course Syllabus

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.

Certificate

On successful completion of this Microsoft Excel Advanced course learners will receive a CPD Certificate of Achievement award from Oplex Careers.

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 Microsoft Excel Advanced course.

Course Duration

The online Microsoft Excel Advanced course requires 90 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 Microsoft Excel Advanced 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.

Additional entry requirements

There is no entry requirements for the Microsoft Excel Advanced Course

Course info
170 views

Qualification:

Certificate of Attendance

UK

UK qualification

This course is offered to anyone in the world, but its qualification is only relevant in this country.

Study Hours:

Variable - to suit the learner

Level:

BeginnerIntermediate Advanced

Virtual help:

No attendance for this course

Course type:

Online course

£249.99 ( 90% off )

£24
per course

Summary of all course reviews for Oplex Careers

13 reviews

(54%)
(8%)
(38%)

Average student ranking

Reviews of other courses at Oplex Careers

oplex-careers

CBT
5 5
Hotcourses
January 2018

Really very good I recommend it

Was this review helpful? Yes No
8 Hotcourses user(s) found the following review helpful.

oplex-careers

Pet Bereavement Counselling
5 5
Hotcourses
November 2017

I found that it was convenience and easy to assess to study online. The materials were rich and cover all the topics that I want to know. It was good that there were a little test in every session which made me more understand and remember what I had learned. Thank you so much.

Was this review helpful? Yes No
14 Hotcourses user(s) found the following review helpful.
MORE REVIEWS

Please note reviews of Pet Bereavement Counselling are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Microsoft Excel Advanced Course by Oplex Careers on Hotcourses

Ask a question

Get course info