1. Vlookup
2. Hlookup
3. Pmt, Ppmt, Ipmt
4. Slm
5. Dbm
6. Match with Index
7. If, And, Or
8. Conditional Formatting
9. Largest Function
10. Highlight Function
11. Goal Seek
12. Name range with formula
13. Data Table and Flash Fill
14. Sum-product Function
15. Pivot Table and Pivot Chart
16. Shortcut Keys
17. Data Validation & Consolidation
18. Tips & Tricks
19. Number Formatting Eligibility :- Should have basic knowledge in MS – Excel and MS – Office.
Job Profile :-
• Back Office Executive.
• Call Center Executive.
• Business analysts.
• Data analysts.
• Financial analysts.
• Office professionals.
• Anyone who wants to advance their career in Excel.
Expected Salary :- 10K to 15K Per Month in India.
Take Away From This Course :-
• Create an Excel spreadsheet and learn how to maneuver around the spreadsheet for data entry.
• Create simple formulas in an Excel spreadsheet to analyze data.
