Excel 2013 Expert Part Two

Code: 77-428
Price:

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

Course Reviews

No reviews found for this course.

Be the first to write a review