McFedries - MOS Study Guide for Microsoft Excel Expert Exam MO-201

MOS Study Guide for Microsoft Excel Expert Exam MO-201 — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "MOS Study Guide for Microsoft Excel Expert Exam MO-201" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

1234567...39

MOS Study Guide for
Microsoft Excel Expert
Exam MO-201

Paul McFedries

MOS Study Guide for Microsoft Excel Expert Exam MO-201

Published with the authorization of Microsoft Corporation by:

Pearson Education, Inc.

Copyright 2020 by Pearson Education, Inc.

All rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request forms, and the appropriate contacts within the Pearson Education Global Rights & Permissions Department, please visit www.pearson.com/permissions

No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-13-662752-4

ISBN-10: 0-13-662752-8

Library of Congress Control Number: 2020931640

ScoutAutomatedPrintCode

Trademarks

Microsoft and the trademarks listed at http://www.microsoft.com on the Trademarks webpage are trademarks of the Microsoft group of companies. All other marks are property of their respective owners.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an as is basis. The author, the publisher, and Microsoft Corporation shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the use of the programs accompanying it.

Special Sales

For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding interests), please contact our corporate sales department at or (800) 382-3419.

For government sales inquiries, please contact .

For questions about sales outside the U.S., please contact .

Editor-in-Chief

Brett Bartow

Executive Editor

Loretta Yates

Development Editor

Songlin Qiu

Sponsoring Editor

Charvi Arora

Managing Editor

Sandra Schroeder

Senior Project Editor

Tracey Croom

Copy Editor

Elizabeth Welch

Indexer

Cheryl Ann Lenser

Proofreader

Abigail Manheim

Technical Editor

Boyd Nolan

Editorial Assistant

Cindy Teeters

Cover Designer

Twist Creative, Seattle

Compositor

codeMantra

Contents

Introduction

The Microsoft Office Specialist (MOS) certification program has been designed to validate your knowledge of and ability to use programs in the Microsoft Office 365 and Office 2019 suite of programs. This book has been designed to guide you in studying the types of tasks you are likely to be required to demonstrate in Exam MO-201, Microsoft Excel Expert.

Exam Strategy

For information about the tasks you are likely to be required to demonstrate in the core Excel exam, Exam MO-200, Microsoft Excel 2019, see MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert (Microsoft Press, 2020).

Who this book is for

MOS Study Guide for Microsoft Excel Expert Exam MO-201 is designed for experienced computer users seeking Microsoft Office Specialist Expert certification in Excel and Excel 2019.

MOS exams for individual programs are practical rather than theoretical. You must demonstrate that you can complete certain tasks or projects rather than simply answer questions about program features. The successful MOS certification candidate will have at least six months of experience using all aspects of the program on a regular basis; for example, protecting a worksheet, applying conditional formatting rules, filling a series, and building a PivotTable.

As a certification candidate, you probably have a lot of experience with the program you want to become certified in. Many of the procedures described in this book will be familiar to you; others might not be. Read through each study section and ensure that you are familiar with the procedures, concepts, and tools discussed. In some cases, images depict the tools you will use to perform procedures related to the skill set. Study the images and ensure that you are familiar with the options available for each tool.

How this book is organized

The exam coverage is divided into chapters representing broad skill sets that correlate to the functional groups covered by the exam. Each chapter is divided into sections addressing groups of related skills that correlate to the exam objectives. Each section includes review information, generic procedures, and practice tasks you can complete on your own while studying. You can use the provided practice files to work through the practice tasks, and the result files to check your work. You can practice the generic procedures in this book by using the practice files supplied or by using your own files.

Throughout this book, you will find Exam Strategy tips that present information about the scope of study that is necessary to ensure that you achieve mastery of a skill set and are successful in your certification effort.

Download the practice files

Before you can complete the practice tasks in this book, you need to copy the books practice files and result files to your computer. Download the compressed (zipped) folder from the following page, and extract the files from it to a folder (such as your Documents folder) on your computer:

MicrosoftPressStore.com/MOSExcelExpert201/downloads

Important

The Excel 2019 program is not available from this website. You should purchase and install that program before using this book.

You will save the completed versions of practice files that you modify while working through the practice tasks in this book. If you later want to repeat the practice tasks, you can download the original practice files again.

The following table lists the practice files provided for this book.

Folder and objective group	Practice files	Result files
MOSExcelExpert2019\Objective1 Manage workbook options and settings	Excel_1-1a.xlsx Excel_1-1b.xlsm Excel_1-2a.xlsx Excel_1-2b.xlsx Excel_1-2c.xlsx Excel_1-2d.xlsx Excel_1-3a.xlsx	Excel_1-1a_results.xlsx Excel_1-2a_results.xlsx Excel_1-2b_results.xlsx Excel_1-2c_results.xlsx
MOSExcelExpert2019\Objective2 Manage and format data	Excel_2-1.xlsx Excel_2-2.xlsx Excel_2-3a.xlsx Excel_2-3b.xlsx Excel_2-3c.xlsx

Next page

1234567...39

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «MOS Study Guide for Microsoft Excel Expert Exam MO-201»

Look at similar books to MOS Study Guide for Microsoft Excel Expert Exam MO-201. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

Kathiravan Udayakumar

MCE Microsoft Certified Expert Cybersecurity Architect Study Guide: Exam SC-100

Steven Jones

Excel: The Complete User’s Guide To Microsoft Excel; How To Become An Excel Expert In No Time! (Excel, Microsoft Office, Excel Shortcuts)

Paul McFedries

Excel All-in-One For Dummies (For Dummies (Computer/Tech))

Lambert

MOS Study Guide for Microsoft Excel Exam MO-200

McFedries

MOS Study Guide for Microsoft Word Expert Exam MO-101

Paul McFedries

MOS Study Guide for Microsoft Access Expert Ex

Chris Sorensen

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Pierce J.

MOS 2013 Study Guide. Exam 77-425 & 77-426. Microsoft Word Expert

Mark Dodge

MOS 2013 Study Guide for Microsoft Excel Expert

Joyce Cox

MOS 2010 Study Guide for Microsoft® PowerPoint®

John Pierce

MOS Study Guide for Microsoft Office 365

John Pierce

Mos 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access, and Sharepoint

Discussion, reviews of the book MOS Study Guide for Microsoft Excel Expert Exam MO-201 and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.