MOS 2016 Study Guide for Microsoft Excel

Description

Review and practice the skills you must demonstrate to become a certified Microsoft Office Specialist in Excel 2016!

• Full, objective-by-objective exam coverage
• Easy-to-follow procedures and illustrations to review essential skills
• Hands-on practice tasks to apply what you’ve learned

Adding solutions to practice tasks per feedback from readers.

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides 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 know how 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), five generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.

Blissfully based in America’s Finest City, 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.

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

Advance your everyday proficiency with Excel 2016.

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 2016 Core 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
• Practice files and sample solutions

 Sharpen the skills measured by these objectives:

• Create and manage worksheets and workbooks
• Manage data cells and ranges
• Create tables
• Perform operations with formulas and functions
• Create charts and objects

• Introduction
• Taking a Microsoft Office Specialist exam
• Exam 77-727: Microsoft Excel 2016 Core Prerequisites
• Objective group 1: Create and manage worksheets and workbooks
• Objective 1.1: Create worksheets and workbooks
• Objective 1.2: Navigate in worksheets and workbooks
• Objective 1.3: Format worksheets and workbooks
• Objective 1.4: Customize options and views for worksheets and workbooks
• Objective 1.5: Configure worksheets and workbooks for distribution
• Objective group 2: Manage data cells and ranges
• Objective 2.1: Insert data in cells and ranges
• Objective 2.2: Format cells and ranges
• Objective 2.3: Summarize and organize data
• Objective group 3: Create tables
• Objective 3.1: Create and manage tables
• Objective 3.2: Manage table styles and options
• Objective 3.3: Filter and sort tables
• Objective group 4: Perform operations by using formulas and functions
• Objective 4.1: Summarize data by using functions
• Objective 4.2: Perform conditional operations by using functions
• Objective 4.3: Format and modify text by using functions
• Objective group 5: Create charts and objects
• Objective 5.1: Create charts
• Objective 5.2: Format charts
• Objective 5.3: Insert and format objects

Advance your everyday proficiency with Excel 2016.

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 2016 Core 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
• Practice files and sample solutions

 Sharpen the skills measured by these objectives:

• Create and manage worksheets and workbooks
• Manage data cells and ranges
• Create tables
• Perform operations with formulas and functions
• Create charts and objects

Additional information