77-728 Microsoft Excel 2016 Expert Certification from Udemy

New. Udemy for Business Students

Please note that our course entitled 77-728 Excel 2016 Expert Practice Tests and Video Solutions is now available to supplement your learning path to success in the 77-728 Certification exam. This course has an additional two practice exams together with video solutions to allow you to ensure your certification at the first attempt. Just search for 77-728 and you should see it listed.

Important Course Update 2023

We've added some very valuable resources to the course in 2023. An additional section entitled "Practice Exam and Video Solutions" has been included at the end of the course. This section includes a complete practice exam set to the standard of the 77-728 exam. This consists of 5 exam projects together with a video solution for each. Don't review the solutions until you make an attempt at the exam project exercises. This will give you a very real sense of how well prepared you are for the 77-728 expert certification exam.

We've also added a new lecture within this section entitled "Special Exam Considerations". This lecture summarizes some important points about this specific exam that you need to consider carefully. The suggestions are based on direct student experience in taking the exam. In particular we focus on:

Technical issues which arise with the exam interfaceBeing strategic in your preparation and focus The best approach to the use of formulasUse of shortcut keys Using the 'Mark for Review' optionIssues with the exam interface Coping with nerves

Lots of really good practical exam advice.

Become a Microsoft Certified Excel Expert

Our Students Understand Value

Expert-level candidates for the Microsoft Excel 2016 exam have an advanced understanding of the Excel environment, and the ability to guide others to the proper use of the program’s features. They can create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They can customize their Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidate roles may include accountants, financial analysts, data analysts, commercial bankers, and others.

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.

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 I'm an Excel Expert. I'm 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

What's inside

Learning objectives

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

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

Syllabus

Course Introduction

This lecture has three associated resources:

1. The Objective Domain for the 77-728 exam. This lists all of the elements which Microsoft require you to master. The course lectures adopt the numbering system used in the Objective Domain document.

2. Course Exercise Book. This consolidates all of the exercises provided in the course for each of the four sections in the Objective Domain. We've provided it in this format should you want to print it down for reference as you continue through the course. These are the same exercises provided explicitly at the end of each section of the course and are provided here for convenience.

3. 77-728 Student Resource Files. This zipped file has the required resource files needed to complete the Course Exercise Book.

Note that if you are registered as a 'Udemy for Business' student make sure to check out our 77-728 Practice Exams and Video Solutions course which will provide you with additional practice opportunities.

This lecture describes how to create a workbook template.

If you are new to Macros in Excel then it would be best for you to review Lecture 2.3.4 first.

Having completed this lecture you should make sure you know how to copy a macro by using the file provided as a resource and copying the macro to a new workbook.

Linking and consolidating workbooks

Structured references are formulas which reference table names.

How to manage and display hidden Excel commands

See 1.2.2 for associated TIY exercise

Essential methods for protecting worksheets

Describes the optional setting for Calculation of Formulas

You can opt to protect just the structure of a workbook

How to manage and track changes to shared workbooks

Adding password protection at a number of levels can ensure the security of your workbooks

Learn how to create custom formats. Quite a lot in this lecture. Use the Try It Yourself exercise to test your understanding.

Part I of the lecture on creating and modifying macros

Logical Functions of AND, OR and NOT

Using Nested Functions to create complex formulas

SUMIF, AVERAGEIFS and COUNTIFS allow for powerful multi conditional formulas

This lecture explains how to use Vlookup and Hlookup functions to search and retrieve information. It is a rather long lecture, and some of the material is difficult. Stick with it and ensure you try out the examples for yourself.

This is an important lecture as it explains the order in which you should study the material in the Domain Objective 3.4 Listen carefully and do not attempt 3.4.1 until you have completed Domain Objective 4.2 on Pivot Tables!

This is an area that you need to study. It's relatively easy and comes up on the exam quite a lot.

See 3.6.4 for TIY Exercises

This lecture describes how to create and modify trendlines in charts.

This lecture covers how to use dual axes and combo charts to create understandable charts using complex data.

This lecture explains how to create and manage Chart Templates

This lecture explains how to create Pivot Tables

How to format information on a Pivot Table

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Prepares learners to take the 77-728 Excel Expert certification exam, providing independent proof of skills valued by employers

Includes practice exam projects and video solutions, allowing learners to gauge their preparedness for the 77-728 expert certification exam

Delivered by a university professor with experience teaching Excel and as a Microsoft Office Specialist examiner, enhancing the chances of obtaining the qualification

Covers every aspect of the 77-728 exam in detail, together with exercises and solutions, ensuring comprehensive preparation

Includes a section summarizing important points about the exam based on student experience, such as technical issues and strategic preparation

Focuses on Microsoft Excel 2016, which may not be the most current version, so learners should verify its relevance to their needs

Reviews summary

Expert excel certification preparation

According to students, this course is highly effective for preparing for the 77-728 Microsoft Excel Expert certification exam. Learners report significant score improvements and state they were able to easily pass the exam after taking the course. Key features highlighted include well-structured lectures and exercises, especially the practice exams and video solutions, which are seen as very helpful and provide a real sense of preparation. Students also appreciated the instructor's timely support.

