• icon7388682513
  • iconrctciitdudahi@gmail.com
  • iconMon -Sat: 7:00AM - 5:00PPM

Course

ADCA

Diploma in Com. App.

ADCA

Course Syllabus

  1. 1.HOME TAB(CLIPBOARD) PART ONE
  2.  2.HOME TAB(FONTS---TABLE) PART ONE
  3.  3.HOME TAB(FONT COLOR---ALIGNMENT) PART ONE (MS EXCEL)
  4.  4.HOME TAB(NUMBERS---STYLES) PART SECOND
  5.  5.HOME TAB(CELLS) PART SECOND
  6.  6.HOME TAB(EDITING=AUTOSUM) PART SECOND
  7.  7.HOME TAB(FILL---FIND _ SELECT) PART SECOND (MS EXCEL)
  8.  7.HOME TAB(FILL---FIND & SELECT) PART SECOND (MS EXCEL)
  9.  8.PAGE LAYOUT(THEMES---PAGE SETUP)
  10.  9.PAGE LAYOUT(SCALE TO FIT---ARRANGE)
  11.  10.INSERT TAB (PIVOT TABLE PART ONE) MS EXCEL
  12.  11.INSERT TAB(PIVOT TABLE PART TWO)MS EXCEL
  13.  12.INSERT TAB(TABLES---CHARTS) MS EXCEL (MS EXCEL)
  14.  13.INSERT TAB(SPARKLINES---HEADER _ FOOTER)
  15.  13.INSERT TAB(SPARKLINES---HEADER & FOOTER)
  16.  14.INSERT TAB(WORD ART---SYMBOLS)
  17.  15.FORMULAS TAB PART ONE(INSERT FUNCTION)
  18.  16.FORMULAS TAB PART ONE(AUTOSUM)
  19.  17.FORMULAS TAB PART ONE(RECENTLY USED---FINANCIAL PART ONE)
  20.  18.FORMULAS TAB PART ONE(FINANCIAL PART TWO)
  21.  19.FORMULAS TAB(LOGICAL) PART TWO
  22.  20.FORMULAS TAB(TEXT)PART TWO
  23.  21.FORMULAS TAB(DATE _ TIME)PART TWO
  24.  21.FORMULAS TAB(DATE & TIME)PART TWO
  25.  22.FORMULAS TAB(LOOK UP & REFERENCE)PART TWO
  26.  23.FORMULAS TAB(VLOOK UP+H LOOK UP+MATCH+LOOK UP) PART THIRD
  27.  24.FORMULAS TAB(INDEX+TRANSPOSE)PART THIRD
  28.  25.FORMULAS TAB(MATH _ TRIG.+MORE FUNCTIONS)PART THIRD
  29.  26.1FORMULAS TAB(DEFINED NAMES)PART THIRD
  30.  26.2FORMULAS TAB(FORMULA AUDITING+CALCULATION)PART THIRD
  31.  27.DATA TAB(GET EXTERNAL DATA) PART ONE
  32.  28.DATA TAB(CONNECTIONS) PART ONE
  33.  28.DATA TAB(SORT _ FILTER)PART ONE
  34.  28.DATA TAB(SORT & FILTER)PART ONE
  35.  29.DATA TAB(TEXT TO COLUNMS---DATA VALIDATION) PART ONE
  36.  30.DATA TAB(CONSOLIDATE---SCENARIO)PART TWO
  37.  31.DATA TAB(GOAL SEEK) PART TWO
  38.  32.DATA TAB(DATA TABLE)PART TWO
  39.  33.DATA TAB(OUTLINE)PART TWO
  40.  34.VIEW TAB(WORKBOOK VIEWS)MS EXCEL
  41.  35.VIEW TAB(SHOW---WINDOW)MS EXCEL
  42.  36.VIEW TAB(SAVE WORKSPACE---MACROS)MS EXCEL
  43.  37.REVIEW PROOFING TAB(SPELLING)
  44.  38.REVIEW PROOFING TAB(RESEARCH---COMMENTS)
  45.  39.REVIEW PROOFING TAB(PROTECTSHEET---PROTECTWORKBOOK)
  46.  40.REVIEW PROOFING TAB(SHAREWORKBOOK---TRACKCHANGES) (MS EXCEL)
  47.  41.FILE TAB IN MS EXCEL (MS EXCEL)


Duration: ADCA
(4 Reviews)
Offline : ₹999 Buy Online: ₹899
Apply Now

Explore Course Categories

Search Category, Courses and Blogs

Admission Query

Enter pricing title

Our pricing

Enter pricing description

DCA

DCA

DCA

  1.  Introduction to Computer
  2. Introduction to Internet and WWW
  3. E- mail, Social Networking & E- Governance Service
  4. Digital Financial Tools & Applications
  5. Overview Of Futureskills & Cyber Security
  6. Ms Office ( Word , Excel , Presentation )
  7. Introduction to GUI Based Operating System

Offline : ₹599 Online: ₹499
190+ Students Reviews
MS Excel

