Microsoft Excel Expert 2019 (Microsoft 365 Apps)

This 40-hour course helps prepare students for Exam MO-201: Microsoft Excel Expert (Office 2019). The course includes comprehensive student materials with guidance for a series of student lessons, activities and assessments contained within seven individual modules. By mastering advanced Excel capabilities, students optimize the ways they organize ideas and information and gain valuable insights into the ways they can filter and present data. They create spreadsheets that deliver their targeted data and computations to their intended audiences in clearer and effective ways.

On successful Completion of the course you will be able to:

• Manage workbooks
• Prepare workbooks for collaboration
• Fill cells based on existing data
• Format and validate data
• Apply advanced conditional formatting and filtering
• Create advanced formulas and macros
• Manage advanced charts and tables