Computer

Computer Operator

Basic Concept of Computer

English Typing

Hindi Typing

Data Entry

Printing and Scanning

and many more…

MS Word

Font & Paragraph Formatting

Editing, Saving & Printing Text Documents

Header & Footer

Smart Art

Page Breaks

Using List & Styles, Spelling & Grammar Check

Understanding Document Properties & Tabs

Mail Marge

Document Views & Macros

Saving & Protecting Sheets Document

Project Work

Adv. Excel

Introduction (Ms. Excel Window/Interface Parts, File Extension, How to Open/Exit.)

All Definitions ( Excel, Workbook, Worksheet, Cell, Row, Column)

Entering and Editing Data.

Inserting and Deleting Row or Column

Formatting Data

Auto fill Lists ( Default lists & Creating new lists)

Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)

Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis

Charts (Working With Charts)

Logical Functions (IF, AND, OR, NOT, IFERROR)

Financial Functions (PMT, PV, RATE, FV, DB)

Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)

Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)

Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)

MIS Report (PIVOT TABLE, PIVOT CHART, V LOOKUP, HLOOKUP, ADV. FILTER, SLICER, SPARKLINES, CONSOLIDATE, CONVERT, ABS, SUMPRODUCT, FIND DUPLICATE, TEXT)

Project Work

and many more…

MS PowerPoint

Creating & Printing Slides

Adding Custom Animation

Using Slide Transitions

Using Charts, Graphs & Photo Album

Creating Professional Presentation

Project Work

Internet

Introduction to Internet

Browser Basics

Downloading, Searching, Surfing and Storing Data

Online Forms Submission

Online Bill Payment

Online Ticket Booking