Microsoft Excel Advance Features
 Menu Bars
o Formula
o Data
o Review
o View
 Project & Assignments
o GST Invoice & Bills
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

Introduction
Basic Patterns
Wishing & Self Introduction
 Basic Grammar
Tense
Present, Past, Future
Modals
Can, May, Should, Want, Need, Must, Like, Going to
WH Types
What, Where, When, Why, Which, Who, How
 Vocabulary
Verbs, Word Meanings, Body Parts, Days & Months Name
 Activities
Whishing
Hand shaking
Self-Introduction
News & Quotes Telling
Story writing & Telling
Song Translations
Group Discussion
 Presentation Skills
Topic Wise
Non Stop Speaking
 Personality Development
Communication Skills
Confidence Building
Public Speaking
Dressing Sense
Time Management
Money Management
Stress & Anger Management
 Interview Skills

The syllabus of the Advance Diploma in Computer Application has various subjects such as Forms, databases, Photo editing software, Design Process, etc. The ADCA courses cover a wide range of topics and are divided into two semesters. This is a flexible course that aims to ensure that the students gain access to all the information they need. The semester-by-semester ADCA subject list is listed below:

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

1. COMPUTER INTRODUCTION

2.PARTS KNOWLEDGE

3.PAINT

4.NOTEPAD

5.WORDPAD

6.INTERNAT USES

7.SHORTKEY

8.TYPING

1.SSC MTS

2.SSC CGL

3.SSC CPO

4.SSC CHSL

5.SSC GD

6.SSC DELHI POLICE

1.CET

2.HARYANA POLICE

3.GROUP C

4.GROUP D

1.ARMY GD

2.ARMY CLERCK

3.ARMY TECHNICAL

4.ARMY TRADEMAN

5.NAVY X&Y

6.AIRFORCE X&Y

1.STENO HINDI

2.STENO ENGLISH

1.BA

2.10TH &12TH

3.B.COM

4.BCA

5.MBA

6.B.ED

7.MSC

8.DIPLOMA

9.B,LIB

10.BA-llb

11.llb