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.
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
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.