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).

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

The Academic Approach of the course focuses on the work centric education i.e. begin with work (and not from a book !), derive knowledge from work and apply that knowledge to make the work more wholesome, useful and delightful. The ultimate objective is to empower the Learner to engage in socially useful and productive work. It aims at leading the learner to his/her rewarding career as well as development of the society.<

Learning methodology

• Learners are given an overview of the course and its connection to life and work.
• Learners are then exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Learners are then acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Learners are then acquainted with the architecture of the tool or Tool Map so as to appreciate various parts of the tool, their functions and their inter-relations.
• Learners are then exposed to simple application development methodology by using the tool at the beginners level
• Learners then perform the differential skills related to the use of the tool to improve the given ready-made outputs.
• Learners are then engaged in appreciation of real-life case studies developed by the experts.
• Learners are then encouraged to proceed from appreciation to imitation of the experts.
• After imitation experience, they are required to improve the experts outputs so that they proceed from mere imitation to emulation.
• Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression.

Skills: Apply Custom Data Formats, Use Advanced Fill Options, Apply Advanced Conditional Formatting and Filtering, Use Form Controls, Apply Custom Styles and Templates, Prepare Workbooks for Internationalization, Mathematical Functions, Look up data by using functions, Apply advanced date and time functions, Functions for Manipulating Text, Merge Scenarios, Create Scenarios, Use Area, Scatter & Stock Charts, Create Custom Chart Templates, Manage Workbook Versions, Copy Macros between Workbooks, Protect Workbooks for Sharing

Outputs: Event Expenses, Exam Record, Planner, to do List, Database, Monthly Budget, Agenda, Receipt, Inventory

Syllabus Mapping: The KLiC Advanced Excel Course is mapped to MBA elective subject MS Excel and Advanced Excel Lab. The 94% syllabus of the MS Excel and Advanced Excel Lab matches with KLiC Advanced Excel. Hence course is highly recommended to MBA students

Event Expense sheet

Database

Detailed Syllabus:

Apply Custom Formats and Layouts

• Apply Custom Data Formats
• Use Advanced Fill Options
• Apply Advanced Conditional Formatting and Filtering
• Apply Custom Styles and Templates
• Use Form Controls
• Prepare Workbooks for Internationalization
• Use Outlines
• Use Custom Views

Create advanced formulas

• Functions
• Apply functions in formulas
• Mathematical Functions
• Financial functions
• Useful Data Functions
• Some Other Useful Functions
• Look up data by using functions
• Apply advanced date and time functions
• Functions for Manipulating Text
• Arrays

Use Scenarios

• Use What-If Analysis Tools
• Create Scenarios
• Merge Scenarios
• Create Scenario Summaries
• Use Data Tables
• Create Advanced Charts
• Basic Excel Charts
• Use Area, Scatter & Stock Charts
• Use Surface, Radar & Combination Charts
• Create Custom Chart Templates
• Work with Sparklines

Pivot tables & charts

• PivotTables
• Use Pivot Charts

Manage and Share Workbooks

• Manage Workbook Versions
• Copy Styles between Workbooks
• Copy Macros between Workbooks
• Use Track Changes and Comments
• Merge Workbooks
• Protect Workbooks for Sharing
• Connect To External Data
  
  
  Download Syllabus

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

MKCLs KLiC Certificate will be provided to the learner who will satisfy the below criteria:

1. Learners who have successfully completed above mentioned 3 Sections i.e. Section 1, Section 2 and Section 3
2. 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 passed preferred.

Should preferably be a 10th/12th Std. passed student. (Not compulsory)