Description: 

The full form of DCA is a Diploma in Computer Application. It is a one-year computer-based diploma or course. The course is intended to provide learners with basic, realistic and technological details pertaining to programming tools and applications which are used in our everyday lives. An intermediate or 12th class in any stream from a recognized board or university is the required qualification needed for this program

• Basic internet concepts
• Computer Fundamentals
• Introduction to programming
• Programming in C
• RDBMS & Data Management
• Multimedia
• Corel draw
• Tally ERP 9.0
• Photoshop

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