Advance Excel Course by career planet

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