Advance Excel Training 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.
Course Name
RS-CAE (Rajasthan State Certificate in Advanced Excel)
Course Objective
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. The 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 the 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
Nowadays, 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.
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
The learner can contact our office or fill the online contact form for getting more details about the batch timing and the admission process.
Batch Size
The 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
The learner can choose any of the following options in consultation with RKCL’s Authorized IT Gyan Kendra:
- Learn Online at Center: Learning at our center using our Lab & Internet.
- Learn Online at Home: Learning at Home using Home Computer/PC & Home Internet.
- The instructor will use the 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 the English language
Certification
Course completion certificate to be issued by RKCL
Course Fees
Rs 5500/- (inclusive of all taxes)
Advance Excel Syllabus
| 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 |