Microsoft Excel 2016 Certification Course

Program Name: Microsoft Excel 2016 Certification Course
Program Duration: Self Directed Online or 3 Days in Class
Instructor Led Program Cost: $579.00 with Printed Book
Online Program Cost: $399.00 with eBook or $499.00 with Printed Book
Available Languages: English

Click Here to Register for the Online Course
Click Here to Register for Atlanta
Click Here to Register for Marietta

Pinewood Schools / PWC Training is the only training center with a testing center and live instructors in the classroom in the Atlanta Metro Area. That is what separates us from our competitors that either do not have testing available or an instructor in the room for training.

This in-depth course will equip students with a thorough knowledge and understanding of the most relevant features and uses of Excel 2016. Students will be engaged with hands on learning as they apply learned concepts to create relevant work such as brochures, resume tables, newsletters & more.

This textbook carries the ExamReadyTM certification which certifies that it has been tested by ProCert Labs to validate that it covers all course objectives included in the Microsoft Office Specialist (MOS) certification exam.

Covered Topics

Day 1 – Level 1

  • Introduction to Worksheets – Formatting Sheets & Cells, Numbers, Dates, Basic Calculations
  • Rearranging Data – Working with Rows, Cells & Columns
  • Managing Multiple Worksheets, Formulas, and Cell References
  • Data Visualization with Charts & Images – Using Tools for Formatting & Editing
  • Organizing Large Amounts of Data – Sorting, Freeze Panes & Window Split

Day 2 – Level 2

  • Advanced Formatting – Themes, Cell Styles, Customizing Page Setup
  • Date and Time Functions, Conditional Formatting
  • Advanced Functions for Text and Analysis – IF Criteria, Troubleshooting Formulas
  • Lookup Function and the Outline Features

Day 3 – Level 3

  • Working with Tables – Calculated Columns, Structured References, Table Features
  • Financial Functions & What-If Analysis – PMT, PV and NPER Functions
  • PivotTables and PivotCharts
  • Workbook Protection and Inspecting Workbooks for Compatibility

Features

  • Coursework leading towards Microsoft Office Specialist (MOS) Certification
  • Step-by-step, skills-based approach ensures that students master subjects and achieve success quickly
  • Real-world focus helps students develop practical skills they can apply immediately
  • Quick Reference tables covering major tasks (useful for reference outside of class)
  • Exercises increase in complexity throughout each lesson to challenge students
  • WebSim interactive simulations reinforce our student-friendly lessons
  • Instructor support and student resources