Excel Intensive 2: Preparation and Access to the Official Microsoft MO-201 Certification
Excel Intensive 2: Preparation and Access to the Official Microsoft MO-201 Certification
This advanced Excel course prepares participants to take the official Microsoft MO-201 (Microsoft Excel Expert) certification exam. Through hands-on exercises, participants will deepen their knowledge of advanced workbook management, collaboration and data protection, advanced functions, macros, specialized charts, and data analysis tools. The activity includes access to the official Microsoft MO-201 certification process.
Specific goals | Temary
OBJECTIVES
- Prepare for the official Microsoft MO-201 (Microsoft Excel Expert) certification exam
- Master the advanced Excel skills and functionalities assessed in the certification
- Apply best practices and solve practical cases aligned with the requirements of the official exam
SYLLABUS
- Workbook management
- Copy macros between workbooks
- Reference data from other workbooks
- Enable macros in a workbook
- Prepare the workbook for collaboration
- Restrict editing
- Protect sheets and lock cells
- Protect the workbook structure
- Configure formula calculation options
- Auto-fill
- Custom numeric format
- Data validation
- Subtotals
- Remove duplicates
- Conditional formatting
- Functions
- IF, IFS, SWITCH, SUMIF, AVERAGEIF, COUNTIF, MAXIFS, MINIFS, AND, OR, NOT, NPER, PMT
- VLOOKUP, HLOOKUP, MATCH, INDEX
- TODAY, NOW, WEEKDAY, WORKDAY
- Consolidate
- Analysis and IF...
- Formula auditing
- Macros
- Charts
- Pivot tables
- Pivot charts
Level 0
Previous Excel courses
Level 1
Excel Intensive 1: Preparation for the official Microsoft MO-200 certificate
Level 2
Excel Intensive 2: Preparation for the official Microsoft MO-201 certificate
Editions
General information
>> This activity prepares participants to obtain the official MO-201 certificate from MICROSOFT. Barcelona Activa will offer one free attempt at the official certification exam to participants who attend all activity sessions and successfully pass the established self-assessment test.
>> In the case of live virtual sessions held via ZOOM, registered participants will not receive any link in the automatic email. The email instructions indicate that access will be enabled in the Personal Area between 1 and 2 hours before the activity begins. Please consult the rules and FAQs for more information.
>> If the format is a live virtual session delivered through the free Microsoft Teams platform, registered participants will receive an email with the invitation link and access instructions before the session starts.
>> Entry to the classroom will not be permitted more than 15 minutes after the activity has started.
>> The language used in each session is specified in the description of each activity.
Trainer's person
FERRER MARTÍNEZ
