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

 For Support