April 29

1. Create Worksheets and Workbooks

2. Navigate in Worksheets and Workbook

3. Format Worksheets and Workbook

4. Customize Options and Views for Worksheets and Workbooks

5. Configure Worksheets and Workbooks for Distribution

April 30

1. Apply Custom Data Formats and Validation

2. Apply Advanced Conditional Formatting and Filtering

3. Create and Modify Custom Workbook Element

4. Prepare a Workbook for Internationalization

May 02

1. Create and Manage Table

2. Manage Table Styles and Option

3. Filter and Sort a Table

May 03

1. Summarize Data by using Functions

2. Perform Conditional Operations by using Functions

3. Format and Modify Text by using Functions

May 06

1. Create Charts

2. Format Charts

3. Insert and Format Objects

May 07

1. Manage Workbooks

2. Manage Workbook Review Restrict editing

May 08

1. Apply Custom Data Formats and Validation

2. Apply Advanced Conditional Formatting and Filtering

3. Create and Modify Custom Workbook Elements

4. Prepare a Workbook for Internationalization

May 09

1. Apply Functions in Formulas

2. Look up data by using Functions

3. Apply Advanced Date and Time Functions

4. Perform Data Analysis and Business Intelligence

5. Troubleshoot Formulas

6. Define Named Ranges and Objects

May 10

1. Create Advanced Charts

2. Create and Manage PivotTables

3. Create and Manage Pivot Charts

May 13

1. Perform calculations by using the pmt , ipmt and ppmt functions
2. Import , Transform , Combine , Display , and Connect  to data
3. Data Consolidation
4. Perform What-if-analysis by using Goal seek , Scenerio Manager and data table.
    

May 14

1. Familiarizing the students with the exam format , including the types of questions , time limits , and scoring system 
2. Solving past exam papers with the assistance of the trainer.
3. Make the students to involve in a series of steps that they need to follow in order to sign up for the Microsoft Office Specialist Examination.