The purpose of this course is to provide you with three complete practice tests which are prepared at the level required to pass the 77-727 Microsoft Certification exam in Core Excel. Each practice exam is divided into seven projects with a total of 35 tasks for each exam. That's 21 projects and 105 project tasks, all geared toward the 77-727 exam. Advice on preparation, how to approach the exam, what the interface will look like, and which areas of the Objective Domain to focus on is provided. Tips on issues you will encounter with particular questions types are also included. The solutions to all of the practice projects are provided in the form of video lectures, in which the instructor explains how to approach the project and how the solutions are derived.

If you can master the practice projects included in this course, you will be confident in your abilities to master the 77-727 exam.

All the code files are placed at https://github.com/PacktPublishing/77-727-Core-Excel-Practice-Tests-and-Video-Solutions

Style and Approach

This course includes practice tests, projects, and tasks which are prepared at the level required to pass the 77-727 Microsoft Certification exam in Core Excel. The solutions to all of the practice projects are provided in the form of video lectures, in which the instructor explains how to approach the project and how the solutions are derived.