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