MOS EXCEL EXPERT 77-728 Exam Preparation (Solution Based)
2.5 (15 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.
1,745 students enrolled

MOS EXCEL EXPERT 77-728 Exam Preparation (Solution Based)

Ultimate Microsoft Office Specialist (MOS) test preparation training course
2.5 (15 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.
1,745 students enrolled
Created by Umer Farooq
Last updated 9/2019
English
Current price: $129.99 Original price: $199.99 Discount: 35% off
7 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 downloadable resource
  • 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
  • Learn the features and functions in Microsoft Excel to help you pass the Microsoft office specialist (MOS) Excel 2016 exam 77-728
  • You will learn tests prepration.
  • You will get confidence to take and pass the real exam.
Requirements
  • Before attempting this course, you should be familiar with following:
  • Students need to know basic Excel before attempting the course
  • Microsoft Excel desktop software
Description

This preparation course is for the Microsoft Office Specialist exam for Excel, at the expert level, 77-728.  If you think you are ready to take the Microsoft exam and get  certified, these practice tests will prove that you know your stuff.  Take these tests before taking the real ones to identify your weaknesses, or give you the confidence to spend the money to sit for the  real test.

In these practice tests, you'll download a set of worksheets and be  asked to perform tasks to prove that you know the advanced elements of  Excel. The questions are based on the official exam requirements, and  were prepared by Umer Farooq - a certified MOS (Microsoft Office Specialist) Excel expert and MOS Master

These questions are tough. They're based on what you might see in the  real exam, and every effort has been made to simulate the exam  environment.

There is also a project-based test that are a very close simulation to the project-based portion of the real exam.

You'll get lifetime access to these questions. No 30-day expiry on  these ones. Once you buy this, it's yours. Take your time and prepare  for the exam, and use these tests to prove you're ready.

Who this course is for:
  • Who are preparing for the MOS 77-728 exam as an Excel Expert
  • Who wants to get certified in Excel 2016.
  • User of Microsoft Excel .
  • You will get confidence to pay for and take the real exam.
Course content
Expand all 25 lectures 01:15:56
+ Apply custom formats and layouts
4 lectures 15:35
Apply custom data formats [PART 1]
02:15
Apply custom data formats [PART 2]
01:41
Apply advanced conditional formatting and filtering [PART 1]
06:18
+ Apply custom styles and templates
2 lectures 06:13
Prepare workbooks for internationalization and accessibility
04:37
+ Create advanced formulas
9 lectures 24:18
Apply functions in formulas
05:26
Apply functions in formulas [PART 2]
04:25
Look up data by using functions
02:46
Apply advanced date and time functions
02:36
Perform data analysis and business intelligence [PART 2]
02:15
Troubleshoot formulas
01:13
Define named ranges and objects [ PART 1]
02:14
Define named ranges and objects [ PART2 ]
02:00
+ Create advanced charts and tables
7 lectures 11:54
Create advanced chart elements
01:19
Create and manage PivotTables [PART 1]
01:32
Create and manage PivotTables [PART 2]
01:36
Create and manage PivotTables [PART 3]
01:58
Create and manage PivotCharts [ PART 1]
02:05
Create and manage PivotCharts [ PART 2]
01:03
Create and manage PivotCharts [ PART 3]
02:21