RS-CAE (Rajasthan State Certificate in Advanced Excel)
Course Introduction
Microsoft Excel remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to anyone’s employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, RKCL believes this Advanced Excel course will position our learners ahead of others and help them gain professional traction. In this Advanced Excel course, one will become a power user of Excel. The topics will challenge a user to learn how to use advanced formula techniques and sophisticated lookups. User will clean and prepare data for analysis, and learn how to work with dates, text and financial functions. An in-depth look at advanced Excel features will prepare learners on how to build professional dashboards in Excel. This course aims to offer advanced knowledge of Excel which means possessing the ability to use spreadsheets, graphs, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks.
Job Scope
Now days, many jobs across Banking, KPO, Retail & Financial domains require advanced MS Excel skills. Such skills are in great demand for both professional growth & new analytics based job roles. After completing the course, one can expect a suitable position as an ERP/MIS Assistant or Analyst in MIS/Finance/Accounts section in any organization.
Course Eligibility
Class 12 Pass with Basic Knowledge of MS Excel (RS-CIT Pass preferred)
Course Duration
120 hours (2 hrs per day, 5 days a week) out of which 100 hours will be instructor led online training and 20 hours will be offline self-learning/practice sessions.
Admission Process
Learner can search & contact nearest RKCLs Authorized IT Gyan Kendra and coordinate with them for admission process.
Batch Size
Minimum batch size will be 30 (first come first serve basis) & formed by RKCL as per state wide admission status & applicable time slots.
Mode of Learning
Learner can choose any of the following option in consultation with RKCL’s Authorized IT Gyan Kendra:
- Learn Online at Center: Learning at Authorized ITGK using ITGK Lab & Internet
- Learn Online at Home: Learning at Home using Home Computer/PC & Home Internet
- Instructor will use Microsoft Teams platform to deliver Live Online training
Medium of Learning
Live online classes will be undertaken by the Instructor via a mix of English and Hindi language
Study Material
Digital Notes (pdf, presentations) will be provided for each topic in English language
Certification
Course completion certificate to be issued by RKCL
Course Fees
Rs 5500/- (inclusive of all taxes)
Course Syllabus
S.No. |
Syllabus |
Duration (in Hrs) |
1 |
MS Excel 2010 Basics |
1 |
2 |
Create/Navigate/Format/Print worksheets and workbooks |
1 |
3 |
Format data in cells and ranges; Order & Group Cells/Ranges |
2 |
4 |
Create/Modify a table; Filter and sort a table |
4 |
5 |
Pivot Table, Pivot Charts, Slicers, Power Pivot |
8 |
6 |
Utilize cell ranges and references in formulas and functions |
8 |
7 |
Summarize data with Functions, Arrays |
10 |
8 |
Utilize Conditional logic in functions (IF,AND,OR, NESTED IF, etc) |
12 |
9 |
Utilize Conditional logic in functions (IF,AND,OR, NESTED IF, etc) |
12 |
10 |
Macros (recording macros, assign macro, VBA basics) |
10 |
11 |
Format and modify text with functions (Text Formulas) |
8 |
12 |
Create/Format a chart (3d graphs, inline charts) |
6 |
13 |
VLOOKUP, HLOOKUP, INDEX, MATCH functions |
12 |
14 |
Date/Time Functions |
4 |
15 |
Protecting Workbooks |
2 |
16 |
Project (IT Infrastructure Management application or Car Sales application) |
6 |
17 |
Self-Learning and Practice Sessions |
20 |
Total Duration |
120 |