ADCA (Advanced Diploma In Computer Applications) TRENDING

Download

Course Fee: ₹ 12,000

Duration: 12 Months

Monthly: ₹ 1000

(Note: Diploma Charges:– ₹ 500 Extra)

We offer ADCA course for those who want to pursue a career in computer/IT sector. It is a 12 months/2 semester, job-oriented course. In first semester, the students will learn Computer Applications and Advanced Excel. Second semester will be dedicated to Web Designing and Graphic Designing. After completing this course, students would be able to apply for various domains in computer/IT sector. We cover four modules in this course:-

Module 1: Computer Applications (3 Months)

Module 2: Advacned Excel (3 Months)

Module 3: Website Desiginig (3 Months)

Module 4: Graphic Designing (3 Months)

Career Opportunities:- Data Entry Operator, Office Assistant, Office Coordinator, Backend Executive, Data Analyst, MIS Executive, Financial Analyst, Website Designer, Front End Designer, Graphic Designer

Course Content:

3 Months ADCA
  • Computer Fundamentals
  • Notepad & WordPad
  • Paint
  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Internet & Web Browsing
  • Typing (30 Days)
  • Microsoft Outlook Mail Configuration
  • Microsoft DOS (CMD)
  • Introduction to Hardware & Software Installation
  • Online Exam and Certificate
3 Months ADCA
  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphsss
  • Analyzing data: Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae Formatting worksheets
  • Securing & Protecting spreadsheets
  • Logical Test- IF & Nested
  • SUM IF & SUM IFS
  • Not and if Error
  • Auditing Tools
  • Text Functions
  • Date Function
  • Name Range & Name Range with Formulas
  • Macros
  • Count Function & Statistical Function
  • Maths & Trigonometry
  • V-Lookup
  • H-Lookup
  • Lookup Function & Lookup Full Record
  • Index function
  • Match Function
  • Protect Cell, Sheet, File, Workbook
  • Hyperlink to sheet, File, Webpage, Update
  • Data Sorting
  • Advance Filters
  • Filtering Data
  • Advance Table
  • SUM IF & SUM IFS
  • Column Chart
  • XY Scatter Chart
  • Spark Line Chart
  • Pivot Chart (Table)
  • Pie Bar, Column & Line Chart
  • Pivot Table (Grouping, Slicer, Timeline)
  • Consolidation
  • Consolidation Extended
  • Conditional Formatting & Advance Conditional Formatting
  • Data Validation Error Alert
  • Dependent Dropdown List
  • Import Live Data from Web
  • Insert, Create Object
  • NPV
  • PMT, PPMT, IPMT
3 Months ADCA
  • Html5
  • CSS3
  • JavaScript
  • Photoshop (Basic)
3 Months ADCA
  • Photoshop
  • CorlDraw
  • Illustrator
  • InDesign

Other Courses: