This course is designed for those interested to learn the basics of Excel practice tests and video solutions and those who are preparing for the Microsoft Certification Excel Expert exam 77-728.
Read more.Instructor
Now following a career as a University Lecturer with over 20 years teaching experience, Dave previously managed and implemented major IT projects.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
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.
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.
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.
If you can master the practice projects included in this course you will be confident in your abilities to master the 77-728 exam.
New November 2018 – Additional Questions on CUBE Functions Added
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.
Our Promise to You
By the end of this course, you will have learned about Excel practice tests and video solutions.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the Excel practice tests and video solutions.
Course Curriculum
Section 1 - Introduction | |||
Introduction | 00:00:00 | ||
Course Structure And The Best Approach To Completing The Practice Exams Preview | 00:00:00 | ||
Special Exam Considerations | 00:00:00 | ||
How Is The Exam Conducted And What Will It Be Like? | 00:00:00 | ||
Section 2 - 77-728 Practice Exam 1: HelpLess Airlines | |||
Project 1 – Pilots And Passengers Solution | 00:00:00 | ||
Project 2 – Income Analysis Solution | 00:00:00 | ||
Project 3 – Sales Analysis Solution | 00:00:00 | ||
Project 4 – Pilot Performance Solution | 00:00:00 | ||
Project 5 – Monthly Merchandise Solution | 00:00:00 | ||
Section 3 - 77-728 Practice Exam 2: Event Management | |||
Project 1 – Event Details Solution | 00:00:00 | ||
Project 2 – Advertising Budgets Solution | 00:00:00 | ||
Project 3 – Event Planner Solution | 00:00:00 | ||
Project 4 – Manager Performance Solution | 00:00:00 | ||
Project 5 – Equipment Solution | 00:00:00 | ||
Section 4 - 77-728 Practice Exam 3: Multiple Disciplines | |||
Project 1 – Aircraft Parts Solution | 00:00:00 | ||
Project 2 – Allied Mortgage Lenders | 00:00:00 | ||
Project 3 – Concert Merchandise | 00:00:00 | ||
Project 4 – Mobile Homes Business | 00:00:00 | ||
Project 5 – Monogram Watch Company | 00:00:00 | ||
Project 6 – Staff Profiles Solution | 00:00:00 | ||
Section 5 - CUBE Functions: Special Questions | |||
CUBE Functions Questions | 00:00:00 | ||
Downloadable Materials: CUBE Functions Questions | 00:00:00 | ||
Downloadable Materials: Zipped Project Files | 00:00:00 | ||
Downloadable Materials: Website Links | 00:00:00 |