Module1

Basic Concept of Computer

English Typing

Printing

Scanning

Ms Word

Font & Paragraph Formatting

Editing, Saving & Printing Text Documents

Inserting Table

Header & Footer

Smart Art

Page Breaks

Understanding Document Properties & Tabs

Mail Marge

Document Views & Macros

Saving & Protecting Sheets Documents

Project Work

Advance 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)

Project Work

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

and many more..

Module 2

Tally (Prime) with GST

Basic Concept of Accounting

Computrized Accounting

Ledger Posting

Multiple Ledger

All Voucher Entries

Accounting Features

Inventory Features

Balance Sheet

P & L Account

Multiple Price Level

Bank Reconciliation

Interest Calculation

Stock Summary

GST (IGST, CGST, SGST)

Knowledge of Taxation

Project Work

Interview Preparation

Job Skill Concepts

And Many More…