Instructor is responsive and helpful.

"...Dave was able to get back to me with answers regarding questions I had about the Exam in a very timely manner."

Course content is organized and easy to follow.

"The course is really well structured and helpful especially the exercises at the end of each objective."

"The lectures were easy to understand and all of the content from your course very relevant..."

"Very specific and targeted topics."

Exercises and practice exams aid understanding.

"The course is really well structured and helpful especially the exercises at the end of each objective."

"We've added some very valuable resources... A complete practice exam set... together with a video solution for each."

"This will give you a very real sense of how well prepared you are for the 77-728 expert certification exam."

Highly effective for passing the MOS Excel Expert exam.

"I easily passed the Excel Expert exam a couple weeks ago thanks to the materials covered in your course."

"I studied Lynda and took the Excel Expert Exam and made a 389. I regrouped and bought Dave's study material... and passed the exam with a 795."

"The lectures were easy to understand and all of the content from your course very relevant in preparing for the exam."

"This course will prepare you to take the 77-728 Excel Expert certification exam from Microsoft."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in 77-728 Microsoft Excel 2016 Expert Certification with these activities:

Review Excel Fundamentals

Show steps

Reinforce foundational Excel skills to ensure a solid base for mastering advanced topics covered in the expert certification course.

Browse courses on Excel Basics

Show steps

Review basic formulas and functions.
Practice data entry and formatting.
Familiarize yourself with the Excel interface.

Read 'Excel 2016 Bible'

Show steps

Supplement course materials with a comprehensive guide to Excel 2016, enhancing understanding of advanced features and functions.

View Excel 2016 Bible on Amazon

Show steps

Read chapters related to advanced formulas and data analysis.
Practice the examples provided in the book.
Refer to the book when encountering difficulties in the course.

Study 'Microsoft Excel Data Analysis and Business Modeling'

Show steps

Deepen understanding of data analysis and business modeling techniques by studying a specialized book on the topic.

View Microsoft Excel Data Analysis and Business... on Amazon

Show steps

Read chapters related to data analysis and business modeling.
Work through the examples and exercises in the book.
Apply the techniques to your own data sets.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Follow Advanced Excel Tutorials

Show steps

Refine skills and explore advanced Excel features by following guided tutorials on topics such as Power Pivot, macros, and data validation.

Show steps

Search for tutorials on specific topics covered in the course.
Follow the tutorial steps and practice the techniques.
Adapt the techniques to your own projects and scenarios.

Create a Macro-Enabled Tool

Show steps

Reinforce macro skills by developing a custom Excel tool that automates a repetitive task or simplifies a complex process.

Show steps

Identify a task that can be automated with macros.
Plan the functionality and user interface of the tool.
Write and test the macro code.
Document the tool and its usage.

Complete Practice Exams

Show steps

Solidify knowledge and improve exam readiness by completing practice exams that simulate the actual 77-728 Excel Expert certification exam.

Show steps

Download and complete practice exam files.
Review answers and identify areas for improvement.
Repeat practice exams until a consistent passing score is achieved.

Build a Financial Model

Show steps

Apply learned skills by creating a complex financial model that incorporates advanced formulas, data analysis, and charting techniques.

Show steps

Define the scope and objectives of the financial model.
Gather relevant data and input it into Excel.
Implement advanced formulas and functions to perform calculations.
Create charts and graphs to visualize the results.

Career center

Learners who complete 77-728 Microsoft Excel 2016 Expert Certification will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data analysts rely on programs like Microsoft Excel to organize, interpret, and present data. In this role, the ability to create, manage, and distribute professional spreadsheets is essential. This course prepares a data analyst to effectively use Excel for a variety of analytical tasks, such as applying conditional formatting and filtering as well as performing data analysis and business intelligence. The course provides practice in creating formulas for analyzing data, using lookup functions, and preparing workbooks for internationalization which are all highly relevant skills in this role.

See salaries and explore the career path for Data Analyst

Financial Analyst

A financial analyst utilizes tools like Microsoft Excel to create financial models, analyze data, and make recommendations. This course helps a financial analyst manage and distribute professional spreadsheets tailored to specialized purposes, as well as customize Excel environments. This course covers a range of Excel features needed to create amortization tables, financial charts, and perform data analysis, all skills that assist in a financial analyst's day-to-day work. The course includes materials that help build a foundation in data analysis, formulas, and financial functions.

See salaries and explore the career path for Financial Analyst

Business Intelligence Analyst

A Business Intelligence Analyst leverages data to inform business decisions and strategies, and this often involves advanced use of tools such as Microsoft Excel. This course helps the Business Intelligence Analyst perform what-if analysis through goal seek and scenario manager, in addition to consolidating data for business intelligence. The course also builds knowledge in using cube functions, creating pivot tables, and working with Power Pivot, all of which are vital tasks for a Business Intelligence Analyst, making this course a valuable aid.

See salaries and explore the career path for Business Intelligence Analyst

Accountant

