Scroll to top button

MOS: Microsoft Excel 2013 Expert Part 2 (Course & Lab)

ISBN : 9781616915865

Prepare for the Microsoft 77-428 certification exam with the MOS Excel 2013 Expert Part 2 77-428 complete course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. Interactive chapters comprehensively cover all the objectives of the MOS 77-428 exam and provide skills to manage and share workbooks, apply custom formats and layouts, create advanced formulas, and create advanced charts and tables. The course and lab also include topics such as include custom business templates, multiple axis financial charts, and more.

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 MOS 77-428 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 meet needs and enhance productivity.

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions
Performance lab
Video tutorials

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
  • Linking Workbooks
  • Creating External Reference Formulas
  • Working with External Reference Formulas
  • Avoiding Potential Problems with External Reference Formulas
  • Consolidating Worksheets
  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • VB Project Protection
  • Related Topics
  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
  • About Number Formatting
  • Creating a Custom Number Format
  • Custom Number Format Examples
  • Exploring Excel Templates
  • Understanding Custom Excel Templates
  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Advanced Counting Formulas
  • Summing Formulas
  • Conditional Sums Using a Single Criterion
  • Conditional Sums Using Multiple Criteria
  • A What-If Example
  • Types of What-If Analysis
  • What-If Analysis, in Reverse
  • Single-Cell Goal Seeking
  • Introducing Solver
  • Solver Examples
  • The Time Value of Money
  • Loan Calculations
  • Investment Calculations
  • Depreciation Calculations
  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Learning More
  • 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 (Labs)

  • 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