Advanced Excel includes a number of features and functions geared at helping experienced users make the most out of the program. Excel offers sharing, reviewing, and protecting functionality to help you manage your workbooks. It also provides the ability to customize data formats and layouts. Advanced Excel includes formulas and functions, What-if Analysis, PivotTables, and PivotCharts to help you analyze your data.

This learning path will cover date and time functions, logical and lookup functions, as well as tracing errors and troubleshooting. In addition, What-if Analysis will be covered with Data Tables, Goal Seek, and Scenario Manager. Finally, PivotTables, PivotCharts, and PowerPivot will be covered.

Request a Demo (

* You will receive an online access to e-learning (videos), hard copy material is not applicable to this course.

Why should one take Advanced Excel Certification?

This Course is intended for professionals and graduates wanting to excel in their chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression.

Earning Vskills Advanced Excel Certification can help candidate differentiate in today's competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning potential.

Who will benefit from taking Advanced Excel Certification?

Job seekers looking to find employment in IT or software development departments of various companies, students who want to Advanced Excel.

Companies that hire Vskills Certified Advanced Excel Professional

Advanced Excel professional are in great demand. This course designed for the learners who wish to enhance their Advanced Excel skills and become a professional in their respective jobs.

Advanced Excel Table of Contents


Apply for Advanced Excel Certification

By Net banking / Credit Card/Debit Card

We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill the application form in case you are paying online.

Please click Buy Now to proceed with online payments.

  • Visa Card
  • Master Card
  • American Express
Buy Now

Table of Content

Sharing and Linking Data, and Adding Office Apps to Excel 2013

  • Workbook Services and Sharing
  • Linking to External Data
  • Office Apps

Reviewing and Protecting Content in Excel 2013

  • Working with Multiple Workbooks
  • Reviewing Content
  • Protecting Content

Advanced Formats and Layouts in Excel 2013 

  • Custom Data Formats and Fill Series
  • Custom Cell Styles, Forms, and Templates
  • Advanced Conditional Formatting
  • Accessibility and Internationalization

Advanced Formulas and Functions in Excel 2013 

  • Date and Time Functions
  • Logical and IF-type Functions
  • Transposing and Looking Up Data with Functions
  • Tracing Errors and Troubleshooting

Using Financial Functions and What-If Analysis in Excel 2013

  • Financial Functions and Circular References
  • Watch Window
  • What-If Analysis

Using PivotTables and PivotCharts in Excel 2013 

  • PivotTables
  • PivotCharts
  • PowerPivot
  • Advanced Charts

“Exam scheduling to be done through user account” / “Exam once scheduled cannot be cancelled”
Date of Examination
Examination Time
01:00 PM - 02:00 PM
02:30 PM - 03:30 PM
04:00 PM - 05:00 PM
05:30 PM - 06:30 PM
10:00 AM - 11:00 AM
11:30 AM - 12:30 PM

Write a review

Your Name

Your Review Note: HTML is not translated!

Rating Bad           Good


Write a review

Note: HTML is not translated!
    Bad           Good


Tags: excel, excel 2013, Advanced excel