Home > Store

MOS Study Guide for Microsoft Excel Expert Exam MO-201

Register your product to gain access to bonus material or receive a coupon.

MOS Study Guide for Microsoft Excel Expert Exam MO-201

Best Value Purchase

Book + eBook Bundle

  • Your Price: $26.99
  • List Price: $44.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $19.99
  • List Price: $24.99
  • Estimated Release: Mar 9, 2020

eBook (Watermarked)

  • Your Price: $15.99
  • List Price: $19.99
  • Estimated Release: Mar 9, 2020
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • Full, objective-by-objective exam coverage
  • Easy-to-follow procedures and illustrations to review essential skills
  • Hands-on tasks to practice skills learned
  • Ready-made, downloadable practice file

Description

  • Copyright 2020
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 192
  • Edition: 1st
  • Book
  • ISBN-10: 0-13-662752-8
  • ISBN-13: 978-0-13-662752-4

Hone your advanced Excel 2019 skills. And earn the credential that proves it!
Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2019 certification, this official Study Guide delivers:

  • In-depth preparation for each MOS objective
  • Detailed procedures to help build the skills measured by the exam
  • Hands-on tasks to practice what you’ve learned
  • Ready-made practice files
  • Solution files for the practice tasks 
Sharpen the skills measured by these objectives:
  • Create and Manage Workbooks
  • Apply Custom Formatting and Layouts
  • Create Advanced Formulas
  • Perform Data Analysis
  • Create Advanced Charts and Pivot Tables
About MOS
A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams. 

Sample Content

Table of Contents

Chapter 1 — Manage and share workbooks1.1 Manage workbooks1.2 Manage workbook review
Chapter 2 — Apply custom formats and layouts2.1 Apply custom data formats2.2 Apply advanced conditional formatting and filtering2.3 Apply custom styles and templates2.4 Prepare workbooks for internationalization and accessibility
Chapter 3 — Create advanced formulas3.1 Apply functions in formulas3.2 Look up data by using functions3.3 Apply advanced date and time functions3.4 Perform data analysis and business intelligence3.5 Troubleshoot formulas3.6 Define named ranges and objects
Chapter 4 — Create advanced charts and tables4.1 Create advanced chart elements4.2 Create and manage PivotTables4.3 Create and manage PivotCharts

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership