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

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

 Computer Fundaments
 Formatting
Operating System Installation
Windows 7,8,10
 Software Installation
Driver Installation
Printer Installation
 Data Backup & Recovery
 Graphics Software installation
AutoCAD, Photoshop, Corel Draw
 Password Recovery
Laptop, Desktop
 Software Downloading
 Software Cracking
 Password Cracking
 Bootable Pen Drive
 Pen Drive Protection
 Troubleshooting
 Problem Finding
 Internet Sharing
 Networking
 Wi-Fi Configuration
 Wi-Fi Password Setting
 Printer & Files Sharing
 Final Training
 Tests & Exams
 Field Work

The course is designed to aim at imparting a basic level appreciation programme for the common man. After completing the course the incumbent is able to the use the computer for basic purposes of preparing his personnel/business letters, viewing information on Internet (the web), sending mails, using internet banking services etc. This allows a common man or housewife to be also a part of computer users list by making them digitally literate. This would also aid the PC penetration program. This helps the small business communities, housewives to maintain their small account using the computers and enjoy in the world of Information Technology.

Introduction of Computer
Definition, History, Parts Introduction.
 Typing Master
English Typing Practice
 Microsoft Paint
Basic Drawing, Painting, Designing, Cartoons
 Microsoft Notepad
Text Writing, Notes Making, Typing
 Microsoft Office
Microsoft Word
Letter, Application, Documents, Designs, Resume, Report,
Invoice & Bills
Microsoft Excel
Calculations, Report, Mark sheet, Invoice & Bills, Data
Entry, Formula, Function
Microsoft Power Point
Audio, Video, Picture, Graphics, Animation, Colour,
Shapes, Presentations, Designs, Slides
 Internet
Searching, Downloading (Songs, Video, Movies,
Documents), Form Filling (School, College, Job), Email id,
Online Shopping, Ticket Booking (Train, Bus, Flight,
Movie), Money Transfer.
 Computer Tips & Tricks
Shortcuts, Folder Making, Deleting, Hiding, Wallpaper
Setting, Date Time, Copy Paste, Pen Drive, Printout,

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: 

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.

Introduction to Digital Marketing    
SEO
Social Media Marketing    
Email Marketing
Content Marketing & Copywriting    
Affiliate Marketing
AdWords & PPC    
Google Analytics

• Business environment
• Management
• Marketing
• Financial management
• Business ethics
• Corporate social responsibility

Description: 

The full form of DCAP is a Diploma in Computer Application & Programming. 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 10th 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 & E-commerce 
• MS Office( World, Excel, Power Point)
• Tally ERP 9.0
• Web Designing

This is a 6 month vocational certificate for biginers to take basic knowledge of computer.

This is a Basic diploma for beginners to get computer introduction 

Advance Diploma in Computer Application & Programming is a one year advance Diploma for 10+2 students.

Bachelor of Computer Applications (BCA)

Duration: 3 Years (6 Semesters)
Eligibility: 10+2 with Math stream )
Medium of Instruction: English/Hindi (as per university norms)

Course Overview:
The Bachelor of Computer Applications (BCA) is a 3-year undergraduate degree designed to provide students with a solid foundation in computer science and its applications. It equips students with essential programming skills, software development knowledge, and understanding of networking, database management, and web technologies.

Key Subjects Covered:

Programming Languages (C, C++, Java, Python)

Data Structures and Algorithms

Database Management Systems (DBMS)

Operating Systems

Computer Networks

Web Development (HTML, CSS, JavaScript, PHP)

Software Engineering

Cloud Computing & Cyber Security (optional/specializations)

Project Work and Internship (Final Year)

Why Choose BCA at C.E.S Institute of Professional Studies?

Industry-oriented curriculum

Experienced faculty

Hands-on projects and lab sessions

Free laptop for enrolled students

Affordable fees structure (₹16,500 per year)

Internship & placement support

Career counseling and skill development workshops

Career Opportunities:

Software Developer

Web Designer

System Analyst

Network Administrator

Data Analyst

IT Support Specialist

Mobile App Developer

Further Studies:
After BCA, students can pursue MCA, MBA (IT), MSc (CS), or other specialized IT certifications to enhance their career scope.

B.Sc (Computer Science)

Duration: 3 Years (6 Semesters)
Eligibility: 10+2 with Mathematics (or as per university norms)
Medium of Instruction: English/Hindi

Course Overview:
The Bachelor of Science in Computer Science (B.Sc CS) is a 3-year undergraduate program designed to provide in-depth knowledge of computer systems, programming, and computational theory. The course blends theoretical concepts with practical experience, preparing students for careers in technology, research, or further studies in the field.

Key Subjects Covered:

Programming Languages (C, C++, Python, Java)

Data Structures and Algorithms

Operating Systems

Computer Networks

Database Management Systems (DBMS)

Digital Electronics

Web Technologies

Computer Architecture

Software Engineering

Artificial Intelligence & Machine Learning (electives)

Final Year Project / Internship

Why Choose B.Sc (CS) at C.E.S Institute of Professional Studies?

Strong academic foundation with hands-on training

Affordable fee structure

Modern computer lab and technical infrastructure

Experienced and supportive faculty

Internship and placement support

Career-focused workshops and seminars

Career Opportunities:

Software Developer

Data Analyst

Network Engineer

System Administrator

IT Consultant

Technical Support Engineer

Further study options: M.Sc (CS), MCA, MBA (IT), etc.

 Master Accounts, Unlock Careers! Join DFA 

 Diploma in Financial Accounting and gain practical skills in Tally, Excel & GST.

 6 Months | Job-Ready Skills | 10th Pass Eligible

✅ DFA Syllabus Includes:-

Fundamentals of Computer

Operating System

MS Office (Word, Excel, PowerPoint)

Advanced Excel

Tally ERP with GST & Advanced Financial Accounting

Basic computer certificate 

Typing 

Fundamental knowledge