The objective of Advanced MS Excel program is to equip you with hands-on practical skills in application of advanced tools and techniques in Microsoft Excel application. The skills will enable you capture data, analyze data, and generate reports at advanced levels in a user-friendly way.
Areas To Be Covered:
1. Understanding the excel worksheet interface and structure preparation.
2. Applying advanced data capturing techniques and data validation in excel.
3. Using advanced formatting techniques in excel and its practical application.
4. Using advanced extracting and filtering of data in excel and from other sources.
5. Manipulating data for analysis using advanced excel functions and formulas.
6. Analyzing data for reporting using advanced excel common analysis tools.
7. Generating charts and using advanced visualization techniques for reports.
8. Securing cells, worksheets, and workbooks, and security best practices.
9. Collaborating with teams, setting controls, and automating recurrent tasks.
Duration and Mode of Training:
• Training Duration: 30 Hours / 4 Weeks.
• Mode of Training: Online or Physical.