Popular Courses

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.

MS Excel – 3 Months Professional Course

Course Overview:

This course provides practical training in Microsoft Excel for office work, data entry, calculations, formatting, basic data analysis, and report preparation. Students will learn essential Excel formulas, functions, charts, and practical office tasks through real-life assignments.

Course Syllabus:

1. Excel Fundamentals

• Introduction to MS Excel, Workbooks and Worksheets

• Rows, Columns, Cells and Cell References

• Data Entry, Editing and Formatting

• Number Formatting, Borders, Alignment and Cell Styles

• Copy, Paste, Find & Replace

• Sorting, Filtering and Excel Tables

• Essential Keyboard Shortcuts

2. Basic Formulas & Functions

• SUM, AVERAGE, MIN, MAX

• COUNT, COUNTA and COUNTBLANK

• Basic Mathematical Calculations

• Relative, Absolute and Mixed Cell References

• IF, AND and OR Functions

• Basic Date & Time Functions

• Basic Text Functions

3. Conditional Formulas & Lookup

• SUMIF and SUMIFS

• COUNTIF and COUNTIFS

• IFERROR

• VLOOKUP and HLOOKUP

• Basic INDEX and MATCH

• LEFT, RIGHT, MID, LEN, TRIM and CONCAT

4. Data Management

• Conditional Formatting

• Data Validation and Drop-down Lists

• Remove Duplicates

• Text to Columns

• Freeze Panes

• Page Layout, Print Settings and PDF Export

5. Charts & Basic Reporting

• Column, Bar, Line and Pie Charts

• Chart Formatting and Labels

• Basic Data Analysis

• Introduction to Pivot Tables and Pivot Charts

• Professional Report Formatting

6. Practical Office Projects

• Student Marksheet and Result Sheet

• Employee Attendance Sheet

• Salary Calculation Sheet

• Sales Report

• GST Invoice and Billing Sheet

• Monthly Income & Expense Report

• Data Entry and Record Management Project

Training Features:

• Step-by-Step Practical Training

• Real-Life Excel Assignments

• Weekly Practical Tests

• Office-Based Exercises

• Final Practical Project

• Certificate After Successful Completion

Career-Oriented Skills:

This course helps students develop essential Excel skills for data entry, office administration, billing, record management, and basic reporting tasks.

Course Duration: 3 Months

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