KLiC Advanced Excel

Eligibility

➤Learner should preferably a std. 10th Pass student (Not Compulsory)

➤It is desirable that Learner should have done MS-CIT Course (Not Compulsory)

Who Should Join

• Accounting and Finance Students – To gain practical skills in managing data, preparing reports, and performing financial analysis.

• Business and Management Students – Essential for understanding data-driven decision-making, budgeting, and inventory management.

• Data Analysts and Aspiring Data Professionals – Offers foundational tools like pivot tables, formulas, and scenario analysis for handling large datasets.

• Retail Store Managers and Logistics Staff – Useful for inventory tracking, sales analysis, and reporting.

• Human Resources (HR) Professionals – Beneficial for managing employee data, attendance records, and performance analysis.

• Project Managers – Enables tracking project progress, managing resources, and scenario planning for effective project outcomes.

• Entrepreneurs and Small Business Owners – Essential for budgeting, sales analysis, and performance reporting to optimize business decisions.

Certification

• KLiC courses are recognised by Yashwantrao Chavan Maharashtra Open University (YCMOU).

• MKCL provides certificate to the KLiC learner after his/her successful course completion.

• Yashwantrao Chavan Maharashtra Open University (YCMOU) provides mark sheet to successfully passed KLiC learners (Jurisdiction: Maharashtra).

Syllabus

The syllabus covers the following skills:

• Basics of Data Management

• Introduction to Computer Typing and Data Entry

• Introduction to various Typing Methods

• Introduction to Data Anaylsis

• Apply Custom Formats and Layouts

• Create Advanced Charts

• Pivot tables and charts

• Data Visualisation and Data Analysis

• Use Scenarios

• Manage and Share Workbooks

• Typical Data Entry Projects

• Create advanced formulas

• Free and Open-Source Tools for Data management

• Different Data Entry Methods and Data Cleaning

• Introduction to DBMS

Evaluation Pattern

Evaluation Pattern of KLiC Courses consists of 4 Sections as per below table:

YCMOU Mark Sheet

Printed Mark Sheet will be issued by YCMOU on successful completion of Section 1, Section 2 and Section 3 and will be delivered to the learner by MKCL.
YCMOU Mark Sheet will be available only for Maharashtra jurisdiction learners.

MKCL's KLiC Certificate

The certificate will be provided to the learner who will satisfy the below criteria:

• Learners who have successfully completed above mentioned 3 Sections i.e. Section 1, Section 2 and Section 3

• Additionally, learner should have completed Section 4 (i.e. Section 4 will comprise of SUPWs i.e. Socially Useful and Productive Work in form of Assignments)

• Learner has to complete and upload minimum 2 out of 5 Assignments

KLiC Courses Fee Structure from 01 January, 2025

KLiC Courses of 120 Hours:

From 01 January 2025 onwards, the fees for all KLiC courses in ALCs of Mumbai
will be applicable as shown in the table below:

Total fee is including of Course fees, Examination fees and Certification fees

Important Points:

* Above mentioned fee is applicable for all Modes of KLiC Courses offered at Authorised Learning Center (ALC) and at Satellite Center

* Total fee is including of Course fees, Examination fees and Certification fees

* MKCL reserves the right to modify the Fees of Courses during the year without any prior notice and MKCL shall not be liable to anyone for any such modification/s

Recommended Courses

View Courses on Offer

KLiC Digital Freelancing

Digital Freelancing Opportunities are increasing exponentially. This course promotes the concept “Work Locally, Earn Globally”.

KLiC Tally Prime with GST

Enroll in KLiC Tally Prime with GST and learn everything about Accounting!

The duties of a data entry operator include gathering and entering data into databases and maintaining accurate records of valuable company data.

KLiC Data Entry and Data Management