Axiom Business School · Course

KLiC Advanced Excel

Build professional Excel skills in formulas, dashboards, Power Query, data analysis, and reporting.

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/-

Interested in this programme?

Contact us for course details.

Contact us