Microsoft Excel Expert Exam 77-728: Complete Techniques

No Rating(0)
See all reviews

This course is designed for those interested to learn the basics of complete techniques to pass the Microsoft Excel Expert Exam and be an expert in the advanced use of Microsoft Excel.

Watch Free For 30 Days

start free access


buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This CourseBeginner

New November 2018 – Special CUBE Functions Questions Added

This course will prepare you to take the 77-728 Excel Expert certification exam from Microsoft. Every aspect of the 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.

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 recognized officially

Our Promise to You

By the end of this course, you will have learned the complete techniques for the Microsoft Excel Expert Exam

30 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 complete techniques for the Microsoft Excel Expert Exam

Course Curriculum

Course Sections

Downloadable Materials


Understanding The Objective Domain

How Is The Exam Be Conducted And What Will It Be Like?

Save A Workbook As A Template

Copy Macros Between Workbooks

Reference Data In Another Workbook

Reference Data By Using Structured References

Display Hidden Ribbon Tabs

Restrict Editing

Protect A Worksheet

Configure Formula Calculation Options

Protect Workbook Structure

Manage Workbook Versions

Encrypt A Workbook With A Password

Domain Objective 1: Manage Workbook Options And Settings – Exercises And Solutions

Create Custom Number Formats – Part 1

Create Custom Number Formats – Part 2

Populate Cells By Using Advanced Fill Series Options

Issues With Auto-Fill Using Dates

Configure Data Validation

Create Custom Conditional Formatting Rules

Create Conditional Formatting Rules That Use Formulas

Manage Conditional Formatting Rules

Create Custom Color Formats

Create And Modify Cell Styles

Create And Modify Custom Themes

Create And Modify Simple Macros – Part 1

Create And Modify Simple Macros – Part 2

Insert And Configure Form Controls – Part 1

Insert And Configure Form Controls – Part 2

Insert And Configure Form Controls – Part 3

Display Data In Multiple International Formats

Manage Multiple Options For Body And Heading Fonts

Domain Objective 2: Apply Custom Data Formats And Layouts – Exercises And Solutions

Perform Logical Operations By Using And, Or, And Not Functions

Perform Logical Operations By Using Nested Functions

Perform Statistical Operations By Using Sumifs, Averageifs, And Countifs

Look Up Data By Using The VLOOKUP And HLOOKUP Functions

Look Up Data By Using The Index And Match Functions

Now, Today Functions And Serialize Numbers

Introduction To Domain Objective

Connecting To Data With Power Pivot

More On Power Pivot


Get And Transform

Consolidate Data

Perform What-If Analysis By Using Goal Seek And Scenario Manager

Cube Functions – Part 1

Cube Functions – Part 2

Cube Functions – Part 3

Calculate Data By Using Financial Functions

Trace Precedence And Dependence

Monitor Cells And Formulas By Using The Watch Window

Validate Formulas By Using Error Checking Rules

Evaluate Formulas

Name Cells And Data Ranges

Name Tables

Manage Named Ranges And Objects

Domain Objective 3: Create Advanced Formulas – Exercises And Solutions

Add Trend-Lines To Charts

Create Dual-Axis Charts

Save A Chart As A Template

Create Pivot Tables

Modify Field Selections And Options

Create Slicers

Group Pivot Table Data

Reference Data In A Pivot Table By Using The Getpivotdata Function

Add Calculated Fields

Format Data

Create Pivot Charts

Manipulate Options In Existing Pivot Charts

Apply Styles To Pivot Charts

Drill Down Into Pivot Chart Details

Domain Objective 4: Create Advanced Charts And Tables – Exercises And Solutions

Cube Function


No Reviews found for this course.