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