MS Excel

MS Excel

  1. Fundamental
  2.  Ms Office ( Word,Excel,PowerPoint )
  3.  Graphics Design ( Page Maker , Photoshop , Coreldraw )
  4. Typing Hindi & English
  5. Tally Prime ( Manual Accounting, Accounting Inventory,Voucher Payroll,GST )
  6. Web page Design through HTML
  7. Assembiling & Formatting
  8. Driver Installations ( Printer , VGA , Sound LAN Card etc )
  9.  Installation Operating System ( Dos, Windows , XP , Vista 7.8 , Linux )
  10.  Software Installation & Computer Security
  11. Operating System
  12. 

Offline : ₹599 Online: ₹499
190+ Students Reviews
ADCA

ADCA

ADCA

  1. 1.HOME TAB(CLIPBOARD) PART ONE
  2.  2.HOME TAB(FONTS---TABLE) PART ONE
  3.  3.HOME TAB(FONT COLOR---ALIGNMENT) PART ONE (MS EXCEL)
  4.  4.HOME TAB(NUMBERS---STYLES) PART SECOND
  5.  5.HOME TAB(CELLS) PART SECOND
  6.  6.HOME TAB(EDITING=AUTOSUM) PART SECOND
  7.  7.HOME TAB(FILL---FIND _ SELECT) PART SECOND (MS EXCEL)
  8.  7.HOME TAB(FILL---FIND & SELECT) PART SECOND (MS EXCEL)
  9.  8.PAGE LAYOUT(THEMES---PAGE SETUP)
  10.  9.PAGE LAYOUT(SCALE TO FIT---ARRANGE)
  11.  10.INSERT TAB (PIVOT TABLE PART ONE) MS EXCEL
  12.  11.INSERT TAB(PIVOT TABLE PART TWO)MS EXCEL
  13.  12.INSERT TAB(TABLES---CHARTS) MS EXCEL (MS EXCEL)
  14.  13.INSERT TAB(SPARKLINES---HEADER _ FOOTER)
  15.  13.INSERT TAB(SPARKLINES---HEADER & FOOTER)
  16.  14.INSERT TAB(WORD ART---SYMBOLS)
  17.  15.FORMULAS TAB PART ONE(INSERT FUNCTION)
  18.  16.FORMULAS TAB PART ONE(AUTOSUM)
  19.  17.FORMULAS TAB PART ONE(RECENTLY USED---FINANCIAL PART ONE)
  20.  18.FORMULAS TAB PART ONE(FINANCIAL PART TWO)
  21.  19.FORMULAS TAB(LOGICAL) PART TWO
  22.  20.FORMULAS TAB(TEXT)PART TWO
  23.  21.FORMULAS TAB(DATE _ TIME)PART TWO
  24.  21.FORMULAS TAB(DATE & TIME)PART TWO
  25.  22.FORMULAS TAB(LOOK UP & REFERENCE)PART TWO
  26.  23.FORMULAS TAB(VLOOK UP+H LOOK UP+MATCH+LOOK UP) PART THIRD
  27.  24.FORMULAS TAB(INDEX+TRANSPOSE)PART THIRD
  28.  25.FORMULAS TAB(MATH _ TRIG.+MORE FUNCTIONS)PART THIRD
  29.  26.1FORMULAS TAB(DEFINED NAMES)PART THIRD
  30.  26.2FORMULAS TAB(FORMULA AUDITING+CALCULATION)PART THIRD
  31.  27.DATA TAB(GET EXTERNAL DATA) PART ONE
  32.  28.DATA TAB(CONNECTIONS) PART ONE
  33.  28.DATA TAB(SORT _ FILTER)PART ONE
  34.  28.DATA TAB(SORT & FILTER)PART ONE
  35.  29.DATA TAB(TEXT TO COLUNMS---DATA VALIDATION) PART ONE
  36.  30.DATA TAB(CONSOLIDATE---SCENARIO)PART TWO
  37.  31.DATA TAB(GOAL SEEK) PART TWO
  38.  32.DATA TAB(DATA TABLE)PART TWO
  39.  33.DATA TAB(OUTLINE)PART TWO
  40.  34.VIEW TAB(WORKBOOK VIEWS)MS EXCEL
  41.  35.VIEW TAB(SHOW---WINDOW)MS EXCEL
  42.  36.VIEW TAB(SAVE WORKSPACE---MACROS)MS EXCEL
  43.  37.REVIEW PROOFING TAB(SPELLING)
  44.  38.REVIEW PROOFING TAB(RESEARCH---COMMENTS)
  45.  39.REVIEW PROOFING TAB(PROTECTSHEET---PROTECTWORKBOOK)
  46.  40.REVIEW PROOFING TAB(SHAREWORKBOOK---TRACKCHANGES) (MS EXCEL)
  47.  41.FILE TAB IN MS EXCEL (MS EXCEL)

Offline : ₹999 Online: ₹899
190+ Students Reviews