Under RKCLs Advanced Excel course, you will learn following key skills:

• Advanced Formulas and Functions: Master complex functions like VLOOKUP, HLOOKUP, INDEX, MATCH, and array formulas.
• Data Analysis Tools: Use PivotTables & PivotCharts for in-depth data analysis.
• Conditional Formatting: Apply complex rules to highlight data trends and anomalies.
• Data Validation: Create custom data entry rules to maintain data integrity.
• Macros: Automate repetitive tasks with macros
• Advanced Charting Techniques: Design dynamic and visually compelling charts and graphs.
• What-If Analysis: Use tools like Goal Seek, Scenario Manager, and Data Tables for predictive analysis.
• Advanced Data Sorting and Filtering: Manage large datasets with custom sorting and filtering techniques.
• Working with External Data: Import, clean, and manipulate data from various sources.
• Collaboration Features: Track changes, protect workbooks, and collaborate effectively with others.

Duration

• Course Duration: 120 Hours (ideally 3 months i.e. 2 hours daily for 5 days a week)

Study Material

• Every registered student will get a User ID & Password for accessing the immersive and engaging e-learning content of the course on RKCLs LMS portal Click Here
• Additionally, Training Center faculty also provides offline study notes.

Exam

• Mode of Exam: Online
• Exam Portal: RKCL LMS portal
• Exam Venue: RKCL Training Center (Computer Lab)
• Duration of Exam: 60 minutes (1 Hour)
• Total Marks in Exam: 100
• Passing Marks in Exam: 40
• Exam Time Slots: Available for 2 days (Schedules intimated well in advance)
• Result Pattern: Grade based (RKCL awards grade to the candidate as commensurate with the marks secured by them in course end exam)