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

Excel Expert 77-728 Exam - 3 Practice Exams, 15 Projects and Almost 80 Tasks with Video Solutions!About This VideoUnderstand the type and the level of questions asked on the 77-728 Certification Exam for Expert Excel.A practical course designed for students who take Microsoft Certification Excel Expert exam - 77-728.In 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-728 Microsoft Certification exam to become an Excel Expert. Each practice exam is divided into five projects with a total of 26 tasks for each exam. That's 15 projects and 78 project tasks all geared towards the 77-728 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.The solutions to all the practice projects are provided in the form of video lectures. Here, 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-728 exam.The codes and supporting files for this course are available at: https://github.com/PacktPublishing/77-728-Expert-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
   • Introduction 00:05:29
   • Course Structure and the Best Approach to Completing the Practice Exams 00:02:27
   • Special Exam Considerations 00:04:19
   • How is the exam be conducted and what will it be like? 00:05:35
2. Chapter 2 : 77-728 Exam - Practice Exam 1 - HelpLess Airlines
   • Project 1 - Pilots and Passengers Solution 00:04:27
   • Project 2 - Income Analysis Solution 00:03:34
   • Project 3 - Sales Analysis Solution 00:03:41
   • Project 4 - Pilot Performance Solution 00:04:40
   • Project 5 - Monthly Merchandise Solution 00:05:31
3. Chapter 3 : 77-728 Exam - Practice Exam 2 - Event Management
   • Project 1 - Event Details Solution 00:04:00
   • Project 2 - Advertising Budgets Solution 00:03:19
   • Project 3 - Event Planner Solution 00:03:37
   • Project 4 - Manager Performance Solution 00:04:14
   • Project 5 - Equipment Solution 00:06:12
4. Chapter 4 : 77-728 Exam - Practice Exam 3 - Multiple Disciplines
   • Project 1 - Aircraft Parts Solution 00:04:50
   • Project 2 - Allied Mortgage Lenders 00:03:44
   • Project 3 - Concert Merchandise 00:05:56
   • Project 4 - Mobile Homes Business 00:06:29
   • Project 5 - Monogram Watch Company 00:04:54
   • Project 6 - Staff Profiles Solution 00:03:48
5. Chapter 5 : CUBE Functions - Special Questions
   • CUBE Functions Questions 00:06:56
6. Chapter 6 : Zipped Version of Project Files
   • Zipped Files 00:00:17
7. Chapter 7 : Bonus Lecture
   • Bonus Lecture - Facebook Group 00:00:49