An accountant uses spreadsheets extensively, for tasks like managing financial records, preparing reports, and performing audits. This course assists accountants in gaining command of Microsoft Excel, allowing them to create custom business templates, manage workbooks, and utilize advanced formulas. The course covers essential topics that an accountant can utilize such as macros, data validation, and financial functions. Learning these tools can help increase efficiency and accuracy in handling financial data for an accountant.

See salaries and explore the career path for Accountant

Market Research Analyst

Market research analysts use data analysis to understand consumer behavior and market trends. This Microsoft Excel course is useful for a market research analyst as it covers using Excel to apply custom data formats, configure data validation, and create custom charts. Tools such as conditional formatting, filtering, and data consolidation are also taught in this course, which a market research analyst can use in data processing and reporting. These skills make this course relevant to any market research analyst.

See salaries and explore the career path for Market Research Analyst

Commercial Banker

A commercial banker uses financial analysis and modeling to assess risk and make lending decisions and often leverages Microsoft Excel for spreadsheet creation and analysis. This course is useful for a commercial banker, as it provides the tools and skills to manage financial workbooks, perform what if analysis, and calculate results by applying financial functions. The focus on financial functions and data analysis in this course helps a commercial banker to create custom financial templates and perform complex analyses.

See salaries and explore the career path for Commercial Banker

Operations Analyst

An operations analyst is responsible for improving the efficiency and effectiveness of an organization's operations. This role requires an understanding of data analysis, which this course provides within the scope of Microsoft Excel. Through this course an operations analyst can learn how to use Excel to perform data analysis, create custom business templates, and manage and protect workbooks. The course’s instruction on macros and conditional formatting can further increase the ability of an operations analyst to work with complex data.

See salaries and explore the career path for Operations Analyst

Management Consultant

Management consultants analyze business problems and propose solutions, which often requires data analysis and presentation skills using tools like Microsoft Excel. This course helps a management consultant develop high level Excel skills, including preparing spreadsheets for internationalization, creating custom charts, and building pivot tables for data analysis. The course emphasizes the creation of complex formulas, macros, and data validation techniques, which are applicable in any management consulting project.

See salaries and explore the career path for Management Consultant

Project Manager

While Project Managers don't always perform data analysis directly, they can benefit from a strong understanding of managing project-related data using tools like Microsoft Excel. This course helps a project manager to manage workbook review, protect worksheets, and track changes, all of which are valuable skills in managing project resources. The course's focus on structured references, macros, and data validation, paired with skills like managing hidden commands, are aspects that enhance a project manager’s ability to utilize spreadsheets effectively.

See salaries and explore the career path for Project Manager

Budget Analyst

Budget analysts are in charge of preparing and examining budgets, seeking to make sure that funds are allocated properly. This course may be useful for a budget analyst as it covers a range of skills in Microsoft Excel, such as creating custom business templates, using functions for complex formulas, and performing what-if analysis. These skills can help a budget analyst in managing financial information, performing data analysis, and presenting findings using charts. This can allow budget analysts to work with more data, and with more efficient workflows.

See salaries and explore the career path for Budget Analyst

Quantitative Analyst

A quantitative analyst develops and implements mathematical and statistical models, often using advanced tools such as Microsoft Excel. While this role typically requires an advanced degree, this course may be useful by building skills in areas like creating complex formulas, performing data analysis, and using financial functions. The course content in areas such as using lookup functions and performing what-if analysis can serve as a strong foundation for more advanced data modeling.

See salaries and explore the career path for Quantitative Analyst

Sales Analyst

A sales analyst is in charge of analyzing sales data to improve performance and strategy, which means using tools like Microsoft Excel for data management and reporting. This course could be useful as it helps sales analysts learn to apply custom data formats, utilize conditional formatting, and perform data analysis. The course’s focus on creating advanced charts and tables and using data consolidation tools can be quite useful in creating reports for leadership.

See salaries and explore the career path for Sales Analyst

Market Analyst

Market analysts study market conditions to inform business decisions, and they often use Microsoft Excel for data analysis and reporting. This course may be helpful for a market analyst, as it covers essential topics like creating custom data formats, using lookup functions, and creating advanced charts. The course includes content that builds skills in data consolidation and using pivot tables, which can help a market analyst generate reports relevant to market trends.

See salaries and explore the career path for Market Analyst

Logistics Analyst

Logistics analysts improve an organization's supply chain operations, and this often includes data analysis using tools like Microsoft Excel. This course may be useful for a logistics analyst as it helps to build skills in managing workbooks, utilizing conditional formatting, and creating custom charts. The course specifically covers how to use formulas and lookup functions, which can be used to analyze logistics data, and track key performance indicators.

See salaries and explore the career path for Logistics Analyst

Research Associate

Research associates often work with large data sets and utilize tools like Microsoft Excel for data cleaning, organization, and basic analysis. Although many research settings utilize other tools, this course may be useful for a research associate, as it may help build skills in managing workbooks, applying custom data formats, and performing data analysis using Excel functions. The course provides a broad foundation in Excel features that can help research associates become more efficient in their day-to-day tasks.

See salaries and explore the career path for Research Associate

77-728 Microsoft Excel 2016 Expert Certification

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Expert excel certification preparation

Activities

Career center

Reading list

Share

Similar courses