Excel Intensive 1: Preparation and Access to the Official Microsoft MO-200 Certification
Excel Intensive 1: Preparation and Access to the Official Microsoft MO-200 Certification
This intensive Excel course prepares participants to take the official Microsoft MO-200 (Microsoft Excel Associate) certification exam. Through hands-on exercises, participants will learn how to manage workbooks, apply professional formatting, use functions and formulas, create charts, and analyze data efficiently. The activity includes access to the official Microsoft MO-200 certification process.
Specific goals | Temary
OBJECTIVES
- Master Excel formatting techniques
- Apply basic functions and formulas
- Create and manage charts and tables
SYLLABUS
- Format
- Adjust row and column size
- Insert/Delete cells, columns or rows
- Merge cells
- Cell alignment
- Copy cell format
- Wrap text
- Numeric formats
- Cell styles
- Clear cell format
- Quick Access Toolbar
- Save the workbook in other formats
- Create and delete hyperlinks
- Page setup
- Freeze panes
- Window views
- Show formulas
- Special paste
- Quick fill
- Range names
- Import txt/csv
- Sparklines
- Conditional formatting
- Working with tables
- Types of references: relative, absolute, and mixed
- Functions
- AVERAGE, MAX, MIN, SUM
- COUNT, COUNTA, COUNTBLANK
- IF
- LEFT, RIGHT, MID
- UPPER, LOWER, LEN
- CONCAT, TEXTJOIN
- Charts
- Create a chart in a range
- Create a chart in a sheet
- Modify chart properties
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-200 certification 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
