Course

MS-Office 

Free Typing Training (30 to 75 WPM)

Introduction to Computers

Windows

MS-Word

Internet

Power Point

Outlook Express

MS-Excel

 

MS-Access 

Advanced Excel with Power BI 

With Al Tools

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

Front End Web Develop.

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 - Contents from Course No. 38

Understanding LAN

Understanding Internet & E-Commerce

Multimedia -Audio & Video Recording / Editing / Mixing

Utilities like PC Tools, Virus & Anti-virus

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

Management

User / Group Management

Peripheral's Drivers, Applications Installations

User Data Management (Permissions and Logins)

Drivers Deployment and Identification

Hardware, OS, Application Troubleshooting

You can become a Multi-talented Operator, Web Designer & Programmer