Exam 77-428 - Excel 2013 Expert Part Two
Skills measured
This exam measures your ability to accomplish the technical tasks listed below.
Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.
Manage and share workbooks
- Manage multiple workbooks
- Modify existing templates, merge multiple workbooks, manage versions of a workbook, copy styles from template to template, copy macros from workbook to workbook, link to external data
Apply custom formats and layouts
- Apply custom data formats
- Create custom formats (Number, Time, Date), create custom accounting formats, use advanced Fill Series options
- Apply custom styles and templates
- Create custom color formats, create and modify cell styles, create and modify custom templates, create form fields
Create advanced formulas
- Apply functions in formulas
- Utilize the IF function in conjunction with other functions, utilize AND/OR functions, utilize nested functions, utilize SUMIFS, AVERAGEIFS, and COUNTIFS functions
- Create scenarios
- Utilize the watch window, consolidate data, enable iterative calculations, utilize What If analysis tools (including Goal Seek), utilize the Scenario Manager, use financial functions
Create advanced charts and tables
- Create and manage PivotCharts
- Create new PivotCharts, manipulate options in existing PivotCharts, apply styles to PivotCharts