Course Name

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

7A, Jhalana Institutional Area, Behind R.T.O, Jaipur - 302004, INDIA

0141-5159700
info@rkcl.in

RKCL’s Helpline No - 0141-5159700

Timinings : 10:00 AM To 6:30 PM

Monday to Friday

CIN : U80302RJ2008PLC026433

PAN : AAECR1253K

GST : 08AAECR1253K1ZB