Welcome to Krishna computer classes

WELCOME TO Krishna computer classes  (KCC)

 
SHORT TERM COURSE IN ADVANCE EXCEL WITH AI ( KCC004 )

BASIC INFORMATION

  • Course Fees : 10000.00 12000.00/-
  • Course Duration : 3 MONTHS
  • Minimum Amount To Pay : Rs.500.00
  • ADVANCE EXCEL WITH FORMULAS
  • EXCEL APPLICATION SETTING
  • PASTE WITH CALCULATION
  • ADVANCE CUSTOM FORMATTING
  • EXCEL PROTECTION SYSTEM
  • DATA FILLING WITH FLASH FILL
  • DATA SORTING
  • FILTER & SELECTION CONCEPT
  • DATA ANALYZING WITH PIVOT
  • RECOGNIZED PIVOT TABLE
  • REPORTING WITH CHART
  • INSERT OTHER APPLICATION IN EXCEL SHEET
  • CONCEPT OF FORMULAS INSERTING
  • LOGICAL FORMULAS INSERTING
  • WORKING WITH DATA & TIME FORMULAS
  • DATA LOOKUP WITH VLOOKUP,HLOOKUP,MATCH
  • INDEX USING ARRAYS
  • MATHEMATICS CALCULATION
  • OFFSET,INDIRECT & INFORMATION FORMULAS
  • FINANCIAL FORMULAS
  • ARRAY FORMULAS
  • FORMULAS NESTING
  • FORMULAS TRICKS
  • DATA IMPORT OTHER DATA BASE 
  • DATA IMPORT ACCESS DATA BASE
  • DATA CONNECTION WITH SQL SERVER
  • DATA IMPORT FROM WEBS & FTP
  • DATA CLEAN ADVANCED FILTTER
  • VAILDATION AND WHAT -IF- ANALYSIS

MINIMUM 10TH