Microsoft Excel Expert Exam 77-728: Complete Techniques

This course includes lifetime access so you can complete it at your own speed.

This 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.

Benefits of taking this course include:

• Unlimited and lifetime access to the course
• Learn the course at your own pace
• Course can be accessed on any platform
• 24/7 Customer support

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

The Complete Techniques For The MOS Excel Expert Examwill cover the following topics:

Section 1 - Introduction

• Introduction
• Understanding The Objective Domain
• How Is The Exam Be Conducted And What Will It Be Like?

Section 2 - Manage Workbooks

• 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

Section 3 - Manage Workbook Review

• Restrict Editing
• Protect A Worksheet
• Configure Formula Calculation Options
• Protect Workbook Structure
• Manage Workbook Versions
• Encrypt A Workbook With A Password

Section 4 - Objective Domain 1: Exercises And Solutions

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

Section 5 - Apply Custom Data Formats And Validation

• 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

Section 6 - Apply Advanced Conditional Formatting And Filtering

• Create Custom Conditional Formatting Rules
• Create Conditional Formatting Rules That Use Formulas
• Manage Conditional Formatting Rules

Section 7 - Create And Modify Custom Workbook Elements

• 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

Section 8 - Prepare A Workbook For Internationalization

• Display Data In Multiple International Formats
• Manage Multiple Options For Body And Heading Fonts

Section 9 - Domain Objective 2: Exercises And Solutions

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

Section 10 - Apply Functions In Formulas

• 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

Section 11 - Look Up Data By Using Functions

• Look Up Data By Using The VLOOKUP And HLOOKUP Functions
• Look Up Data By Using The Index And Match Functions

Section 12 - Apply Advanced Date And Time Functions

• Now, Today Functions And Serialize Numbers

Section 13 - Perform Data Analysis And Business Intelligence

• Introduction To Domain Objective
• Connecting To Data With Power Pivot
• More On Power Pivot
• Measures
• 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

Section 14 - Troubleshoot Formulas

• Trace Precedence And Dependence
• Monitor Cells And Formulas By Using The Watch Window
• Validate Formulas By Using Error Checking Rules
• Evaluate Formulas

Section 15 - Define Named Ranges And Objects

• Name Cells And Data Ranges
• Name Tables
• Manage Named Ranges And Objects

Section 16 - Domain Objective 3: Exercises And Solutions

• Domain Objective 3: Create Advanced Formulas – Exercises And Solutions

Section 17 - Create Advanced Charts

• Add Trend-Lines To Charts
• Create Dual-Axis Charts
• Save A Chart As A Template

Section 18 - Create And Manage Pivot Tables

• 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

Section 19 - Create And Manage Pivot Charts

• Create Pivot Charts
• Manipulate Options In Existing Pivot Charts
• Apply Styles To Pivot Charts
• Drill Down Into Pivot Chart Details

Section 20 - Domain Objective 4: Exercises And Solutions

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

Section 21 - Cube Function Special Lecture

• Cube Function

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.

Some knowledge of Microsoft Excel 2016 is assumed. Access to a PC using Windows and a copy of Microsoft Excel 2016 is required.

None

Currently there are no Q&As for this course. Be the first to ask a question.

Certificate of completion

Digital certificate - Included