Loader
Course Image

Course Description

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.

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...

Read More

Course Content

1: Apply Conditional Formatting

2: Trace Cells

3: Troubleshoot Invalid Data And Formula Errors

4: Watch And Evaluate Formulas

5: Create A Data List Outline

6: Create Sparklines And Scenarios

7: Perform A Statistical Analysis With The Analysis Toolpak

8: Create Interactive Data With Power View

9: Consolidate Data

10: Link Cells In Different Workbooks

11: Merge Workbooks

12: Export And Import Excel Data

13: Integrate Excel Data With The Web

14: Create A Web Query

15: How To Create And Edit A Macro

1: Apply Conditional Formatting 2: Trace Cells 3: Troubleshoot Invalid Data And Formula Errors 4: Watch And Evaluate Formulas 5: Create A Data List Outline 6: Create Sparklines And Scenarios 7: Perform A Statistical Analysis With The Analysis Toolpak 8: Create Interactive Data With Power View 9: Consolidate...

Read More

Entry Requirements

  • 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.

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...

Read More

Assessment Methods

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.

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.

Additional Information

Certification:

Successful candidates will be awarded certificate for “Certificate in Microsoft Office Excel 2013 – Advanced”.

Career Path:

Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft Excel applications.

This Qualification is helpful for any Office job, such as:

  • Admin Assistant
  • PA
  • Secretary
  • Administrator
  • Accountant
  • Account Assistant
  • Bookkeeper
  • Office Manager

Certification: Successful candidates will be awarded certificate for “Certificate in Microsoft Office Excel 2013 – Advanced”. Career Path: Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft Excel...

Read More

Related Courses