MKCL- Advance 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.
This course includes:
Language: English, Marathi
Duration: 120 hours (2 months)
Learning Mode: Center, Mobile, Online
Jurisdiction: Nationwide
Certificate of Completion
₹ 5000/-
120 hours (2 months)
(Learning Only (LO) Mode)
(LO) Mode is available all over India
Pay through Payment Gateway
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.
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).
Academic Approach
The course focuses on practical knowledge and application. The aim is to make the learner efficient and to offer him or her rewarding career.
Learning Methodology
The participants get the Overview of the course, use of tools and their application in real life
He or She learns about available career opportunities, roles to be performed at the workplace
Learner gets to know various parts, functions and inter relations of the tool
At the Beginner Level, the learner knows the Simple Application Development Technology
Encourage him or her to develop integral skills required to make them job-ready
Syllabus
The syllabus covers the following skills:
Apply custom formats and layouts
Create advanced formulas
Use of Scenario
Pivot tables and charts
Manage and share workbooks
BASIC OF DATA MANAGEMENT
Cost centers and cost categories
Creating different ledgers
Creating different cost categories and Centres
Making different types of voucher entries
Viewing different cost center report
Introduction to Data Management
How do professionals organize their data?
Meta Data and Big Data
Freelance Data Entry Jobs
INTRODUCTION TO COMPUTER TYPING AND DATA ENTRY
Introduction to Typing
Keyboarding
Ergonomic Typing
INTRODUCTION TO DATA ANALYSIS
Using different types of keys and symbols in typing
Google Docs – Voice Typing
Lipikaar App
Text Formulas
Text Manipulation Functions
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
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 ADVANCE CHARTS
Basic Excel Charts
Use Area, Scatter & Stock Charts
Use Surface, Radar & Combination Charts
Create Custom Chart Templates
Work with Sparkline’s
PIVOT TABLES & CHARTS
Pivot Tables
Use Pivot Charts
Create Dashboard using Pivot Table
Using Power Query
DATA VISUALISATION AND DATA ANALYSIS
Use of Macros
Using Data Tables
Create Dashboard using Pivot Table
Using Power Query
USE SCENARIOS
Use What-If Analysis Tools
Create Scenarios
Merge Scenarios
Create Scenario Summaries
Use Data Tables
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
INTRODUCTION TO DBMS
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
What is a DBMS and its purpose?
Types of DBMS
Examples of DBMS - MySQL, Oracle, etc.
Evaluation Pattern
Evaluation Pattern of KLiC Courses consists of 4 Sections as per below table:
Total Marks Minimum Passing Marks
Learning Progression 25 10
Internal Assessment 25 10
Final Online Examination 50 20
Total 100 40
SUPWs (Socially Useful and Productive Work in form of Assignments), 5 Assignments, 2 Assignments to be Completed & Uploaded
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