Course Features
- Language: English, Marathi, Hindi
- Duration: 120 hours (2 months)
- Learning Mode: Center
- Jurisdiction: Nationwide
- Certificate of Completion
Eligibility
Learner should preferably be a 10th grade pass (Not Compulsory).
It is desirable that the learner should have done the 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.
What You’ll Learn
After completion of the course, you can get a suitable position in any organization as an Accounts Assistant, Finance Analyst, Retail Store Manager, or Data Analyst.
Syllabus
- Apply custom formats and layouts
- Create advanced formulas
- Use of Scenario
- Pivot tables and charts
- Manage and share workbooks
Outputs:
- Organizing the data professionally
- Using Metadata and Big Data
- Internationalization for Excel Workbooks
- Data segregation using custom formats and layouts
- Dashboard creation using Power Query and Power Pivot table
- Using Power Map
- Connecting Excel workbooks to external data
- Preparing a checklist for data collection using Canva
- Data collection for social media marketing
Syllabus Mapping: The KLiC Advanced Excel is highly recommended to MBA students as it covers 94% of the syllabus for the MBA subject ‘MS Excel and Advanced Excel Lab’.
Evaluation Pattern
| Section No. |
Section Name |
Total Marks |
Minimum Passing Marks |
| 1 |
Learning Progression |
25 |
10 |
| 2 |
Internal Assessment |
25 |
10 |
| 3 |
Final Online Examination |
50 |
20 |
| 4 |
SUPWs (Socially Useful and Productive Work in form of Assignments) |
5 Assignments |
2 Assignments to be Completed & Uploaded |
KLiC Courses Fee Structure (Effective 01 January 2025)
| Mode |
Total Fee (Rupees) |
Single Installment (Rupees) |
Two Installments (Rupees) |
| Single Installment |
6000/- |
6000/- |
N/A |
| Two Installments |
6200/- |
3100/- |
3100/- |
