Exam Name: Microsoft Excel Expert (Excel and Excel 2019)
Exam Code: 77-728
Related Certification(s): Microsoft Office Specialist: Excel Expert
Certification Provider: Microsoft
Actual Exam Duration: 50 Minutes
Number of 77-728 practice questions in our database: 26

Expected 77-728 Exam Topics, as suggested by Microsoft:

Topic 1: Managing Workbooks and Options

• Managing workbook properties and options
• Configuring advanced workbook settings
• Protecting workbooks and tracking changes
• Managing multiple workbooks efficiently

Topic 2: Applying Custom Formatting and Layouts

• Using custom number formats and advanced formatting
• Applying conditional formatting with complex criteria
• Creating and modifying cell styles and themes
• Managing advanced cell alignment and data presentation

Topic 3: Working with Advanced Formulas and Functions

• Using logical, statistical, and financial functions
• Applying advanced lookup and reference functions (INDEX, MATCH, OFFSET)
• Implementing array formulas and dynamic ranges
• Using text functions for data manipulation

Topic 4: Creating Advanced Charts and Data Visualizations

• Designing and modifying advanced charts
• Implementing trendlines and forecasting models
• Using sparklines and custom visual elements
• Applying interactive data visualizations with slicers and timelines

Topic 5: Managing Advanced Data Operations

• Importing, transforming, and consolidating data
• Using advanced filtering and sorting techniques
• Creating and managing PivotTables and PivotCharts
• Implementing Power Query and Power Pivot features

Topic 6: Working with Macros and Automation

• Recording and running basic macros
• Assigning macros to buttons and form controls
• Editing VBA code for automation
• Using iterative calculations and circular references

Topic 7: Managing Collaboration and Security

• Configuring shared workbooks and co-authoring
• Managing data validation and error-checking tools
• Protecting sheets and restricting editing rights
• Managing digital signatures and encryption