Microsoft Excel Associate (Office 2019)

This 40-hour, self-led course helps prepare students for Exam MO-200: Microsoft Excel (Office 2019). The course includes comprehensive student materials with guidance from educators, and a series of student lessons, activities and assessments contained within eight individual modules. Based around a single business scenario, the course guides students through specific tasks and real-world challenges to help them understand the relevance, power, and usefulness of Microsoft Excel. By becoming proficient in Excel, students will improve the ways they organize ideas and information, gain valuable insights into the ways they can filter and present data, and create spreadsheets that clearly and effectively deliver targeted data and computations.

By the end of the course, you’ll be able to:

• Create, open, edit, and save workbooks; understand the interface; and navigate to workbook elements.
• Manage workbooks and worksheets, change the screen display, and customize the Quick Access Toolbar.
• Format cells and numbers, align and wrap content, add and remove cell styles, and merge cells.
• Format data as a table, work with table styles, create named tables, define range names, and filter and sort data.
• Create and display formulas, use references and common functions in formulas, and understand calculation operators and precedence.
• Get data from other sources, fix text formatting by using text functions, and insert hyperlinks to related information.
• Apply conditional formatting to data; create, edit, and format charts; create sparklines; and use the Quick Analysis feature to quickly analyze data.
• Configure a workbook’s print settings and page setup, add and edit headers and footers, modify basic workbook properties, and inspect a workbook for compatibility and accessibility issues.