by Dave Murphy | Publisher: Packt Publishing | Release Date: February 2019 | ISBN: 9781838641368

Excel Core 77-727 exam - 3 practice exams, 21 projects, and 105 tasks with video solutions!About This VideoLearn to identify, mitigate, and report any potential cyber threats to your organizationThis course is designed to train employees and protect organizations from cyber threatsIn DetailThe 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-SolutionsDownloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

1. Chapter 1 : Introduction
   • Course Introduction - What is MOS Certification 00:02:12
   • Course Structure and the Best Approach to Completing the Practice Exams 00:02:01
   • How is the exam be conducted and what will it be like? 00:05:35
2. Chapter 2 : 77-727 Exam - Practice Exam 1
   • Project 1 - Pilots and Passengers Solution 00:04:36
   • Project 2 - Income Analysis Solution 00:04:10
   • Project 3 - Sales Analysis Solution 00:04:30
   • Project 4 - Pilot Performance Solution 00:03:26
   • Project 5 - Monthly Merchandise Solution 00:03:39
   • Project 6 - HelpLess Airlines Marketing Plan Solution 00:03:50
   • Project 7 - Training Sales Solution 00:04:00
3. Chapter 3 : 77-727 Exam - Practice Exam 2
   • Project 1 - Marketing Plan Solution 00:03:09
   • Project 2 - Revenue & Maintenance Solution 00:04:16
   • Project 3 - Flights Solution 00:05:11
   • Project 4 - Monthly Revenue Solution 00:03:23
   • Project 5 - Staff solution 00:05:12
   • Project 6 - Extended Flights Solution 00:04:57
   • Project 7 - Bands Solution 00:02:11
4. Chapter 4 : 77-727 Exam - Practice Exam 3
   • Project 1 - Income Analysis Solution 00:02:22
   • Project 2 - Sales Analysis Solution 00:05:40
   • Project 3 - Car Sales Solution 00:04:49
   • Project 4 - Warehouse Inventory Solution 00:02:46
   • Project 5 - Luggage Rules Solution 00:04:05
   • Project 6 - Project Tracker Solution 00:02:55
   • Project 7 - Expense Trends Budget Solution 00:04:05
5. Chapter 5 : Bonus Section
   • Facebook Group 00:00:44