About This Course

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

Section 1 - Introduction
Downloadable Materials 00:00:00
Introduction 00:00:00
Understanding The Objective Domain 00:00:00
How Is The Exam Be Conducted And What Will It Be Like? 00:00:00
Section 2 - Manage Workbooks
Save A Workbook As A Template 00:00:00
Copy Macros Between Workbooks 00:00:00
Reference Data In Another Workbook 00:00:00
Reference Data By Using Structured References 00:00:00
Display Hidden Ribbon Tabs 00:00:00
Section 3 - Manage Workbook Review
Restrict Editing 00:00:00
Protect A Worksheet 00:00:00
Configure Formula Calculation Options 00:00:00
Protect Workbook Structure 00:00:00
Manage Workbook Versions 00:00:00
Encrypt A Workbook With A Password 00:00:00
Section 4 - Objective Domain 1: Exercises & Solutions
Domain Objective 1: Manage Workbook Options And Settings – Exercises And Solutions 00:00:00
Section 5 - Apply Custom Data Formats And Validation
Create Custom Number Formats – Part 1 00:00:00
Create Custom Number Formats – Part 2 00:00:00
Populate Cells By Using Advanced Fill Series Options 00:00:00
Issues With Auto-Fill Using Dates 00:00:00
Configure Data Validation 00:00:00
Section 6 - Apply Advanced Conditional Formatting And Filtering
Create Custom Conditional Formatting Rules 00:00:00
Create Conditional Formatting Rules That Use Formulas 00:00:00
Manage Conditional Formatting Rules 00:00:00
Section 7 - Create And Modify Custom Workbook Elements
Create Custom Color Formats 00:00:00
Create And Modify Cell Styles 00:00:00
Create And Modify Custom Themes 00:00:00
Create And Modify Simple Macros – Part 1 00:00:00
Create And Modify Simple Macros – Part 2 00:00:00
Insert And Configure Form Controls – Part 1 00:00:00
Insert And Configure Form Controls – Part 2 00:00:00
Insert And Configure Form Controls – Part 3 00:00:00
Section 8 - Prepare A Workbook For Internationalisation
Display Data In Multiple International Formats 00:00:00
Manage Multiple Options For Body And Heading Fonts 00:00:00
Section 9 - Domain Objective 2: Exercises And Solutions
Domain Objective 2: Apply Custom Data Formats And Layouts – Exercises And Solutions 00:00:00
Section 10 - Apply Functions In Formulas
Perform Logical Operations By Using And, Or, And Not Functions 00:00:00
Perform Logical Operations By Using Nested Functions 00:00:00
Perform Statistical Operations By Using Sumifs, Averageifs, And Countifs 00:00:00
Section 11 - Look Up Data By Using Functions
Look Up Data By Using The VLOOKUP And HLOOKUP Functions 00:00:00
Look Up Data By Using The Index And Match Functions 00:00:00
Section 12 - Apply Advanced Date And Time Functions
Now, Today Functions And Serialize Numbers 00:00:00
Section 13 - Perform Data Analysis And Business Intelligence
Introduction To Domain Objective 00:00:00
Connecting To Data With Power Pivot 00:00:00
More On Power Pivot 00:00:00
Measures 00:00:00
Get And Transform 00:00:00
Consolidate Data 00:00:00
Perform What-If Analysis By Using Goal Seek And Scenario Manager 00:00:00
Cube Functions – Part 1 00:00:00
Cube Functions – Part 2 00:00:00
Cube Functions – Part 3 00:00:00
Calculate Data By Using Financial Functions 00:00:00
Section 14 - Troubleshoot Formulas
Trace Precedence And Dependence 00:00:00
Monitor Cells And Formulas By Using The Watch Window 00:00:00
Validate Formulas By Using Error Checking Rules 00:00:00
Evaluate Formulas 00:00:00
Section 15 - Define Named Ranges And Objects
Name Cells And Data Ranges 00:00:00
Name Tables 00:00:00
Manage Named Ranges And Objects 00:00:00
Section 16 - Domain Objective 3: Exercises And Solutions
Domain Objective 3: Create Advanced Formulas – Exercises And Solutions 00:00:00
Section 17 - Create Advanced Charts
Add Trend-Lines To Charts 00:00:00
Create Dual-Axis Charts 00:00:00
Save A Chart As A Template 00:00:00
Section 18 - Create And Manage Pivot Tables
Create Pivot Tables 00:00:00
Modify Field Selections And Options 00:00:00
Create Slicers 00:00:00
Group Pivot Table Data 00:00:00
Reference Data In A Pivot Table By Using The Getpivotdata Function 00:00:00
Add Calculated Fields 00:00:00
Format Data 00:00:00
Section 19 - Create And Manage Pivot Charts
Create Pivot Charts 00:00:00
Manipulate Options In Existing Pivot Charts 00:00:00
Apply Styles To Pivot Charts 00:00:00
Drill Down Into Pivot Chart Details 00:00:00
Section 20 - Domain Objective 4: Exercises And Solutions
Domain Objective 4: Create Advanced Charts And Tables – Exercises And Solutions 00:00:00
Section 21 - Cube Function Special Lecture
Cube Function 00:00:00
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel