Cert Prep: Excel Associate – Microsoft Office Specialist for Office 2019 and Office 365

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.

Topics include:

• Importing data
• Formatting worksheets and workbooks
• Exporting workbooks
• Pasting data
• Modifying columns, rows, and cells
• Formatting cells
• Conditional formatting
• Creating tables
• Filtering and sorting table data
• Using references
• Performing calculations with functions
• Formatting text with functions
• Creating charts
• Taking the practice exam

About the Author

Microsoft Certified Trainer Jennifer McBee helps students master Office and pass MOS certification exams. Jennifer has been a Microsoft Certified Trainer since 2007, successfully teaching Microsoft Office and other desktop software to such organizations as L.L.Bean, Siemens Healthcare Diagnostics, the City of Bangor, Time Warner Cable, the Maine Department of Labor, and Bangor International Airport. She holds Master-level MOS certification in Office 2003, 2007, 2010, and 2013, and she has served as a subject matter expert on exams for Office 2010 and 2013. She also runs a testing center for Certiport, the exclusive certification exam partner of Microsoft.

Product Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Intermediate
• Video Duration: 3h 34m
• Instructor: Jennifer McBee