Download the Free Fishpond App!
Download on the App Store

Android App on Google play

Already own it?

Sell Yours
Home » Books » Computers » Applications » Microsoft Excel

MOS 2016 Study Guide for Microsoft Excel Expert

Mos Study Guide

By Paul McFedries

Elsewhere $36.95 $31.71   Save 14%
Free shipping Australia wide
Ships from UK
Order Now for Christmas with e-Gift
Register or sign-in to rate and get recommendations.
Format: Paperback, 192 pages
Published In: United States, 11 November 2016
Hone your advanced Excel 2016 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 2016 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:

  • Create and Manage Workbooks
  • Apply Custom Formatting and Layouts
  • Create Advanced Formulas
  • Perform Data Analysis
  • Create Advanced Charts and PivotTables


Table of Contents

Chapter 1 - Manage and share workbooks1.1 Manage workbooks1.2 Manage workbook reviewChapter 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 accessibilityChapter 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 objectsChapter 4 - Create advanced charts and tables4.1 Create advanced chart elements4.2 Create and manage PivotTables4.3 Create and manage PivotCharts

About the Author

Paul McFedries is a full-time technical author who has worked with computers in one form or another since 1975. He is the author of more than 90 computer books that have sold more than 4 million copies worldwide. His recent Office-related titles include My Office 2016, My Office 2016 for Mac, and Formulas and Functions for Microsoft Excel 2016. His other titles include Windows 10 In Depth, (with Brian Knittel), PCs for Grownups, and Fixing Your Computer Absolute Beginner's Guide. Paul is also the proprietor of Word Spy ( a website devoted to tracking new words and phrases as they enter the English language. Please feel free to drop by Paul's personal website at or follow him on Twitter at and

EAN: 9780735699427
ISBN: 0735699429
Publisher: Microsoft Press,U.S.
Dimensions: 22.86 x 18.54 x 0.76 centimetres (0.24 kg)
Age Range: 15+ years
Tell a friend

Their Email:

Sell Yours

Already own this item?
Sell Yours and earn some cash. It's fast and free to list! (Learn More.)

Review this Product


Related Searches


Webmasters, Bloggers & Website Owners

You can earn a 5% commission by selling MOS 2016 Study Guide for Microsoft Excel Expert (Mos Study Guide) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep!



Are you the Author/Publisher? Improve sales by submitting additional information on this title.


This item ships from and is sold by Fishpond World Ltd.