Search results for:
No result found! Try with different keywords!
The event you are looking at is a past event. Check out this upcoming event Microsoft Excel 2016 User Class - MOS Certification Prep happening on Mon Apr 08 2019 at 09:00 am at PWC Training - Atlanta, 1571 Phoenix Blvd, Atlanta, United States

Microsoft Excel 2016 User Class - MOS Certification Prep


Microsoft Excel 2016 User Class - MOS Certification Prep

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. All of our instructors are certified in the courses that they teach. No need to bring a laptop or rent one, because we have a full training center.

This in-depth course will equip students with a thorough knowledge and understanding of the most relevant features and uses of Excel 2016. 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


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

Instructor support and student resources

Map PWC Training - Atlanta, 1571 Phoenix Blvd, Atlanta, United States
Loading venue map..
Event details from Report a problem

Are you going to this event?