Course DetailsHome / Courses Details

KLiC Advanced Excel
Category :MKCL
KLiC Advanced Excel

Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An Excel Expert collects, edits, analyses data, creates data bases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations.

KLiC Advanced Excel

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 and Data Analyst in any organization.

 

This course includes:

  • Language: English, Marathi, Hindi
  • Duration: 120 hours (2 months)
  • Learning Mode: Center, Online
  • Jurisdiction: Nationwide
  • Certificate of Completion

Syllabus

Download Syllabus

The syllabus covers the following skills:

  1. Apply custom formats and layouts
  2. Create advanced formulas
  3. Use of Scenario
  4. Pivot tables and charts
  5. Manage and share workbooks
  • 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

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% syllabus of MBA subject ‘MS Excel and Advanced Excel Lab’.

Creatin Macros in Excel

Creating Macros in Excel

Zoho Forms

Zoho Forms

Survey Monkey

Survey Monkey

 

Eligibility

  • Learner should preferably a std. 10th Pass student (Not Compulsory)
  • It is desirable that Learner should have done MS-CIT Course (Not Compulsory)