Please Select an Education Level

6-12 Education College & Career

Certification Prep Microsoft Excel 2016

By: D. Michael Ploor
ISBN: 978-1-63126-809-0
Format: Course Supplement
Copyright: 2017
Subject: Certification - Microsoft
Description
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.
Products & Prices
Products Pages ISBN Retail Price Order Quantity
Certification Prep Guide (min. 10) 80 978-1-63126-809-0 $22.00 *
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.
Microsoft Office 2016 Set (min. 10) 978-1-63126-823-6 $88.00 *
G-W's Certification Preparation Series consists of individual guides that provide practice in the basic skills needed to be successful using the corresponding software. No previous software experience is required. Although the guides focus on learning skills, not test taking, users that complete the practice will be prepared to take the official software certification exam and demonstrate workplace readiness. Step-by-step instructions demonstrate actual software commands and features, building from basic to advanced. Content is divided into small units for better learning and usage. There is no need to download files or purchase additional materials as all lesson content is created using the software.

The Certification Prep Microsoft Office 2016 Set includes the following Certification Preparation Guides:
  • Microsoft Word 2016
  • Microsoft Excel 2016
  • Microsoft PowerPoint 2016
  • Microsoft Access 2016
  • Microsoft Outlook 2016
Minimum quantity of 10 must be purchased.
Certification Prep Bundle 2 (Microsoft Word 2016, Microsoft Excel 2016, and Microsoft PowerPoint 2016) (min. 10) 978-1-63563-118-0 $62.68 *
This pack of three guides provides hands-on practice for Microsoft Word, Excel, and PowerPoint and prepares students to take the official software certification exams. Minimum quantity of 10 must be purchased.
Companion Website       View Site
*To order this item, please call 800.323.0440.
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)
PDF
Lesson 3 (PDF, 768 KB)
Companion Website
www.g-wlearning.com
View Site (www.g-wlearning.com, Certification Prep Series)
About the 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.