Welcome to Krishna computer classes

WELCOME TO Krishna computer classes  (KCC)

 
SHORT TERM COURSE IN ADVANCE EXCEL WITH MIS ( KCC003 )

BASIC INFORMATION

  • 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

10TH