Course

MODULE 1

Introduction to Computer

MS-Office 

Introduction to Computers

Windows

MS-Word

Internet

Power Point

Outlook Express

MS-Excel

MS-Access 

 

Advanced Excel with Power BI 

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 Account Tally 

Company Information

Creation - Stock with

Opening Balance

Stock information - Manufacturing Date

Batch No. Expiry Date

Accounting Voucher Entry

Purchase / Purchase Order Entry

Sales / Sales Order Entry

Discount- Cash Discount & Trade Discount

Bill Wise Details for Customer / Supplier

Voucher Class / Voucher Entry Type

Manufacturing Account

Accounting / Non-Accounting Voucher

Price Level Pos invoice

Price List Discount Scheme

Back and Restore

Budget Creation

Billing Term with Purchase / Sales Entry

Activate Interest Calculation

Enable Cheque Printing

Allow Multi Currency

Service Tax

Input Credit adjustment

Payroll - A

Payroll - B

Excise Duty

TDS Entry

TCS Entry

GST Entry

 

DTP (GRAPHIC DESIGNING)

Windows

Corel Draw

Photoshop

In Design

Adobe Illustrator

 

Front End Web Develop.

DOM & BOM Concepts

GSAP Animations

Scroll Trigger Effects

Portfolio & Real Projects

Deployment & Hosting

TOOLS COVERED

VS Code • React DevTools • GSAP • GitHub • Netlify • Chrome DevTools and many more

A - WEB DESIGNING

Fundamentals of Computers

Fundamentals of Internet & E-Commerce

Windows

HTML

DHTML

HTML5 / CSS3 / jQuery

Flash

JavaScript / Dream Weaver

Photoshop

PHP / Bootstrap

B - REACT.JS

React Introduction & Setup

JSX Syntax & Components

Functional Components

Props & State Management

useState Hook

Conditional Rendering

Lists & Keys

Event Handling

Forms & Validation

React Router Basics

Context API

Multi-Page Applications 

Hands on project

 

 

Programming Front End / Back End

C, C++ or VB or C# (Front-End Optional)

My SQL or SQL Server 2008 (Back-End Optional)

 

Linux Operating System

Understanding LAN

Understanding Internet & E-Commerce

Multimedia -Audio & Video Recording / Editing / Mixing

Utilities like PC Tools, Virus & Anti-virus

 

MODULE 2 & 3 (Hardware & Networking)

A – Desktop Hardware

Digital Electronics

Binary Numbers

Fundamental of Computer

Power Supply (SMPS)

Motherboard / Chipset

Processor (CPU)

Memory

BIOS

Hard Disk

Optical Peripherals

Other Peripherals

B – Operating System Administration

Deployment of Windows Client OS / Server OS / Linux OS

Repairing Windows Operating System

OS Hardening & OS Error Troubleshooting

Reinstallation of Operating System

User / Group Management

Installation of Applications

Hardware Management

Uninstallation of Applications

Drivers Deployment and identification

C- Management

User / Group Management

Peripheral's Drivers, Applications Installations

Hardware Management

User Data Management (Permissions and Logins)

Drivers Deployment and Identification

Hardware, OS, Application Troubleshooting

D- Fundamental Networking

Basics of Networking, Networking components, Types of Networks

Networking Hardware (Crimping, Croaning, Switching, Dressing)

Logical Networking (IP Addressing, Routing, Packet Transmission)

Networking Traffic Flow & Troubleshooting

You can become Master in Software, Hardware & Networking, Multi-talented Operator, Accountant, DTP, Web Designer & Programmer

 

ALSO JOIN

*KLiC ADVANCED EXCEL

*KLiC TALLY PRIME WITH GST

*KLiC ADVANCED TALLY PRO

*KLiC DTP (CORAL DRAW)

*KLiC DTP (ADOBE)

*KLiC PHOTOSHOP

*KLiC GRAPHIC DESIGNING

*KLiC CONTENT ILLUSTRATOR

*KLiC VIDEO EDITING

*KLiC WEB DESIGNING

*KLiC C PROGRAMMING

*KLiC C++ PROGRAMMING

*KLiC HARDWARE SUPPORT

*KLiC NETWORK SUPPORT

*KLiC SECURITY SUPPORT

*KLiC DESKTOP SUPPORT

AND GET YCMOU UNIVERSITY MARKSHEET & MKCL CERTIFICATE & DIPLOMA.