About 77-427 Excel 2013 Expert Part One Prep Course

The 77-427 Excel 2013 Expert Part One 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 workbook changes
      • Track changes, manage comments, identify errors, troubleshoot with tracing, display all changes, retain all changes
  • Apply custom formats and layouts
    • Apply advanced conditional formatting and filtering
      • Write custom conditional formats, use functions to format cells, create advanced filters, manage conditional formatting rules
    • Prepare a workbook for internationalisation and accessibility
      • Modify tab order among workbook elements and objects, display data in multiple international formats, modify worksheets for use with accessibility tools, utilise international symbols, manage multiple options for +Body and +Heading fonts
  • Create advanced formulas
    • Look up data with functions
      • Use the LOOKUP function, use the VLOOKUP function, use the HLOOKUP function, use the TRANSPOSE function
    • Apply advanced date and time functions
      • Use the NOW and TODAY functions, use functions to serialise dates and times
  • Create advanced charts and tables
    • Create advanced chart elements
      • Add trendlines to charts, create dual axis charts, create custom chart templates, view chart animations
    • Create and manage PivotTables
      • Create new PivotTables, modify field selections and options, create a slicer, group records, utilise calculated fields, format data, utilise PowerPivot, manage relationships

Chapters that are included in this course:

Excel 2013 Workbooks Management

Excel 2013 Workbooks Management Overview The skills tested in this section Excel 2013 Workbooks Management of the Microsoft Office Specialist Expert exams ...
Read More

Apply custom formats and layouts in Excel 2013

Apply custom formats and layouts in Excel 2013 Overview The skills tested in this section Apply custom formats and layouts in ...
Read More

Advanced formulas in Excel 2013

Advanced formulas in Excel 2013 Overview This section discusses the skill of creating Advanced formulas in Excel 2013, which is an ...
Read More

Create advanced charts and tables

Create advanced charts and tables Overview The skills tested in this section Create advanced charts and tables of the Microsoft Office ...
Read More

Topics that are included in this course:

Displaying all changes

The first time you open an edited workbook in which the changes have been tracked, you might see no revision ...
Read More

Reviewing changes

To review changes made to a shared workbook, click Track Changes on the Review tab, and then click Accept/Reject Changes ...
Read More

Merging workbooks

If you need a group of people to review a workbook, you can save it for sharing, distribute a copy ...
Read More

Identifying errors

Many formula errors are simple mistakes. For example, you might misplace or omit an opening or closing parenthesis, define a ...
Read More

Troubleshooting by using tracing

The Trace Error command helps you identify the cell causing an error in a formula. When an error value is ...
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