77-728 MOS Expert Excel Practice Tests and Video Solutions
3.6 (100 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
542 students enrolled

77-728 MOS Expert Excel Practice Tests and Video Solutions

Excel Expert 77-728 MOS Exam - 3 Practice Exams, 15 Projects and Almost 80 Tasks with Video Solutions!
3.6 (100 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
542 students enrolled
Created by Dave Murphy
Last updated 3/2020
English
Current price: $86.99 Original price: $124.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 article
  • 19 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will have complete certainty as to the type and level of the questions asked on the 77-728 Certification Exam for Expert Excel.
  • You will be ready to take the 77-728 exam if you can manage to complete the assigned exercises in the times specified
Requirements
  • Microsoft Excel 2016
  • Intermediate Knowledge of Microsoft Excel 2016
  • Familiarity with the 77-728 Objective Domain requirements
Description

New November 2018 - Additional Questions on CUBE Functions Added

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-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.

Tips on issues you will encounter with particular questions types is 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-728 exam.

Who this course is for:
  • Students who want to test whether they are ready to take the 77-728 Certification Exam in Microsoft Excel.
  • Students preparing for the Microsoft Certification Excel Expert exam - 77-728.
  • Students who want to experience the level of the 77-728 exam standard questions.
Course content
Expand all 23 lectures 01:38:29
+ Introduction
4 lectures 18:25

This is a really important lecture to review before you start the course. It explains how I've structured the curriculum and the best approach to completing the practice exams.

Preview 02:52
Special Exam Considerations
04:18

This lecture provides guidance on how to sign on for the exam and on the Concole 8 exam interface.

Preview 05:28
+ 77-728 Exam - Practice Exam 1 - HelpLess Airlines
5 lectures 21:50
Project 2 - Income Analysis Solution
03:34
Project 3 - Sales Analysis Solution
03:40
Project 4 - Pilot Performance Solution
04:39
Project 5 - Monthly Merchandise Solution
05:30
+ 77-728 Exam - Practice Exam 2 - Event Management
5 lectures 21:19
Project 1 - Event Details Solution
03:58
Project 2 - Advertising Budgets Solution
03:18
Project 3 - Event Planner Solution
03:37
Project 4 - Manager Performance Solution
04:14
Project 5 - Equipment Solution
06:12
+ 77-728 Exam - Practice Exam 3 - Multiple Disciplines
6 lectures 29:40
Project 1 - Aircraft Parts Solution
04:50
Project 2 - Allied Mortgage Lenders
03:43
Project 3 - Concert Merchandise
05:56
Project 4 - Mobile Homes Business
06:29
Project 5 - Monogram Watch Company
04:54
Project 6 - Staff Profiles Solution
03:48