Description: 

PGDCA full form is Post Graduate Diploma in Computer Application. PGDCA course duration is 1-year, and it focuses on providing students with advanced theoretical and development expertise in computer science and computer applications in the field of IT. PGDCA course fees ranges between INR 7,000 to 1,10,000. PGDCA Syllabus begins with the fundamentals of information technology and lays emphasis on discplines like programming, Java, Data structures, and more.

Microsoft Excel Advance Features
 Menu Bars
o Formula
o Data
o Review
o View
 Project & Assignments
o GST Invoice & Bills
o Payroll
o Income Tax
o Mark sheet
o Basic Data Entry
o Salary Statement
 Advance Formulas & Functions
o Lookup, Vlookup, Hlookup
o Sumif, sumifs
o Counta, countif, countifs, countblank
o Concatenate
o Datedif, date, month, year, day, edate, eodate, time
o Lan, trim, repeat,
o Upper, lower, proper
o Mid, Left, Right
o Dmax, dmin, dsum, daverage, sumproduct
o If, ifs,
o And, or, true, false
o Pivot Table & Chart
o Whatif analysis, goalseek, data table
 Working with option
o Group, ungroup
o Print area
o Print Title
o Freeze panel
o Data validation
o Text to column
o Remove duplicate
o Consolidate
 Advance Shortcut

The Diploma in Computer Applications (DCA) is designed for students who want to build a strong foundation in the world of computers and digital technology.
This course provides complete knowledge of essential computer applications such as MS Office, Internet, Tally, and Basic Programming, helping students to grow their technical and professional skills.

Through practical sessions and real-world learning, students develop confidence to work in offices, startups, and business environments.

Whether you’re a beginner or looking to enhance your career, DCA opens the door to new opportunities in the fast-growing IT world.

Key Highlights:

• Learn essential computer tools and software.

• Gain professional typing and data handling skills.

• Understand basic programming and internet concepts.

• Suitable for students, job seekers, and entrepreneurs.

• Career Opportunities:
  Computer Operator | Data Entry Executive | Office Assistant | Junior Programmer | IT Support Staff