Microsoft

Microsoft Excel 2013 (MOS) Expert Part 1

(77-427-complete) / ISBN : 978-1-61691-755-5
Lessons
Lab
TestPrep
259 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-427. The Microsoft Excel expert certification validates that the certified candidates can 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.
Download Course Outline

1

Visualizing Data Using Conditional Formatting

  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Conditional Formats That Use Graphics
  • Creating Formula-Based Rules
  • Working with Conditional Formats
2

Manage and Share Workbook

  • Adding Comments to Cells
  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
3

Introducing Formulas and Functions

  • Understanding Formula Basics
  • Entering Formulas into Your Worksheets
  • Editing Formulas
  • Using Cell References in Formulas
  • Using Formulas in Tables
  • Correcting Common Formula Errors
  • Using Advanced Naming Techniques
  • Working with Formulas
4

Creating Formulas That Look Up Values

  • Introducing Lookup Formulas
  • Functions Relevant to Lookups
  • Basic Lookup Formulas
  • Specialized Lookup Formulas
5

Working with Dates and Times

  • How Excel Handles Dates and Times
  • Date-Related Worksheet Functions
  • Time-Related Functions
6

Getting Started Making Charts

  • What Is a Chart?
  • Understanding How Excel Handles Charts
  • Creating a Chart
  • Hands On: Creating and Customizing a Chart
  • Working with Charts
  • Understanding Chart Types
  • Learning More
7

Learning Advanced Charting

  • Selecting Chart Elements
  • User Interface Choices for Modifying Chart Elements
  • Modifying the Chart Area
  • Modifying the Plot Area
  • Working with Titles in a Chart
  • Working with a Legend
  • Working with Gridlines
  • Modifying the Axes
  • Working with Data Series
  • Creating Chart Templates
  • Learning Some Chart-Making Tricks
8

Introducing Pivot Tables

  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Learning More
9

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

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting
  • Using icons in conditional formatting
2

Manage and Share Workbook

  • Showing cell dependency
  • Enabling background error checking for formulas
3

Working with Dates and Times

  • Printing the current date and time

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 1

$279.99

Buy Now

Related Courses

All Course