Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-09 18:58:15
30-Day Money-Back Guarantee

This course includes:

  • 9 hours on-demand video
  • 81 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
IT & Software IT Certification Microsoft Certification

77-728 Microsoft Excel 2016 Expert Certification

77-728 Microsoft Certified Excel Expert - includes lectures, test exercises and video solutions.
Rating: 4.1 out of 54.1 (404 ratings)
1,968 students
Created by Dave Murphy
Last updated 1/2021
English
30-Day Money-Back Guarantee

What you'll learn

  • You will be fully prepared to take the 77-728 MOS exam in Excel Expert
  • Be familiar with every aspect of the Objective domain for the 77-728 exam
  • Be expert in the advanced use of Microsoft Excel 2016
  • Be ready to pass the 77-728 exam
Curated for the Udemy for Business collection

Requirements

  • Some knowledge of Microsoft Excel 2016 is assumed. Access to a PC using Windows and a copy of Microsoft Excel 2016 is required.
  • Time to complete the lectures and exercises.
  • Please note that MOS exams are all Windows based. This course uses Excel in a Windows environment. Apple Mac users should note that there are differences between the Windows and Mac versions of Excel which are not covered in this course or in the exam.

Description

Some recent messages and reviews.....

From Amanda

"I studied Lynda and took the Excel Expert Exam and made a 389. I regrouped and bought Dave's study material, including the practice exams. I learned so much more material that wasn't covered on Lynda through Dave's videos. I took the exam three weeks after studying Dave's tutorials and passed the exam with a 795."

From Christie

"Dave,

Thanks for the great course! I easily passed the Excel Expert exam a couple weeks ago thanks to the materials covered in your course! The lectures were easy to understand and all of the content from your course very relevant in preparing for the exam.

Cheers!

Christie"

From Aicha

" I just passed the test today with 769 !! :) Just can't be happier. The course is really well structured and helpful especially the exercises at the end of each objective !! Thanks Dave , You did a great Job"

From Branislav

"Very specific and targeted topics. I believe it a must for all who attempt the exam."

From Taylor

I can't post it here but I will show my badge earned in the facebook group. I've been studying for roughly a month, with basic data entry experience, and a BCIS course I took in highschool. Needless to say I wasn't very well versed in excel to begin with, and now im an Excel Expert. Im always skeptical about what I buy and strive to recommend as little as possible to friends and family through fear of worth. But this course here is incredible and I can't thank Dave enough for the time and effort he put into it. I'm a bit of a talker to, and Dave was able to get back to me with answers regarding questions I had about the Exam in a very timely manner. Regards, Taylor"


Become a Microsoft Certified Excel Expert

Our Students Understand Value

This course will prepare you to take the 77-728 Excel Expert certification exam from Microsoft. Every aspect of the 77-728 exam is covered in detail, together with exercises and solutions. Delivered by a University professor with many years experience in teaching Excel to undergraduate students, and who is also a Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will enhance your chances of obtaining this valuable qualification. Prove your skills by obtaining independent certification from Microsoft.

This certification is highly regarded by employers because it is independent proof that you have the skills to become productive straight away. That saves a lot of time and effort on the employers part and that value that very highly indeed! The messages and reviews speak for themselves. Our mission is to make you succeed in passing the 77-728. You can do it with our help!

Who this course is for:

  • Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2016.
  • Students who have abilities in Excel and want to achieve independent recognition for those abilities
  • Students who have passed the 77-727 Core Excel exam and want to progress to the next level
  • Experts in Excel who would like to get their expertise recognised officially

Featured review

Farhad Hossain
Farhad Hossain
32 courses
11 reviews
Rating: 4.5 out of 54 days ago
Great course for a difficult exam. I found the course very practical and exam centric. Thanks to Dave for adding the clarification on the Cube function. Cube function was in my exam and I got it right.

Course content

22 sections • 77 lectures • 9h 13m total length

  • Preview02:49
  • Preview03:16
  • How is the exam be conducted and what will it be like?
    06:06
  • Try It Yourself Exercises
    01:18

  • 1.1.1 Save a Workbook as a Template
    02:55
  • 1.1.2 Copy Macros between Workbooks
    06:26
  • 1.1.3 Reference Data in Another Workbook
    09:33
  • 1.1.4 Reference Data by using Structured References
    07:53
  • 1.1.5 Enable Macros in a Workbook
    03:57
  • 1.1.6 Display Hidden Ribbon Tabs
    02:07

  • 1.2.1 Restrict Editing
    09:32
  • 1.2.2 Protect a Worksheet
    10:04
  • 1.2.3 Configure Formula Calculation Options
    02:50
  • 1.2.4 Protect Workbook Structure
    01:12
  • 1.2.5 Manage Workbook Versions
    06:00
  • 1.2.6 Encrypt a Workbook with a Password
    04:26

  • Domain Objective 1: Manage Workbook Options and Settings - Exercises & Solutions
    22:22

  • 2.1.1 Create Custom Number Formats
    13:01
  • 2.1.2 Populate Cells by using Advanced Fill Series Options
    07:10
  • 2.1.3 Configure Data Validation
    14:36

  • 2.2.1 Create Custom Conditional Formatting Rules
    05:09
  • 2.2.2 Create Conditional Formatting Rules that use Formulas
    03:23
  • 2.2.2 TIY Explanatory Lecture
    05:58
  • 2.2.3 Manage Conditional Formatting Rules
    03:56

  • 2.3.1 Create Custom Colour Formats
    03:15
  • 2.3.2 Create and Modify Cell Styles
    08:44
  • 2.3.3 Create and Modify Custom Themes
    07:54
  • 2.3.4 (Part I) Create and Modify Simple Macros
    06:49
  • 2.3.4 (Part II) Create and Modify Simple Macros
    08:15
  • Preview12:01
  • 2.3.5 (Part II) Insert and Configure Form Controls
    12:20
  • 2.3.5 (Part III) Insert and Configure Form Controls
    08:22

  • 2.4.1 and 2.4.2 Display Data in Multiple International Formats
    10:33
  • 2.4.3 Manage Multiple Options for +Body and +Heading Fonts
    02:47

  • Domain Objective 2 Apply Custom Data Formats and Layouts - Exercises & Solutions
    21:48

  • 3.1.1 Perform Logical Operations by using AND, OR, and NOT Functions
    05:55
  • 3.1.2 Perform Logical Operations by using Nested Functions
    06:44
  • 3.1.3 Perform Statistical Operations by using SUMIFS, AVERAGEIFS, and COUNTIFS
    04:42

Instructor

Dave Murphy
University Lecturer
Dave Murphy
  • 4.5 Instructor Rating
  • 2,435 Reviews
  • 9,935 Students
  • 17 Courses

With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.