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 (info@vskills.in)

* 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

https://www.vskills.in/certification/advanced-excel-table-of-content

 

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
05-Jan-2019
06-Jan-2019
19-Jan-2019
20-Jan-2019
02-Feb-2019
03-Feb-2019
16-Feb-2019
17-Feb-2019
02-Mar-2019
03-Mar-2019
16-Mar-2019
17-Mar-2019
06-Apr-2019
07-Apr-2019
20-Apr-2019
21-Apr-2019
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

Captcha

Write a review

Note: HTML is not translated!
    Bad           Good


Captcha

Tags: excel, excel 2013, Advanced excel