Enquire Now
Menu
£199 £49 (inc. VAT)

Buy Now

Add To Cart

  • 365 Days
  • Course Certificate
  • 06Guided Learning Hours
  • ACCREDITED BY CPD & iAP
  • Course Material
  • 15 Number of Modules
  • Exam Included

What Will I Learn?

Learn many different formulas which could benefit your daily operations immensely
Learn how to use the advanced features of excel to their full extent
Learn how to save time and create easy work of calculating, displaying and sharing data
Learn the microsoft excel 2016 spreadsheet application thoroughly
Ability to organise and calculate data using excel
Learn how to use this application to monitor financial performance like business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists

Looking for an advanced level Microsoft Excel 2013 course?

This online course is specially designed for learners who have studied beginner or intermediate level course or are already confident with the basic features offered in Microsoft Excel. This advanced Excel course will surprise you with excellent teaching materials and lots of formulas to play around with. If you are looking to improve your Excel knowledge and skills, this is the right course for you! What are you waiting for?

If you know the basics of Excel, including: entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced Excel course will really unlock the power of the programme and its advanced functionality. This advanced Microsoft Excel training course will teach you to use the advanced features of Excel to their full extent.

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data. This Advanced Excel training course will introduce you to some of Excel’s more powerful features.

To get the most out of this course, it would be an advantage to have completed our Excel beginner or intermediate course or to have the equivalent experience using Microsoft Excel.

Studying with Global Edulink has many advantages. The course material is delivered straight to you, and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months). An effective support service and study materials will build your confidence to study efficiently and guide you to secure your qualification.

If you want one-on-one sessions in a real classroom, visit our MS Excel Advanced Classroom Course page.

Course Objectives:

  • For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use it at an advanced level.

Who is it for?

  • To get the most out of this course, you will need to have completed our Excel beginner or intermediate course or have the equivalent experience of this popular software.
  • This Qualification is helpful for any Office job, such as: PA, Secretary, Admin Assistant, and Administrator, Accountant, Account Assistant, Bookkeeper, Office Manager or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.

Course Description:

This online training course is comprehensive and is designed to cover the topics listed under the curriculum. This course has been designed for 06 guided learning hours.

Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course learners will also take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certification:

Successful candidates will be awarded certificate for Certificate in Microsoft Excel 2013 Advanced Training.

Entry Requirement:

  • To get the most out of this course, you will need to have completed our entry-level Microsoft Excel (Beginner level) or Intermediate course or have the equivalent experience of this extremely popular software.
  • Learners should be ages 16 or over to undertake the qualification.
  • Basic understanding of English language, literacy, numeracy and ICT are required to attend this course.

Career Path:

This course is not a job qualification and hence, will not qualify you for any specific job position in the corporate world. However, with this certificate to back up your professional qualifications, you are sure to land a rewarding job role across any industry of your choice. This course can also help you win various job opportunities put forth by your organisation. Listed below are few of the job positions this course can help you land, along with the average UK salary per annum according to https://www.payscale.com,

  • Admin Assistant – £16,887 per annum
  • PA – £25,143 per annum
  • Secretary – £19,554 per annum
  • Office Administrator – £17,444 per annum
  • Accountant – £28,580 per annum
  • Accounting Assistant – £20,319 per annum
  • Bookkeeper – £20,767 per annum
  • Office Manager- £24,406 per annum

PLEASE NOTE:

You should have installed MS Office 2013 software to your computer for the practices. This package is not provided software and you need to install that software separately.

Helpful Link for Software Downloading:  Click for Download

Course Curriculum

