Course

MS-OFFICE

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

 

ADVANCED EXCEL

• Introduction to Advanced Excel
• Entering data and calculation
• Working with Rows and Columns,
• Cell References
• Filling Series / Custom List
• Conditional Formatting
• Maths and Trigonometry Function
• Statistical Function / Date & Time Function
• Logical Function / IF Function
• Data Validation Function
• V/H Lookup Function / Text Function / Index & Match
• Function with Condition, Sumifs, Countifs, Averageifs
• Financial Function
• Scenario, Goal Seek & Solver
• Database Function -D Get
• Sorting, Sub Totaling, Auditing, Macro & Consolidate
• Filtering of Data / Pivot Table and Chart
• Split / Hyperlink to Database Freeze
• Tracking Workbook Charge
• Protecting / Page Setup / MIS Report

 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

ADVANCED GRAPHIC DESIGN

• Corel Draw
• Photoshop
• In Design
• Adobe Illustrator
• Flash

Hands on Project Work

FREE TYPING TRAINING ...!!!

Artificial Intelligence (AI) Introduction & Tools

YOU CAN BECOME COMPUTER/ DATA ENTRY OPERATOR, ACCOUNTANT, GRAPHIC DESIGNER, RECEPTIONIST, COUNTER SALESMAN, OFFICE ASSISTANT.

 

ALSO JOIN

*KLiC ADVANCED EXCEL

*KLiC DTP

*KLiC DTP (ADOBE)

*KLiC PHOTOSHOP

*KLiC GRAPHIC DESIGNING

*KLiC CONTENT ILLUSTRATOR

*KLiC VIDEO EDITING

AND GET YCMOU UNIVERSITY MARKSHEET & MKCL CERTIFICATE.