Course Duration:
1 Month
Course Syllabus:
Basic Concepts
- Introduction to MS Excel
- Basic Formulas
- ADVANCE FORMULS
- SPECIAL FEATURE
- XML in Excel
- XML Maps
Charts
- Pie Charts
- Column Charts
- Line Charts
Advanced Tools
- PIVOT TABLE
- LOOKUP / REFRENCE
- AUTO SUM
- RECENTLY USED
- FINANCIAL FUNCTION
- FINACAL LOGICAL
- NAME MANAGER
- DATA VALIDATION
- DATA VALIDATION
- WHAT IF ANALYSIS / SENSITIVE ANALYSIS
- DATA TABLE
- ADVANCE MACROS