800.323.0440 Shopping Cart Goodheart-Willcox
Home   Certification - Microsoft   Certification Prep Microsoft Excel 2016
Browse Subjects
Anatomy / Physiology
Applied Mathematics
CAD / Drafting
Career Education
Certification - Adobe
Certification - Microsoft
Child Care / Human Dev / Parenting
Clothing and Fashion
Culinary Arts
Electricity / Electronics
FCS Comprehensive
FCS Family Living
Floral Design
Food / Nutrition
Health Sciences
Health: High School
Health: Middle School
Human Services
Information Technology
Interior Design / Housing
Life Management
Manufacturing / Metals
Medical Terminology
Power Technology
Print Reading
Technology / Engineering
Video Game Design
Visual Technology
Advanced Search Request a Preview Request a Catalog Find My Educational Consultant

Certification Prep Microsoft Excel 2016

Certification Prep Microsoft Excel 2016

By: D. Michael Ploor

ISBN: 978-1-63126-809-0
Format: Course Supplement
Copyright: ©2017
Subject: Certification - Microsoft
Grade Level: 9-14
Retail Price: $22.00
School Price: $16.50


The Microsoft Excel 2016 certification preparation guide will help prepare the user to take the Microsoft Office Specialist (MOS) Microsoft Excel 2016 certification exam. It provides step-by-step instruction for the features and commands covered on the certification exam and can be completed in approximately 2.5 to 3 hours. Certification as a Microsoft Office Specialist demonstrates an aptitude with Microsoft Office software.
  • Prepares the user for certification tests without expensive test-prep software.
  • Focuses on hands-on use of tools and completion of skills; users learn and apply the skills, not just learn how to complete the test.
  • Integrates as a supplement to existing classroom activities; minimal class time required.
  • Requires no prior knowledge or use of the software; starts with basic skills and builds to advanced skills.
  • Teaches the user to work with the software to complete project-based learning.
  • Provides a simulation of the certification exam.

Previous Edition
Certification Prep Microsoft Excel 2013

Table of Contents

  1. Basic Overview
  2. Program Layout
  3. Getting Acquainted
  4. Data Tables
  5. Using Formulas and Functions
  6. Using Templates, Themes, and Images
  7. Pivot Tables, SmartArt Graphics, and Charts
  8. Skills Mastery: Certification Simulation

Look Inside

Certification Prep Guide (min. 10)
   sample Lesson 3 (PDF, 768 KB)
Companion Website
   sample View Site (www.g-wlearning.com, Certification Prep Series)
  Note: Sample file quality has been reduced to allow for Internet streaming and viewing.

About Author(s)

D. Michael Ploor - is the author of the series of certification preparation guides. Mr. Ploor's students have achieved exceptional results with the certification preparation guides. His students collectively pass more than 500 industry certification exams each year without the need for other preparation materials. Mr. Ploor has demonstrated the strength of integrating the certification guides in a diverse mix of courses.

Mr. Ploor is also the author of three textbooks on the subject of video game design: Introduction to Video Game Design, Video Game Design Foundations, and Video Game Design Composition. He is a National Board Certified Teacher in Career and Technical Education and holds an MBA degree from the University of South Florida. He maintains professional teaching credentials in Business Education and Education Media Specialist.

Mr. Ploor is at the forefront of innovative teaching and curriculum. He developed STEM curriculum while serving as the lead teacher in the Career Academy of Computer Game Design at Middleton Magnet STEM High School. Mr. Ploor has applied his skills as a STEM Curriculum Integration Specialist in designing innovative curriculum and by collaborating to construct the state standards for video game design in several states. He has also been instrumental in authoring competitive events for Career and Technical Student Organizations such as the Future Business Leaders of America (FBLA) and Phi Beta Lambda (PBL).

In addition to publishing textbooks and lessons, Mr. Ploor provides professional development as a frequent presenter at regional and national conferences to promote CTE education and video game design curriculum.


School PriceOrder Quantity
Certification Prep Guide (min. 10) 80 978-1-63126-809-0 $22.00$16.50
Microsoft Office 2016 Set (min. 10) 978-1-63126-823-6 $88.00$66.00
Companion Website View Site
*Instructors’ materials and custom products cannot be ordered online. For more information or to place an order, please call 800.323.0440.

Goodheart-Willcox Publisher
18604 West Creek Drive
Tinley Park, IL 60477-6243