My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free Shipping in Australia
Trustpilot
Proud to be B-Corp

MOS Study Guide for Microsoft Excel Exam MO-200 Joan Lambert

MOS Study Guide for Microsoft Excel Exam MO-200 By Joan Lambert

MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert

Reviews:
$48.19
Condition - New
5 in stock
New

MOS Study Guide for Microsoft Excel Exam MO-200 Summary

MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert

Advance your everyday proficiency with Excel!

And earn the credential that proves it!

Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 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

Sharpen the skills measured by these objectives:

  • Manage Worksheets and Workbooks
  • Manage Data Cells and Ranges
  • Manage Tables and Table Data
  • Perform Operations by Using Formulas and Functions
  • Manage Charts

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.

About Joan Lambert

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows 10 and Office 2016, and GO! series books for Outlook. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer. She is also certified in Adobe InDesign and Intuit QuickBooks. A native of the Pacific Northwest and enthusiastic world traveler, Joan is now blissfully based in America's Finest City with her simply divine daughter Trinity, Thai host daughter Thopad, and their faithful canine, feline, and aquatic companions.

Table of Contents

  • 1 Manage worksheets and workbooks
  • Objective 1.1: Import data into workbooks
  • Objective 1.2: Navigate within workbooks
  • Objective 1.3: Format worksheets and workbooks
  • Objective 1.4: Customize options and views
  • Objective 1.5: Configure content for collaboration
  • 2 Manage data cells and ranges
  • Objective 2.1: Manipulate data in worksheets
  • Objective 2.2: Format cells and ranges
  • Objective 2.3: Define and reference named ranges
  • Objective 2.4: Summarize data visually
  • 3 Manage tables and table data
  • Objective 3.1: Create and format tables
  • Objective 3.2: Modify tables
  • Objective 3.3: Filter and sort table data
  • 4 Perform operations by using formulas and functions
  • Objective 4.1: Insert references in formulas
  • Objective 4.2: Calculate and transform data by using functions
  • Objective 4.3: Format and modify text by using functions
  • 5 Manage charts
  • Objective 5.1: Create charts
  • Objective 5.2: Modify charts
  • Objective 5.3: Format charts

Additional information

NGR9780136627159
9780136627159
0136627153
MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert
Joan Lambert
MOS Study Guide
New
Paperback
Pearson Education (US)
2020-04-16
192
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a new book - be the first to read this copy. With untouched pages and a perfect binding, your brand new copy is ready to be opened for the first time

Customer Reviews - MOS Study Guide for Microsoft Excel Exam MO-200