Klic Diploma
Klic Diploma


An Excel Expert is a person who collects, organizes, and analyzes data. S/He is also involved in finding, editing and analyzing data, creating databases and writing reports with conclusions. There are various techniques of data analysis, which an excel expert must understand in order to perform efficiently.

Why take admission?

An Excel Expert would work in a team of Database Administrator, Database Developer and System Administrator. S/He may work in educational institutes, IT industries and corporate.

Monetary compensation:

A fresher can draw up to Rs. 1.5 – 2. 5 Lacs p.a.


An Excel Expert is an integral member of the Database Team. S/He is a key contributor on assigned projects, working proactively and independently.


An Excel Expert should be proficient in Spreadsheet applications. S/He should know how to perform calculations using the contents of multiple cells, and be familiar with Excel formulas. S/He should be able to present complex information in an understandable and compelling manner.


  • This course is recognized by Maharashtra Knowledge Corporation Limited (MKCL). MKCL will provide the Expert Certificate subject to fulfillment of requisite criteria. Expert certificate is provided as the appreciation of additional work for the said course in form of mini-projects.

Important Dates

  • Batch Commencement: One batch in each calendar month (January to December)
  • Date(s) of Application and Fee Payment by Learner: 1st - 30th day of each calendar month
  • Date(s) of Learner Confirmation by ALC: 1st - 30th day of each calendar month
  • Course Start Date and Date of Issuing Learner Login: Date of admission confirmation

Academic Approch

Learning Methodology

Course Syllabus


The Syllabus ensures that the following skills are achieved:

Topic Sub-Topic
Custom Formats and Layouts Custom Data Formats, Use Advanced Fill Options, Advanced Conditional Formatting and Filtering, Custom Styles and Templates, Form Controls, Use Custom Views
Create advanced formulas Functions in formulas, Mathematical & Financial Functions, Data Functions, Look up data by using functions, advanced date and time functions, Functions for Manipulating Text, Arrays
Use Scenarios What-If Analysis Tools, Create Scenarios, Merge Scenarios, Create Scenario Summaries, Use Data Tables
Create Advanced Charts Area, Scatter & Stock Charts; Surface, Radar & Combination Charts; Create Custom Chart Templates, Work With Sparklines
Pivot tables & charts Creating Multiple Pivot Tables on the Same Dataset, Use of the Report Filter Options, Pivot Table Styles, Using the Data Slicer
Manage and Share Workbooks Manage Workbook Versions, Copy Styles between Workbooks, Copy Macros between Workbooks, Track Changes and Comments, Merge Workbooks, Protect Workbooks from Sharing, Connect To External Data

Course Duration

Course Duration
Lecture Hours 50 (1 Hour per Day)
Lab Hours 50 (1 Hour per Day)
50 (1 Hour per Day) 30 Hours
Extra Lab Practice 7 Hours
Extra Classroom Practice 7 Hours
Total Hours 144 Hours

Every batch has 2 and 3 months course duration option


The course is available in English.


MS-CIT passed preferred.

Fees Installment

The candidate will be enrolled to KLiC Certificate in English Communication and Soft Skills. Receipt will be given with course name as “KLiC Certificate in English Communication and Soft Skills”.

MKCL Expert Certificate will be given to learner with course name of KLiC ENGLISH in appreciation of additional work performed by learner and subject to fulfilment of requisite criteria.

Fee Installment
Mode Total Fee (Rs) 1st Installment (Rs) 2nd Installment (Rs)
Single Installment 4300 4300 N/A
Two Installment 4500 2250 2250

Admission Process

  • The learner should go to the Darpan Computer - Koregaon. To find out a centre nearest to you, click here.
  • The learner should fill an application form available at the Darpan Computer - Koregaon, along with the prescribed fees.  The fees can be paid in two modes.
  • Relevant documents to be carried at the time of admission are :
    • Xerox copy of Photo Id proof signed by the learner
    • 1 copy of passport size photograph (color or Black & White)
  • Once the learner submits his/her details, relevant documents and pays the fees, the Darpan Computer coordinator will fill the learner details in the darpan computer software and upload the learner data. Further, the Darpan computer coordinator will hand over a fee receipt.
  • Learner is expected to verify the online details filled in by Darpan Computer.
  • Darpan Computer coordinator will hand over the study material whose cost is already included in the fee.  The book is provided as per the medium selected by the learner (English, Marathi, Hindi)
  • After the learner receives the  study material, the learner is eligible to start learning instantly through ERA, using his User ID and password

Study Materials

Instruction for learners