Advanced Excel Table of Content


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

 

Apply for certification 

https://www.vskills.in/certification/office-skills/advanced-excel-certification