About 77-428 Excel 2013 Expert Part Two Prep Course

The 77-428 Excel 2013 Expert Part Two Prep Course for  Microsoft Excel 2013 guides about the typical MS Excel use and shows how to get the most out of MS Excel features to work effectively and efficiently. The exam is proof of competence across a spectrum of skills required for proficiency in Microsoft Excel 2013.

In order to get this accreditation candidate need to pass 77-427 Excel 2013 Expert Part One and 77-428 Excel 2013 Expert Part Two

Languages: English
Who should take this course: IT professionals
Technology: Microsoft Office 2013 suites
Credit towards certification: Microsoft Office Specialist (MOS)

Skills measured in this course:

  • 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 colour formats, create and modify cell styles, create and modify custom templates, create form fields
  •  Create advanced formulas
    • Apply functions in formulas
      • Use the IF function in conjunction with other functions, use AND/OR functions, use nested functions, use SUMIFS, AVERAGEIFS and COUNTIFS functions
    • Create scenarios
      • Use the watch window, consolidate data, enable iterative calculations, use What-If analysis tools (including Goal Seek), use 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

Chapters that are included in this course:

Advanced charts and tables creation in Excel 2013

Advanced charts and tables creation in Excel 2013 Overview The skills tested in this section is related with Advanced charts ...
Read More

Create advanced formulas

Create advanced formulas Overview The skills tested in this section "Create advanced formulas" of the Microsoft Office Specialist Expert exams ...
Read More

Apply custom formats and layouts

Apply custom formats and layouts Overview The skills tested in this section Apply custom formats and layouts of the Microsoft Office ...
Read More

Manage and share workbooks in Excel 2013

Manage and share workbooks in Excel 2013 Overview The skills tested in this section Manage and share workbooks in Excel ...
Read More

Topics that are included in this course:

Modifying workbook templates

Templates are featured prominently in the Backstage view (which you display by clicking the File tab). Excel has always included ...
Read More

Managing workbook versions

Sometimes you need a do-over. The AutoRecover feature is normally turned on; when it is, you can retrieve versions of ...
Read More

Copying styles between templates

Cell styles that you create can be saved as custom styles and transferred to other workbooks or templates. New styles ...
Read More

Merging styles that have the same name

--------------------------------------------------------------------------------------- When you use the Merge Styles command, you might see a dialog box that asks you to decide whether ...
Read More

Copying macros between workbooks

Macros are sequences of actions captured by using the Record Macro command, or snippets of handwritten code, which are used ...
Read More
Loading...

Practice test that are included in this course:

No posts found.

Disclaimer:

This course includes every exam objective, but it does not cover every exam question. Only the Microsoft exam team has access to the exam questions, and Microsoft regularly adds new questions to the exam, making it impossible to cover specific questions. You should consider this course a supplement to your relevant real-world experience