HDI

Course Includes

Duration6 Months
Enrolled1
Lectures100
Videos0
Notes0
CertificateYes

What you'll learn

HS-CIT A

The Haryana State Certificate in Information Technology Application (HS-CITA) represents a comprehensive and formally structured program designed to foster literacy and competence in the field of Information Technology (IT).

This esteemed course spans a duration of six months and offers individuals the opportunity to enroll in any of the authorized learning centers facilitated by the Haryana Knowledge Corporation Limited.

One of the prominent merits of this course lies in its potential to significantly augment the career trajectory of both government and private sector employees. Notably, HS-CIT(A) holds an esteemed status in the government sector, as it has been granted exemption from the State Eligibility Test in Computer Appreciation and Application (SETC) Part I, rendering it a coveted qualification in the realm of computer literacy and application.

Course Syllabus

Key Modules of the HS-CIT Advanced Excel Syllabus:

Advanced Data Management & Formatting:
Sorting data (values, colors), advanced filtering, and Data Validation.
Conditional formatting, custom number formats, and data cleaning techniques.
Advanced Formulas & Functions:
Logical functions (IF, AND, OR), Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
Date and Time functions (EOMONTH, NETWORKDAYS).
Array formulas (using Ctrl+Shift+Enter).
Data Analysis & Reporting:
Creating and formatting Pivot Tables and Pivot Charts.
Using Slicers and Timelines for interactive reporting.
Subtotals and grouping data.
What-If Analysis & Automation:
Goal Seek, Scenario Manager, and Data Tables.
Introduction to VBA (Visual Basic for Applications) and Macro recording.
Visualization & Security:
Advanced charting techniques (combination charts, sparklines).
Protecting worksheets, ranges, and workbook structure.