1: apply conditional formatting
Apply Conditional Formatting 00:19:00
2: trace cells
Trace Cells 00:05:00
3: troubleshoot invalid data and formula errors
Troubleshoot Invalid Data and Formula Errors 00:12:00
4: watch and evaluate formulas
Watch and Evaluate Formulas 00:09:00
5: create a data list outline
Create a Data List Outline 00:09:00
6: create sparklines and scenarios
Create Sparklines and Scenarios 00:25:00
7: perform a statistical analysis with the analysis toolpak
Perform a Statistical Analysis with the Analysis ToolPak 00:26:00
8: create interactive data with power view
Create Interactive Data with Power View 00:10:00
9: consolidate data
Consolidate Data 00:10:00
10: link cells in different workbooks
Link Cells in Different Workbooks 00:10:00
11: merge workbooks
Merge Workbooks 00:08:00
12: export and import excel data
Export and Import Excel Data 00:15:00
13: integrate excel data with the web
Integrate Excel Data with the Web 00:11:00
14: create a web query
Create a Web Query 00:07:00
15: how to create and edit a macro
How to create and edit a Macro 00:00:00
excercise files
EXCERCISE FILES 00:00:00
mock exam
Mock Exam: Microsoft Excel 2013 – Advanced 00:40:00
final exam
Exam: Microsoft Excel 2013 – Advanced 00:39:00
£199 £49 (inc. VAT)

Buy Now

Add To Cart

  • 365 Days
  • Course Certificate
  • 06Guided Learning Hours
  • ACCREDITED BY CPD & iAP
  • Course Material
  • 15 Number of Modules
  • Exam Included

Inquiry Now

  • By submitting your information, you agree to the terms and conditions stated in our privacy policy.
Call Back

460 STUDENTS ENROLLED

CPD Accredited

Accredited Qualification


sage

Unit Summary


sage

Accredited by CPD & iAP

Awarded by iAP

CPD Accredited

CPD Membership No: 10582

Study independently accredited and recognised CPD courses. Gain your certification today

Buy with Confidence

UKRLP


Build Your CV Here
cv All students enrolled with Global Edulink are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews. MORE INFO
cv If you need career support Global Edulink is here for you. We provide excellent career support through our Career Support Service.
MORE INFO

Paypal Credit

Smiley face

NUS Extra Card

NUS Extra Card

Every student of Global Edulink is eligible to apply for an NUS Extra card, allowing you to enjoy great saving by top brands on the high-street and online.

Course Reviews

4.80

4.80
24 ratings

No Reviews found for this course.

Popular Courses

Mastering Event Planning, Designing, and Decorating

Are you excited by colour,...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £69 (inc. VAT)

Windows 10 Training

Overview If you want to...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

Teaching Assistant: Level 3 Certificate in Supporting Teaching & Learning in Schools

Overview: This NCFE CACHE Level...
  • 365 Days
  • Awarded by 'ncfe'
5
Price Options +
£1,739 (inc. VAT)
or only £89 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £89.00 (Inc. VAT)
Awarding Body Registration:

£119.00 (Inc. VAT)

Assessment: £199.00 (Inc. VAT)

(Pay in 11 Installments)

Total Price: £407.00 (Inc. VAT)

Level 3 Certificate in Teaching Assistant – Communication and Professional Relationships

Overview It is healthy and...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£639 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £138.00 (Inc. VAT)

Level 3 Certificate in Teaching Assistant – Wellbeing of Children and Young People

Overview If you want to...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£639 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £138.00 (Inc. VAT)

Diploma in Collection Construction – Level 4

Overview The Diploma in Collection...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £278.00 (Inc. VAT)

Professional Receptionist Training

Overview As a Receptionist, you...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

Business and General Maths

Becoming Maths Savvy This course...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £69 (inc. VAT)

Mastering Telephone Etiquette and Communication Strategies

Overview: Whether you work in...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

IT Management

Could you be a great...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£199 £49 (inc. VAT)

Diploma in Customer Service and Opera PMS Software Training – Level 3

Overview: Every business wants to...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)

Level 7 Diploma in Coaching and Mentoring

Overview The Level 7 Diploma...
  • 365 Days
  • CMI
5
Price Options +
£1,699 £1,199 (inc. VAT)
or only £139 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £139.00 (Inc. VAT)
Awarding Body Registration:

£259.00 (Inc. VAT)

Assessment: £809.00 (Inc. VAT)

(Pay in 07 Installments)

Total Price: £1207.00 (Inc. VAT)

CMI Level 6 Diploma in Management and Leadership

Overview The CMI Level 6...
  • 365 Days
  • CMI
5
Price Options +
£1,799 £899 (inc. VAT)
or only £149 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £149.00 (Inc. VAT)
Awarding Body Registration:

£219.00 (Inc. VAT)

Assessment: £539.00 (Inc. VAT)

