• Home
uCertify Logo
  • 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

Microsoft Excel 2013 (MOS) Expert Part 2

(77-428-complete) / ISBN: 9781616915865
This course includes
Lessons
TestPrep
Lab
77-428-complete : Microsoft Excel 2013 (MOS) Expert Part 2
Share
$279.99
Try This Course
Are you an instructor?
Request a free evaluation copy

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.
Here's what you will get

The Microsoft Office Specialist: Excel 2013 Expert certification is an industry-recognized credential. It is a standalone certification from Microsoft with the exam code 77-428. The Microsoft Excel expert exam validates the candidate's ability to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations, as well as customize their Excel environment to enhance productivity.

Lessons
  • 11+ Lessons
  • 73+ Exercises
  • 46+ Quizzes
  • 43+ Flashcards
  • 43+ Glossary of terms
TestPrep
  • 5+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 30+ Post Assessment Questions
  • 60+ Practice Test Questions
Lab
  • 9+ Performance lab
  • 57+ Video tutorials
  • 30+ Minutes
Video Lessons
  • 5+ Videos
  • 03+ Minutes
Here's what you will learn
Download Course Outline
Lesson 1: Linking and Consolidating Worksheets
  • Linking Workbooks
  • Creating External Reference Formulas
  • Working with External Reference Formulas
  • Avoiding Potential Problems with External Reference Formulas
  • Consolidating Worksheets
Lesson 2: Protecting Your Work
  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • VB Project Protection
  • Related Topics
Lesson 3: Making Your Worksheets Error Free
  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
Lesson 4: Using Custom Number Formats
  • About Number Formatting
  • Creating a Custom Number Format
  • Custom Number Format Examples
Lesson 5: Using and Creating Templates
  • Exploring Excel Templates
  • Understanding Custom Excel Templates
Lesson 6: Creating Formulas That Count and Sum
  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Advanced Counting Formulas
  • Summing Formulas
  • Conditional Sums Using a Single Criterion
  • Conditional Sums Using Multiple Criteria
Lesson 7: Performing Spreadsheet What-If Analysis
  • A What-If Example
  • Types of What-If Analysis
Lesson 8: Analyzing Data Using Goal Seeking and Solver
  • What-If Analysis, in Reverse
  • Single-Cell Goal Seeking
  • Introducing Solver
  • Solver Examples
Lesson 9: Creating Formulas for Financial Applications
  • The Time Value of Money
  • Loan Calculations
  • Investment Calculations
  • Depreciation Calculations
Lesson 10: Introducing Pivot Tables
  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Learning More
Lesson 11: Analyzing Data with Pivot Tables
  • 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 Activities (Performance Labs)

Protecting Your Work

  • Checking a workbook for compatibility issues
  • Adding a digital signature

Making Your Worksheets Error Free

  • Displaying formulas instead of values
  • Enabling the error checking rules for formulas
  • Evaluating and correcting a formula
  • Configuring error checking rules for formulas

Creating Formulas That Count and Sum

  • Using multiple criteria in the COUNTIFS function
  • Using multiple criteria with the SUMIFS function

Creating Formulas for Financial Applications

  • Configuring a calculation option for formulas
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification exam.
What is the exam registration fee? USD 100
Where do I take the exam? Certiport
What is the format of the exam? The exam consists of performance based questions and is conducted in a live or simulated environment. MOS 2013 presents the candidate with a project to build with tasks and steps that build on each other.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 50 minutes
What is the passing score? The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?

Microsoft Office Specialist (MOS) exam retake policy

  1. 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.
  2. 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.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification? For life
Where can I find more information about this exam? To know more about the , click here.
What are the career opportunities after passing this exam?
  • Accountant
  • Data Analyst
  • Financial Analyst
  • Information Worker
  • Commercial Banker
  • Program/Project Manager
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept