
Advance Excel Course
The Advanced Excel Training Program Course covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel. These advanced Excel functions can be combined to create some very advanced and complex formulas to use.
What to Learn
Students will be presented with interesting real-life scenarios and have to use the Excel tools, functions, and data visualization techniques learned to solve problems, make inferences, and present data in a meaningful and effective manner using Excel.

Skills You Learn -
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.
Job Prospects -
Completing RKCL's Advanced Excel course can lead to various job prospects, including key job roles like:
- Data Analyst: Analyse and interpret complex datasets to support business decisions.
- Financial Analyst: Perform financial modelling, budgeting, and forecasting using advanced Excel tools.
- Business Analyst: Support business strategy with data-driven insights and reporting.
- Project Manager: Manage project timelines, resources, and budgets with advanced Excel tracking and reporting.
- Operations Analyst: Optimize business processes and workflows through data analysis.
- Marketing Analyst: Track and analyse campaign performance, customer data, and market trends.
- Sales Analyst: Generate sales reports, forecast trends, and analyse performance metrics.
- Consultant: Provide data-driven solutions to clients across various industries.
Course Eligibility -
On ensure successful participation in the course, the following prerequisites are recommended:
- Basic understanding of Microsoft Excel: Familiarity with the Excel interface, entering data, formatting cells, and navigating through worksheets.
- Fundamental knowledge of Excel functions: Ability to use common functions such as SUM, AVERAGE, and COUNT.
- Experience with creating charts and tables: Should know how to create basic charts and tables within Excel to visualize data.
- Basic formula writing: Comfort with writing and editing simple formulas in Excel.
- Familiarity with data organization: Understanding of how to organize data effectively within a spreadsheet.
- Computer literacy: Proficient use of a computer, managing files, and navigating the operating system.
- Learner should preferably be a Class 10th Pass student: (Not Compulsory)
- The learner should have done the RS-CIT Course: (Not Compulsory)
These prerequisites are designed to ensure that learners have the foundational skills required to fully benefit from the course. Even if you feel you might not meet all the prerequisites perfectly, a willingness to learn and engage with the course material will also go a long way in ensuring your success.
Course Duration -
Course Duration: 120 Hours (ideally 3 months i.e. 2 hours daily for 5 days a week).
Admission Process -
- To get more details about the batch timing and the admission process, the learner can contact our office or fill out the online contact form.
- Once Admission is confirmed, the learner will receive a User ID and password to start e-learning through the RKCL LMS portal.
Mode of Learning -
The learner can choose any of the following options in consultation with RKCL’s Authorized IT Gyan Kendra:
- Learn Online at the Center: Learning at our center using our Lab & Internet.
- Learn Online at Home: Learning at Home using Home Computer/PC & Home Internet.
- Self-Paced Modules: Students access digital content, such as video lectures, reading materials, and quizzes on the RKCL LMS portal, allowing them to learn at their own pace.
- Online Assignments and Assessments: Students complete assignments and tests through RKCL's online LMS platform, receiving instant feedback and grades.
Medium of Learning -
Live online classes will be undertaken by the Instructor via a mix of English and Hindi language
Study Material -
Every registered student will get a User ID & Password for accessing the immersive and engaging e-learning content of the course on RKCL's LMS portal.
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 the course end exam)
Certification -
A course completion certificate to be issued by RKCL.
Course Fees
Rs 3500/- (inclusive of all taxes)
Advance Excel Syllabus
1 | Excel Fundamentals & Import data into workbooks |
2 | Navigate within workbooks & Modification |
3 | Format worksheets and workbooks & Data |
4 | Customize options and views |
5 | Configure content for collaboration |
6 | Manipulate data in worksheets |
7 | Format cells and ranges |
8 | Define and reference named ranges |
9 | Summarize data visually |
10 | Create and format/sort tables |
11 | Insert references |
12 | Calculate and transform data |
13 | Format and modify text |
14 | Create Charts & Advanced Charts |
15 | Modify charts |
16 | Format charts |
17 | Manage workbooks |
18 | Prepare workbooks for collaboration |
19 | Use and configure language options |
20 | Fill cells based on existing data |
21 | Format and validate data |
22 | Apply advanced conditional formatting and filtering |
23 | Perform logical operations in formulas |
24 | Look up data by using functions |
25 | Use advanced date and time functions |
26 | Perform data analysis |
27 | Troubleshoot formulas |
28 | Create and modify simple macros |
29 | Create and modify PivotTables & PivotCharts |
ENROLL TODAY
To enroll in this course, Please submit your details here