(Pay in 06 Installments)

Total Price: £907.00 (Inc. VAT)

Level 3 Certificate in Teaching Assistant – Equality, Diversity and Inclusion

Overview Equality and diversity are...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£639 (inc. VAT)
or only £49 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £49.00 (Inc. VAT)
Assessment: £89.00 (Inc. VAT)

(Pay in 04 Installments)

Total Price: £138.00 (Inc. VAT)

Diploma in General Pest Control – Level 4

Overview The Diploma in General...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 03 Installments)

Total Price: £278.00 (Inc. VAT)

Advanced Diploma in Cake Decorating – Level 3

Overview Do you have cake...
  • 365 Days
  • Awarded by 'ABC AWARDS'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)

Introduction to First Aid

Overview The Introduction to First...
  • 365 Days
  • Awarded by 'CIEH'
5
£119 £28 (inc. VAT)

CMI Level 7 Diploma in Strategic Management and Leadership

Overview The CMI Level 7...
  • 365 Days
  • CMI
5
Price Options +
£1,999 £949 (inc. VAT)
or only £169 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £169.00 (Inc. VAT)
Awarding Body Registration:

£259.00 (Inc. VAT)

Assessment: £529.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £957.00 (Inc. VAT)

Diploma in Supervision – Level 3

Overview The Diploma in Supervision...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£429 £229 (inc. VAT)
or only £79 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £79.00 (Inc. VAT)
Assessment: £159.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £238.00 (Inc. VAT)

Cisco 200-355: CCNA Wireless Network Fundamental WIFUND

Become a handsomely compensated, critical...
  • 365 Days
  • Awarded By 'CISCO'
5
£299 £89 (inc. VAT)

Lean Six Sigma Black Belt Exam

Lean Six Sigma Black Belt...
  • 365 Days
  • Awarded by 'PEOPLECERT'
5
£579 £349 (inc. VAT)

Marketing for Business

Marketing plays a vital role...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £69 (inc. VAT)

Free Microsoft Word 2016 – Beginner

Register today and get free...
  • 30 Days
  • ACCREDITED BY CPD & iAP
5
FREE

Complete Psychologist Course Bundle

Overview: If you’ve always had...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£249 £69 (inc. VAT)

Diploma in Management Accounting – Level 4

Overview The goal of management...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £278.00 (Inc. VAT)

Certificate in Personal Confidence and Motivation – Level 2

Overview The Certificate in Personal...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£399 £199 (inc. VAT)
or only £59 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £59.00 (Inc. VAT)
Assessment: £149.00 (Inc. VAT)

(Pay in 02 Installments)

Total Price: £208.00 (Inc. VAT)

Diploma in Excavation & Trenching – Level 4

Overview The Diploma in Excavation...
  • 365 Days
  • Awarded by 'ABC Awards'
5
Price Options +
£469 £269 (inc. VAT)
or only £99 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £99.00 (Inc. VAT)
Assessment: £179.00 (Inc. VAT)

(Pay in 05 Installments)

Total Price: £278.00 (Inc. VAT)

Complete Cisco Networking Course Bundle

Overview: Certifications such as this...
  • 365 Days
  • Awarded by "CISCO"
5
Price Options +
£799 £149 (inc. VAT)
or only £33 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Deposit: £33.00
Monthly: £29.00
No of Installments: 4
Total Price: £119.00( Inc. VAT)

Diploma in Improving Critical Business Skills – Level 3

What does it take to...
  • 365 Days
  • ACCREDITED BY CPD & iAP
5
£399 £59 (inc. VAT)

Pearson BTEC Level 7 Diploma in Strategic Management and Leadership (RQF)

Overview: Developed for Senior Managers...
  • 365 Days
  • Awarded by 'Pearson BTEC'
5
Price Options +
£1,499 £1,199 (inc. VAT)
or only £269 (inc. VAT) intial payment

CHOOSE HOW YOU WANT TO PAY

IN FULL
INSTALLMENT
Initial Fee: £269.00 (Inc. VAT)
Awarding Body Registration :

£179.00 (Inc. VAT)

Assessment: £759.00 (Inc. VAT)

(Pay in 06 Installments)

Total Price: £1207.00 (Inc. VAT)
Load More