Microsoft

Microsoft Excel 2013 (MOS) Expert Part 2

(77-428-complete) / ISBN : 978-1-61691-586-5
Lessons
Lab
TestPrep
244 Reviews
Get A Free Trial

Skills You’ll 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.
Download Course Outline

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
2

Protecting Your Work

  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • VB Project Protection
  • Related Topics
3

Making Your Worksheets Error Free

  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
4

Using Custom Number Formats

  • About Number Formatting
  • Creating a Custom Number Format
  • Custom Number Format Examples
5

Using and Creating Templates

  • Exploring Excel Templates
  • Understanding Custom Excel Templates
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
7

Performing Spreadsheet What-If Analysis

  • A What-If Example
  • Types of What-If Analysis
8

Analyzing Data Using Goal Seeking and Solver

  • What-If Analysis, in Reverse
  • Single-Cell Goal Seeking
  • Introducing Solver
  • Solver Examples
9

Creating Formulas for Financial Applications

  • The Time Value of Money
  • Loan Calculations
  • Investment Calculations
  • Depreciation Calculations
10

Introducing Pivot Tables

  • 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

  • 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

1

Protecting Your Work

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

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
3

Creating Formulas That Count and Sum

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

Creating Formulas for Financial Applications

  • Configuring a calculation option for formulas

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Microsoft Excel 2013 (MOS) Expert Part 2

$279.99

Buy Now

Related Courses

All Course