Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Microsoft
Exam Format
50 min
20-35 tasks
700
Expert
Registration
$150 USD
Pearson VUE, Certiport, or online proctoring
English, Spanish, French, German +9 more
Validity
Lifetime (no expiration)
Not required - lifetime certification; Consider upgrading to MO-211 for current Excel version
77-427 Exam Topics and Domains
77-427 is organized into 4 weighted domains. Expect to work with Developer tab, Financial Functions, Lookup & Reference Functions, Array Functions, and more.
1
Manage and Share Workbooks
20%
Apply Workbook Settings, Properties, and Data Options
Set Advanced PropertiesSave a Workbook as a TemplateImport and Export XML Data
- Apply advanced workbook properties and settings
- Create and manage workbook templates
- Work with XML data structures
Apply Protection and Sharing Properties to Workbooks and Worksheets
Encrypt Workbooks with PasswordsProtect Worksheet StructureConfigure Workbook Sharing PropertiesMark as Final
- Implement comprehensive workbook security
- Configure sharing and collaboration features
- Manage document protection levels
Maintain Shared Workbooks
Track ChangesMerge WorkbooksSet Tracking Options
- Manage collaborative workbook editing
- Track and review document changes
- Merge multiple workbook versions
2
Apply Custom Formats and Layouts
25%
Apply Custom Data Formats and Validation
Create Custom Number FormatsApply Data ValidationUse Advanced Date and Time FormatsApply Accounting Number Format
- Create and apply custom number formats
- Implement data validation rules
- Format data for specific business needs
Apply Advanced Conditional Formatting and Filtering
Write Custom Conditional Formatting RulesUse Functions to Format CellsCreate Advanced FiltersManage Conditional Formatting Rules
- Create complex conditional formatting
- Apply advanced filtering techniques
- Manage multiple formatting rules
Prepare Workbooks for Internationalization and Accessibility
Configure International SettingsPrepare for Multiple LanguagesApply Accessibility FeaturesModify Workbook Structure for Accessibility
- Configure workbooks for international use
- Implement accessibility features
- Support multiple languages and regions
Apply and Manipulate Custom Workbook Elements and Document Properties
Create Custom Color SchemesCreate Cell StylesCreate and Modify Simple MacrosInsert and Configure Form Controls
- Customize workbook appearance
- Create and apply custom styles
- Add interactive elements to workbooks
3
Create Advanced Formulas
30%
Apply Functions in Formulas
Use LOOKUP FunctionsUse INDEX and MATCH FunctionsUse TRANSPOSE FunctionUse OFFSET and INDIRECT Functions
- Master lookup and reference functions
- Create dynamic formula references
- Implement complex data retrieval
Apply Advanced Date and Time Functions
Use NOW and TODAY FunctionsSerialize Dates and TimesUse WORKDAY and NETWORKDAYS FunctionsCalculate Time Differences
- Perform complex date and time calculations
- Work with business day functions
- Handle time-based data analysis
Apply Advanced Statistical Functions
Use SUMIFS, COUNTIFS, and AVERAGEIFSApply Statistical Analysis FunctionsUse Database FunctionsPerform What-If Analysis
- Apply multi-criteria statistical functions
- Perform statistical analysis
- Use database and what-if analysis tools
Apply Advanced Financial Functions
Calculate Loan Payments and InterestPerform Investment AnalysisCalculate Depreciation
- Perform financial calculations
- Analyze loans and investments
- Calculate depreciation schedules
Apply Text and Logical Functions
Manipulate Text with FunctionsUse Nested IF StatementsApply AND, OR, and NOT Functions
- Manipulate text data with functions
- Create complex logical formulas
- Combine multiple conditions
Create and Modify Array Formulas
Create Array FormulasUse Array Constants
- Create and manage array formulas
- Perform array calculations
- Use array constants effectively
4
Create Advanced Charts and Tables
25%
Create and Modify Advanced Charts
Add Trendlines to ChartsCreate Dual-Axis ChartsBuild Combination ChartsCreate Custom Chart Templates
- Create complex chart visualizations
- Add analytical elements to charts
- Customize chart appearance and behavior
Create and Modify PivotTables
Create PivotTablesModify Field Settings and OptionsCreate Calculated Fields and ItemsGroup PivotTable DataUse Slicers and Timeline FiltersCreate PivotCharts
- Create and customize PivotTables
- Add calculations and groupings
- Implement interactive filtering
- Create PivotCharts from PivotTables
Create and Manage Tables
Convert Data to TablesApply Table Styles and OptionsUse Structured ReferencesCreate Calculated Columns
- Create and format Excel tables
- Use structured references in formulas
- Add calculations to tables
Create Sparklines
Insert SparklinesCustomize Sparklines
- Create mini-charts within cells
- Customize sparkline appearance
- Use sparklines for data trends
How do I earn this certification?
Passing 77-427 earns the Microsoft Office Specialist: Excel 2013 Expert certification. It sits in the Microsoft Office Specialist (MOS) track.
Current Level Exams
77-428 - Excel 2013 Expert Part Two
Alternative Paths
- MO-201 - Microsoft Excel Expert (Excel 2019)Alternative for Excel 2019 users
- DA-100 - Analyzing Data with Microsoft Power BIAdvanced data analysis and visualization
- PL-300 - Microsoft Power BI Data AnalystModern business intelligence path
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for 77-427 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- RETIRED
- Last content update: 2023-12-31
- Announcement date: 2024-01-15
Updates
- Excel 2013 15.0 Exam content frozen at 2013 feature set • Release date: 2013-01-29
- VBA in Excel 2013
- Power Query
Who should take this exam?
This exam is typically taken by Financial Analysts and Data Analysts.
- Advanced understanding of Excel environment
- 2-3 years of Excel experience
- Completion of Excel 2013 Core certification (77-420) recommended