Cert Prep

This course is a part of Master Microsoft Excel, a 17-course Learning Path series from LinkedIn Learning.

Demonstrate your knowledge of Excel 2019 by becoming a Microsoft Office Specialist (MOS). Get training to prepare for the Excel Associate certification exams for Office 365 and Office 2019. This course, created by Microsoft Certified Instructor and MOS Master Jennifer McBee, helps you prepare for the five main areas of focus for the Excel Associate Office 365 and Office 2019 exams: managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, performing operations with formulas and functions, and managing charts. The course includes an overview of the MOS certification program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.

Contents:

• Introduction
• 1. Microsoft Office Specialist Exam Overview
• 2. Manage Worksheets and Workbooks
• 3. Manage Data Cells and Ranges
• 4. Manage Tables and Table Data
• 5. Perform Operations Using Formulas and Functions
• 6. Manage Charts
• 7. Final Practice Exam
• Conclusion