Microsoft Excel Advanced

This training covers the ability to deal with advanced features of MS Excel, including the knowledge of how to manage workbooks, prepare them for collaboration, filling cells with data, conditional formatting and data validation, applying advanced formulas and data analysis, creating macros, creating / modifying advanced charts, and pivot tables in MS Excel.

Participants are expected to demonstrate correct application of the advanced features of MS Excel and complete tasks independently. After completion, they can prove their skills by passing the certification exam MO-201.

Participants are expected to demonstrate correct application of the advanced features of MS Excel and complete tasks independently.

1. Manage workbook options and settings (3 hours: 1.5h theory, 1.5h practice)

1.1 Manage workbooks

1.2 Prepare workbooks for collaboration

1.3 Use and configure language options

2. Manage and format (3 hours: 1.5h theory, 1.5h practice)

2.1 Fill cells based on existing data

2.2 Format and validate data

2.3 Apply advanced conditional formatting and filtering

3. Create advanced formulas and macros (6 hours: 3h theory, 3h practice)

3.1. Perform logical operations in formulas

3.2. Look up data by using functions

3.3. Apply advanced date and time functions

3.4. Perform data analysis

3.5. Troubleshoot formulas

3.6. Create and modify simple macros

4. Manage advanced charts and tables (3 hours: 1.5h theory, 1.5h practice)

4.1 Create and modify advanced charts

4.2 Create and modify PivotTables

4.3 Create and modify PivotCharts

TOTAL: 15 hours (50% theory, 50% practice)