Excel Intensive 2: Preparation for the official Microsoft MO-201 certificate
Excel Intensive 2: Preparation for the official Microsoft MO-201 certificate
This advanced Excel course is designed to deepen the Excel skills needed to obtain the MO-201 certification. The curriculum includes workbook management, preparing for collaboration, using macros, creating advanced charts, and analyzing data with pivot tables. Participants will acquire advanced skills to optimize their use of Excel in professional environments.
Specific goals | Temary
OBJECTIVES
- Master advanced workbook and Macro management
- Prepare the workbook for collaboration
- Analyze and visualize data in an advanced manner
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 1
Previous Excel courses
Level 2
Excel Intensive 1: Preparation for the official Microsoft MO-200 certificate
Level 3
Excel Intensive 2: Preparation for the official Microsoft MO-201 certificate
Editions
General information
>> This activity prepares students to obtain the official MO-201 certificate from MICROSOFT. This action is voluntary and requires a payment. Barcelona Activa does not manage or facilitate the certification process, which is completely external to this institution.
>> In the case that the format is virtual streaming, it will be carried out through the free Microsoft Teams platform. Registered individuals will receive the link with the invitation and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the Cibernàrium training actions may be recorded through an image capture system with the aim of its subsequent dissemination through a medium or support within the scope of Barcelona Activa's mission to contribute to economic promotion and employment. During the recording process, images of the training attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Trainer's person
FERRER MARTÍNEZ
Related courses
- Excel Intensive 1: Preparation for the official Microsoft MO-200 certification
- Excel: Conditional Formulas and Formats (Custom Editing)
- Excel: Create Data Models with Power Pivot (Custom Editing)
- Excel: Extract and transform your data with Power Query
- Excel: Formulas and Conditional Formattin
- Excel: Pivot Tables and Pivot Charts
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.
