MO-201: Microsoft Excel Expert
MO-201: Microsoft Excel Expert
90 hours
275 €
E-learning
Description of the course
Become an Excel Expert 2019 expert with this official Microsoft course and master advanced features for analyzing data, automating tasks, and making strategic decisions. Learn to create professional spreadsheets, manage large data sets, perform complex analyses, and much more. Prepare to earn the official Microsoft MOS certification and gain the skills you need to stand out in today's job market.
Profile of Access
This course is aimed at a wide range of users, from professionals looking to deepen their Excel knowledge and acquire advanced skills to optimize their workflows, to students who want to excel in their academic work and gain a competitive advantage in the future. It is also ideal for experienced users who want to explore the latest features and tools in Excel Expert 2019 and take their skills to the next level.
Objectives of the Course
✓ Master advanced formulas and functions to perform complex data analysis and identify trends, patterns, and hidden relationships in your data sets.
✓ Create sophisticated data models to simulate what-if scenarios, assess risks, and make strategic decisions based on accurate information.
✓ Automate repetitive tasks with macros and VBA to save time and effort, freeing yourself from tedious tasks and increasing your productivity.
✓ Visualize data in powerful ways with dynamic charts, pivot tables, and advanced data analysis tools.
✓ Connect Excel with other analysis tools to expand your capabilities and gain a complete view of your data.
✓ Communicate your results effectively through professional reports and visually compelling presentations.
Contents of the Course
MODULE 1. Advanced Format
- Apply custom number formats.
- Apply custom accounting formats.
- Use custom date and time formats.
- Apply conditional formatting using formulas.
- Apply international currency and number formats.
- Insert international currency symbols.
- Apply custom and international date and time formats.
- Set the editing and display language.
- Understanding fonts, +Body and +Title.
MODULE 2. Advanced functions and formulas
- Understanding functions.
- Use the CHOOSE function.
- Using the INDEX function.
- Use the MATCH function.
- Using the HLOOKUP function.
- Using the VLOOKUP function.
- Using date and time functions.
- Use the error checking tool.
- Trace formula errors.
- Evaluate formulas.
- Review and display formulas manually.
- Configure data validation.
MODULE 3. Analyze data using pivot tables and pivot charts
- Create a pivot table.
- Format PivotTable Data.
- Filter pivot table data.
- Using slicers with a pivot table.
- Add calculated fields and items.
- Manually group pivot table data.
- Create a pivot chart.
- Change PivotChart Options.
- Examine a PivotTable and PivotChart.
- Working with PivotChart Styles.
MODULE 4. Book management functions
- Link to other books.
- Modify book links.
- Remove links from books.
- Consolidate data.
- Use comments.
- Protect the spreadsheet.
- Allow editing ranges.
- Protect the structure of the book.
- Set general and book-specific options.
MODULE 5. Advanced graphics, functions and hypothesis analysis
- Add a secondary vertical axis.
- Use advanced chart types.
- Using financial functions.
- Nesting functions.
- Using conditional logic functions.
- Using conditional summary functions.
- Use Find Object tool.
- Working with scenarios.
- Using the Watch Window.
MODULE 6. Manipulating data and using macros
- Use the fill series tool.
- Fill cells using flash fill.
- Remove duplicate rows.
- Outline data using automatic subtotals.
- Group and ungroup data manually.
- Access hidden ribbon tabs.
- Configure macro security.
- Record macros.
- Modify in the Visual Basic Editor.
- Copy macros between workbooks.
CERTIFICATIONS:
MO-201: Microsoft Excel Expert
