RS-CAE (Rajasthan State Certificate in Advanced Excel)
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.
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.
Class 12 Pass with Basic Knowledge of MS Excel (RS-CIT Pass preferred)
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.
Learner can search & contact nearest RKCLs Authorized IT Gyan Kendra and coordinate with them for admission process.
Minimum batch size will be 30 (first come first serve basis) & formed by RKCL as per state wide admission status & applicable time slots.
Learner can choose any of the following option in consultation with RKCL’s Authorized IT Gyan Kendra:
Live online classes will be undertaken by the Instructor via a mix of English and Hindi language
Digital Notes (pdf, presentations) will be provided for each topic in English language
Course completion certificate to be issued by RKCL
Rs 5500/- (inclusive of all taxes)
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 |