77-428-complete
Microsoft Excel 2013 (MOS) Expert Part 2
Prepare for the Microsoft 77-428 exam with the MOS Excel 2013 Expert Part 2 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Office training course covers the Excel expert exam objectives and provides skills to manage and share workbooks, apply custom formats and layouts, and more. The Microsoft Excel certification course and lab also include topics such as custom business templates, multiple axis financial charts, and more.
- Practice in 9 Hands-On Labs — nothing to install
- 11 Interactive Lessons and 53 topics mapped to the official exam objectives
- 127 Practice Test Questions and 2 Full Length Tests
Intermediate Self-paced · 1 year access 4.1/5 (244 Reviews)
9 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Skills you'll get
What you will be able to do
Target Career Roles
- Accountant
- Data Analyst
- Financial Analyst
- Information Worker
- Commercial Banker
- Program/Project Manager
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
11 Interactive Lessons · 53 topics01 Linking and Consolidating Worksheets 5 topics +
- Linking Workbooks
- Creating External Reference Formulas
- Working with External Reference Formulas
- Avoiding Potential Problems with External Reference Formulas
- Consolidating Worksheets
02 Protecting Your Work 5 topics · 2 LiveLab +
- Types of Protection
- Protecting a Worksheet
- Protecting a Workbook
- VB Project Protection
- Related Topics
2 LiveLab in this lesson — see the labs panel →
03 Making Your Worksheets Error Free 5 topics · 4 LiveLab +
- Finding and Correcting Formula Errors
- Using Excel Auditing Tools
- Searching and Replacing
- Spell-Checking Your Worksheets
- Using AutoCorrect
4 LiveLab in this lesson — see the labs panel →
04 Using Custom Number Formats 3 topics +
- About Number Formatting
- Creating a Custom Number Format
- Custom Number Format Examples
05 Using and Creating Templates 2 topics +
- Exploring Excel Templates
- Understanding Custom Excel Templates
06 Creating Formulas That Count and Sum 6 topics · 2 LiveLab +
- Counting and Summing Worksheet Cells
- Basic Counting Formulas
- Advanced Counting Formulas
- Summing Formulas
- Conditional Sums Using a Single Criterion
- Conditional Sums Using Multiple Criteria
2 LiveLab in this lesson — see the labs panel →
07 Performing Spreadsheet What-If Analysis 2 topics +
- A What-If Example
- Types of What-If Analysis
08 Analyzing Data Using Goal Seeking and Solver 4 topics +
- What-If Analysis, in Reverse
- Single-Cell Goal Seeking
- Introducing Solver
- Solver Examples
09 Creating Formulas for Financial Applications 4 topics · 1 LiveLab +
- The Time Value of Money
- Loan Calculations
- Investment Calculations
- Depreciation Calculations
1 LiveLab in this lesson — see the labs panel →
10 Introducing Pivot Tables 5 topics +
- About Pivot Tables
- Creating a Pivot Table Automatically
- Creating a Pivot Table Manually
- More Pivot Table Examples
- Learning More
11 Analyzing Data with Pivot Tables 12 topics +
- Working with Non-Numeric Data
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Filtering Pivot Tables with a Timeline
- Referencing Cells within a Pivot Table
- Creating Pivot Charts
- Another Pivot Table Example
- Producing a Report with a Pivot Table
- Using the Data Model
- Learning More about Pivot Tables
Hands-On Labs Our edge
9 LiveLabs- Checking a workbook for compatibility issues
- Adding a digital signature
- Displaying formulas instead of values
- Enabling the error checking rules for formulas
- Evaluating and correcting a formula
- Configuring error checking rules for formulas
- Using multiple criteria in the COUNTIFS function
- Using multiple criteria with the SUMIFS function
- Configuring a calculation option for formulas
03 / Exam details
Microsoft Excel 2013 (MOS) Expert Part 2 Details
Prepare for the Microsoft 77-428 exam with the MOS Excel 2013 Expert Part 2 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Office training course covers the Excel expert exam objectives and provides skills to manage and share workbooks, apply custom formats and layouts, and more. The Microsoft Excel certification course and lab also include topics such as custom business templates, multiple axis financial charts, and more.
Ready to take the exam?
Add your official 77-428-complete exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available04 / FAQs
Questions before you start
What are the prerequisites for this exam?+
What is the exam registration fee?+
Where do I take the exam?+
What is the format of the exam?+
How many questions are asked in the exam?+
What is the duration of the exam?+
What is the passing score?+
What is the exam's retake policy?+
Microsoft Office Specialist (MOS) exam retake policy
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
- If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
- A two-day waiting period will be imposed between each subsequent exam retake.
- There is no annual limit on the number of attempts on the same exam.
- If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification?+
Where can I find more information about this exam?+
Prepare for Microsoft Excel 2013 (MOS) Expert Part 2
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 9 LiveLab included
- Certificate of completion
No credit card required