Advanced Excel Course Contents!

• Introduction of MS Excel

• Formatting Cell & Worksheet

• Conditional Formatting

• Data Sorting, Filter & Advance Filter

• Creating Charts & Graphics

• Pivot table & Pivot Charts

• Data Validation

• Scenario, Goalseek, Data Table

• Macros

• Logical Function (If, And, Or, Not)

• Text Function

• Date & Time Function

• Financial Function

• Mathematical Function

• Lookup Function

• Consolidation

• MIS Reports

• And Much More...