HOME

ADVANCE EXCEL

Advanced Excel skills are the ability to perform complex calculations, simulations, and data analysis using Excel. These skills can help you work more efficiently and effectively in a variety of business tasks.

More About Advance Excel...

Advanced Excel is a data analysis and reporting program that helps users automate, visualize, and summarize data. It can also help users collect and analyze data quickly.

Course Details:

Duration: Duration: 120 hours (2 months)
Eligibility: Open to all individuals seeking to improve their Skill
Mode of Learning: offline learning options, including eLearning modules, hands-on practice sessions, and guidance from certified professionals.

Syllabus Highlights:

Apply custom formats and layouts
Create advanced formulas
Use of Scenario
DPivot tables and charts
Manage and share workbooks
MKCL ERA (MKCL’s Educational Resource Aggregator) is a digital platform designed to enhance the learning experience and promote digital literacy across Maharashtra. It is created and managed by the Maharashtra Knowledge Corporation Limited (MKCL). The platform acts as a centralized hub for various educational resources, digital learning tools, and online training programs.
Examination: The course culminates in an examination to assess the acquired skills.
Certification: Successful candidates receive the Advance Excel (GOVERNMENT) certificate.

SYLLABUS

SR.NO	TOPIC
1	FORMULAS
2	SUM, SUMIF
3	LOOKUPs
4	V-LOOKUP
5	H-LOOKUP
6	MIS-REPORT
7	PIVOT TABLE
8	TAB CREATION
9	AND MORE