Requirements

• Basic Excel Proficiency: Familiarity with Excel basics such as navigation
• data entry
• basic formulas
• and functions (SUM
• AVERAGE
• etc.). Understanding of Excel interface and terminology. Intermediate Excel Skills: Experience with intermediate Excel functions and features
• including VLOOKUP
• IF statements
• PivotTables
• and basic chart creation. Ability to manage and organize data using sorting
• filtering
• and basic data validation. Practical Experience: Hands-on experience using Excel for various tasks
• such as data analysis
• report generation
• and financial modeling. Practical knowledge of Excel features in a work or project setting. Preparation Tips Complete Basic and Intermediate Excel Training: If you are not already proficient in basic and intermediate Excel skills
• consider completing relevant courses on platforms like LinkedIn Learning
• Coursera
• Udemy
• or Microsoft Learn. Study Advanced Excel Topics: Focus on the advanced topics covered in the exam
• such as complex formulas
• data analysis tools
• advanced charting
• and VBA macros. Use official study materials like the “Exam Ref MO-201 Microsoft Excel Expert (Office 2019)” book. Hands-on Practice: Regularly practice using Excel to reinforce your understanding and proficiency with the advanced features. Work on real-world scenarios and projects to apply what you have learned.

Description

The MO-201: Microsoft Excel Expert (Office 2019) certification course is designed to equip participants with advanced skills in Microsoft Excel 2019, enabling them to perform complex data analysis, create sophisticated reports, and streamline their workflow through automation. This course is ideal for professionals, students, and enthusiasts who want to demonstrate their expertise and enhance their career prospects.

Course Objectives

By the end of this course, participants will:

• Master Advanced Excel Functions: Learn to use complex formulas and functions, such as VLOOKUP, INDEX/MATCH, and array formulas.

• Analyze and Visualize Data: Gain proficiency in data analysis tools, including PivotTables, PivotCharts, and advanced charting techniques.

• Automate Tasks: Develop and debug macros using VBA to automate repetitive tasks and increase efficiency.

• Manage and Protect Workbooks: Customize Excel settings, manage workbook versions, and apply advanced protection and collaboration techniques.

• Enhance Data Management: Utilize advanced data validation, conditional formatting, and data manipulation methods.

Key Topics Covered

1. Workbook Management:

   • Customizing the Excel environment

   • Protecting workbooks and worksheet structure

   • Managing workbook versions and collaboration tools

2. Advanced Data Management and Formatting:

   • Applying advanced conditional formatting

   • Filtering data with advanced criteria

   • Creating and managing data validation rules

3. Complex Formulas and Macros:

   • Using logical and lookup functions

   • Applying advanced date and time functions

   • Creating and debugging macros with VBA

   • Using advanced formula auditing tools

4. Advanced Charts and Tables:

   • Creating and modifying advanced charts

   • Using sparklines and data visualizations

   • Working with PivotTables and PivotCharts

   • Leveraging data analysis tools like Power Query and Power Pivot

Who this course is for:

• Data Analysts: Those who need to perform complex data analysis
• create detailed reports
• and visualize data effectively. Financial Analysts and Accountants: Professionals who create financial models
• budgets
• forecasts
• and need to automate repetitive tasks using macros. Project Managers: Individuals who track project progress
• manage resources
• and analyze project data using advanced Excel features. Business Intelligence Specialists: Experts who use Excel for data mining
• business reporting
• and leveraging Power Query and Power Pivot for advanced data manipulation. Consultants: Those who provide data-driven insights and recommendations
• requiring proficiency in advanced Excel techniques. Administrative Professionals: Individuals who manage large datasets
• create complex schedules
• and need to streamline data management processes. Students and Educators Students in Business
• Finance
• or Data Science Programs: Those who want to enhance their Excel skills for academic projects
• research
• and future career opportunities. Educators and Trainers: Teachers and trainers who instruct others on Excel and want to certify their advanced proficiency. IT Professionals IT Support and System Administrators: Professionals who provide support for Excel users and need to understand advanced features and troubleshooting. Developers and Programmers: Those who integrate Excel with other applications
• automate tasks using VBA
• and create custom Excel solutions.