Course

DIPLOMA IN ADVANCED COMPUTER OPERATING


4 Months 6999 /-

Course Brief

COMPUTER OPERATING

  • Introduction
  • Windows
  • MS-Word
  • MS-Excel
  • MS-Powerpoint
  • MS-Access
  • MS-Outlook
  • Internet

ADVANCED EXCEL

  • Data Entering
  • Filtering/Calculation
  • Logical Functions
  • Page Settings
  • Data Validation
  • Text Functions
  • Scenarios,Goal Seek
  • Sparkline & Pivot
  • Protecting Sheet
  • Financial Functions/ MIS Report
  • Hlookup, Vlookup, etc

 

POWER BI

  • Data Ingestion (Connecting to Excel/Sql),
  • Transformation Using Power Query,
  • Data Modeling (Relationships, Star Schema),
  • DAX Calculations (Measures/Columns),
  • And Visualization (Charts, Dashboards, Reports)
  • Hands on Project Work

Artificial Intelligence (AI) Introduction & Tools

ALSO JOIN KLiC ADV EXCEL COURSE AND GET YCMOU UNIVERSITY MARKSHEET & MKCL CERTIFICATE.