Microsoft Excel Expert Exam 77-728: Complete Techniques
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. Read more.
Course Skill Level
Beginner
Time Estimate
9h 18m
Now following a career as a University Lecturer with over 20 years teaching experience, Dave previously managed and implemented major IT projects.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout 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
10 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 | ||
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
10 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 | ||
Related Courses
Are you interested in higher education?
© 2024 SKILLSUCCESS
All Rights Reserved