October 4

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

October 5

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

October 6

1. Create and Manage Table

2. Manage Table Styles and Option

3. Filter and Sort a Table

October 7

1. Summarize Data by using Functions

2. Perform Conditional Operations by using Functions

3. Format and Modify Text by using Functions

October 8

1. Create Charts

2. Format Charts

3. Insert and Format Objects

October 9

1. Manage Workbooks

2. Manage Workbook Review Restrict editing

October 10

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

October 11

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

October 12

1. Create Advanced Charts

2. Create and Manage PivotTables

3. Create and Manage Pivot Charts

October 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.
    

October 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.