Microsoft Office Specialist: Excel Associate (Office 2019) (MO-200)

The Microsoft Excel Certification: Excel Associate (MO-200) is an accreditation that underlines proficiency in utilising Microsoft Excel at an intermediate level. It’s all about having a thorough understanding of concepts such as the utilisation of functions and formulas, data processing, tables and charts creation, and conditional formatting. This certification is recognized widely in many industries as it showcases the ability of a person to handle tasks and projects requiring data management and analysis.

Microsoft Excel certification furnishes individuals with advanced skills and knowledge in Microsoft Excel. The course generally covers topics such as data manipulation, complex formulas, VLOOKUP, HLOOKUP, preparing pivot tables and charts, conditional formatting, and utilising functions like IF, COUNTIF, and SUMIF. It empowers participants to proficiently handle and analyse large data sets, automate tasks, and produce more impactful reports and presentations.

Skills measured

• Manage worksheets and workbooks
• Manage data cells and ranges
• Manage tables and table data
• Perform operations by using formulas and functions
• Manage charts