Excel 2016 Microsoft Office Specialist Cert Prep (77-420) – Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist. Study to pass the MOS Excel 2016 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test takers prepare for exam 77-420, which covers the five main skills on the MOS Excel 2013 exam: creating worksheets and workbooks, cells and ranges, formulas and functions, and charts and other objects.
The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill.
There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you’re ready for the real exam.
- Preparing for the exam
- Understanding the registration process
- Creating new Excel workbooks and worksheets
- Formatting data
- Inserting columns and rows
- Moving data
- Applying conditional formatting
- Creating tables
- Applying formulas and functions
- Summarizing data
- Creating charts
- Taking a full-length practice exam
Content Retrieved From: https://www.lynda.com/Excel-tutorials/Excel-2013-Prepare-Microsoft-Office-Specialist-Certification-Exam-77-420/439680-2.html
Please Note that we do not supply any course, please consult directly with course authors for any problem or where courses are stored.