S-IT Computer-Institute for Big Data, SAS, Oracle, Informatica, Java, PHP, .Net in Airoli, Navi Mumbai, Juinagar,Turbhe ,Kopar Khairane ,Ghansoli ,Rabale ,Thane

Overview

It is a process, not an event. It is the process of using data to understand too many different things, to understand the world. Let Suppose when you have a model or proposed explanation of a problem, and you try to validate that proposed explanation or model with your data.

CCC (Central Govt.Course)

Introduction To Computer

Introduction
Objectives
What is Computer?

Components of Computer System

Concept of Hardware and Software

Software :

Applications of IECT :

Introduction To Gui Based Operating System

Introduction
Objectives
Basics of Operating System : a] Operating system b] Basics of popular operating system (LINUX, WINDOWS)

The User Interface

Task Bar
Icons
Start Menu
Running an Application

Operating System Simple Setting

Changing System Date And Time
Changing Display Properties
To Add Or Remove A Windows Component
Changing Mouse Properties
Adding and removing Printers
File and Directory Management
Types of files
Summary
Model Questions and Answers

Elements Of Word Processing

Introduction
Objectives
Word Processing Basics

Opening and closing Documents

Opening Documents
Save and Save as
Page Setup
Print Preview
Printing of Documents

Text Creation and manipulation

Document Creation
Editing Text
Text Selection
Cut, Copy and Paste
Font and Size selection
Alignment of Text

Formatting the Text

Paragraph Indenting
Bullets and Numbering
Changing case

Table Manipulation

Draw Table
Changing cell width and height
Alignment of Text in cell
Delete / Insertion of row and column
Border and shading
Summary
Model Questions and Answers

Spread Sheet

Introduction
Objectives
Elements of Electronic Spread Sheet
1] Opening of Spread Sheet
2] Addressing of Cells
3] Printing of Spread Sheet
4] Saving Workbooks
Manipulation of Cells
1] Entering Text, Numbers and Dates
2] Creating Text, Number and Date Series
3] Editing Worksheet Data
4] Inserting and Deleting Rows, Column
5] Changing Cell Height and Width
Function and Charts
1] Using Formulas
2] Function
3] Charts
Summary
Model Questions and Answers

Computer Communication And Internet

Introduction
Objectives
Basics of Computer Networks
1] Local Area Network (LAN)
2] Wide Area Network (WAN)
Internet
1] Concept of Internet
2] Basics of Internet Architecture
Services on Internet
1] World Wide Web and Websites
2] Communication on Internet
3] Internet Services
Preparing Computer for Internet Access
1] ISPs and examples (Broadband/Dialup/WiFi)
2] Internet Access Techniques
Summary
Model Questions and Answers

Communication And Collaboration

Introduction
Objectives
Basics of E-mail
1] What is an Electronic Mail
2] Email Addressing
3] Configuring Email Client
Using E-mails
1] Opening Email Client
2] Mailbox: Inbox and Outbox
3] Creating and Sending a new E-mail
4] Replying to an E-mail message
5] Forwarding an E-mail message
6] Sorting and Searching emails
Advance email features
1] Sending document by E-mail
2] Activating Spell checking
3] Using Address book
4] Sending Softcopy as attachment
5] Handling SPAM
Instant Messaging and Collaboration
1] Using Smiley
2] Internet etiquettes
3] Summary
Summary
Model Questions and Answers

Making Small Presentations

Introduction
Objectives
Using PowerPoint
1] Opening A PowerPoint Presentation
2] Saving A Presentation
Creation of Presentation
1] Creating a Presentation Using a Template
2] Creating a Blank Presentation
3] Entering and Editing Text
4] Inserting And Deleting Slides in a Presentation
Preparation of Slides
1] Inserting Word Table or An Excel Worksheet
2] Adding Clip Art Pictures
3] Inserting Other Objects
4] Resizing and Scaling an Object
Providing Aesthetics
1] Enhancing Text Presentation
2] Working with Color and Line Style
3] Adding Movie and Sound
4] Adding Headers and Footers
Presentation of Slides 1] Viewing A Presentation
2] Choosing a Set Up for Presentation
3] Printing Slides And Handouts
Slide Show 1] Running a Slide Show
2] Transition and Slide Timings
3] Automating a Slide Show
Summary
Model Questions and Answers

Advance excel with VBA programming

Advanced Excel

Pivot
Basic Excel
Sum
Count
Vlookup
Index+Match
Vlookup+Match
Hlookup
Concatenate
Text To Column
Freeze Unfreeze
Macro
True Or False/If/Match
(What If Analysis?)Scenario Summary/Goal Seek
Dublicate Count
Advance Filter
or
Data validation
Replace, Repeat, Exact
Proper
Substitue
Trunc
Condtional formating With New rule
Type error
Convert
Address
Trim
Forcast
Mina & Maxa
pivot table
1] Create pivot table
2] Use Pivot Table Option And slicer
3] Change & Update Range
4] Formatting Pivot & Making dynamic pivot chart
Pivot chart
1] Create Chart
2] Type of pivot chart
3] Formatting pivot chart & making dynamic pivot chart
Averageif & Averageifs
Networkdays & Network Day int.

VBA Training Syllabus

VBA Topic

Object-orientated programming
Working across applications
File System Objects
Using built-in file dialog boxes
Macr
security
Protecting applications
ActiveX controls
Class modules
Good programming techniques
Customizing menus and toolbars
VBA Editor
Debugging
Handling errors
Recording macros
Running macros
Customizing menus and toolbars
Writing macros
Selecting cells and ranges
Variables
Subroutines, arguments and functions
Loops and logic
Debugging
Handling errors
Event-handling
The Visual Basic rabbit-hole
Looping over collections
Creating forms
Using forms

Advanced form controls

Programming menus and toolbars
Working across applications
Crib sheet

MIS Reporting

Method of : -
Monthly , Weekly , Daily Quarterly Report
Variance Report
Compare Report
Sales Report
Sales Report Analyzing

Diploma in Business Accounting and Taxation

Tally Prime

A] Company Masters:

Creation of Company
Alteration of Company
Shut of Company
Tally Vault Password

B] Accounts & Inventory Masters:

1. Accounts Info

a. Group
i. Creation of Group
ii. Alteration of Group
iii. Display of Group
iv. Display of Group Account Book

b. Ledger
i. Creation of Ledger
ii. Alteration of Ledger
iii. Display of Ledger
iv. Display of Ledger Account Book ( D + A + L)

c. Cost Category & Cost Centre
i. Creation of Cost Category
ii. Creation of Cost Centre
iii. Alteration of Cost Centre
iv. Display of Cost Centre
v. Display of Cost Centre wise Report ( D + S + C or D + S + O )

d. Budget
i. Creation of Budget
ii. Alteration of Budget
iii. Budget Variance Report (D + T + (Alt + B))

e. Scenario
i. Creation of Scenario
ii. Alteration of Scenario
iii. Scenario Report ((B or P) + (Alt + C))

f. Voucher Type
i. Creation of Voucher
ii. Alteration of Voucher

2. Inventory Info

a. Stock Group
i. Creation of Group
ii. Alteration of Group
iii. Display of Group

b. Stock Category
i. Creation of Category
ii. Alteration of Category
iii. Display of Category

c. Tariff Classification
i. Creation of Tariff
ii. Alteration of Tariff
iii. Display of Tariff

d. Stock Item
i. Creation of Stock Item
ii. Alteration of Stock Item
iii. Display of Stock Item

e. Unit of Measurement
i. Creation of Unit of Measurement
ii. Alteration of Unit of Measurement
iii. Display of Unit of Measurement

f. Godowns
i. Creation of Godown
ii. Alteration of Godown
iii. Displayof Godown

g. Voucher Type
i. Creation of Voucher
ii. Alteration of Voucher
iii. Display of Voucher

C] Transactions:

1. Accounting Vouchers
a. Voucher Date (F2)
b. Change of Current Company (F3)
c. Contra Voucher (F4)
d. Payment Voucher (F5)
e. Receipt Voucher (F6)
f. Journal Voucher (F7)
g. Sales Voucher (F8)
h. Credit Note (F8)
i. Purchase Voucher (F9)
j. Debit Voucher (F9)
k. Reversal Journal (F10)
l. Memo Entry (F10)
m. Post Dated (T)
n. Optional (L)

2. Inventory Vouchers
a. Purchase Order
b. Sales Order
c. Stock Journal
d. Physical Stock Verification

D] Import of Data

E] Reports

5. Display

a. Trail Balance

b. Day Book

c. Accounts Book

d. Statement of Accounts

i. Outstanding

ii. Cost Centre

e. Inventory Books

f. Statement of Inventory

g. Statutory Info

h. Statutory Report

i. Cash & Fund Flow

j. List of Accounts

k. Exceptional Reports

6. Multi Accounting Printing

Taxtion

Basic Accounting

Handling Multiple Company
1) Company Creation
2) Company Alteration / Deletion
3) Tally Vault and Administrator Password

F11: Features (Company Specific)
1) Accounting Features
2) Inventory Features
3) Statutory & Taxation
4) Tally.NET Features
5) Add-On Features

F12: Configurations (User / Program Specific)
1) General
2) Numeric Symbols
3) Accounts / Inventory Info.
4) Voucher Entry
5) Invoice / Orders Entry
6) Payroll Configuration
7) Banking Configuration
8) Printing
9) E-Mailing
10) Data Configuration
11) Advanced Configuration
12) Message Center
13) Product & Features
14) Licensing

Accounting using Tally.ERP 9
1) Account Masters
i. Groups (Single / Multiple)
a) Create
b) Alter
c) Display
ii. Ledgers (Single / Multiple)
a) Create
b) Alter
c) Display
d) Setting Credit Limits of Parties
iii.Cost Categories (Single / Multiple)
a) Create
b) Alter
c) Display
iv.Cost Centres (Single / Multiple)
a) Create
b) Alter
c) Display
v. Budgets
a) Creation of Simple & Group Budgets
b) Alteration
vi.Scenarios
a) Creation
b) Alteration
vii. Multiple Currencies
a) Create
b) Alter
c) Exchange Rates based on Base Currency
viii. Voucher Types (Accounting)
a) Create
b) Alter
c) Display
ix. Serial Numbers for Excise
a) Create
b) Alter
c) Display

2) Accounting Vouchers (Creation, Alteration, Cancelation & Deletion)
i. Purchase (As Voucher / As Invoice)
a) Recording Material Purchase (With or without VAT/CST)
b) Booking of Expenses (for TDS)
c) Entry for services received (for Service Tax)
d) Recording Material Purchase (Excisable for Dealers / Manufacturers)
ii. Sales (As Voucher / As Invoice)
a) Sales of Goods (With or without VAT/CST)
b) Bill for Services (for Service Tax)
c) Recording Sales (Excisable for Dealers / Manufacturers)
d) POS - Point of Sale
iii. Receipt (Single / Double Entry Mode)
iv. Payment (Single / Double Entry Mode)
a) Cash / Bank Payments
b) Statutory Payments
i) VAT & CST
ii) TDS
iii) Service Tax
iv) Excise
v) Payroll (PF, EPS, ESI & Admin Charges)
v. Contra Entry (Single / Double Entry Mode)
vi. Journals
a) Adjustment Entries for Accounts
b) TDS Deduction
c) Input Credit Adjustments
i) VAT & CST
ii) Service Tax
iii) Excise / CENVAT Adjustments
iv) Forex Gain/Loss Adjustment
vii. Debit Note
a) Vouchers for Debiting Party Accounts
b) Interest Receivable
c) For Excise / CENVAT Adjustments
viii. Credit Note
a) Vouchers for Crediting Party Accounts
b) Interest Payable
ix. Memorandum
x. Reversing Journal

3) Accounting Reports
i. Cash / Bank Books
ii. Ledger
iii. Group Summary
iv. Group Vouchers
v.Sales Register
vi. POS Register
vii. Purchase Register
viii. Journal Register
ix. Outstanding Receivable
x. Outstanding Payable
xi. Ageing Analysis of Bills Receivable & Payable
xii. Interest Receivable
xiii. Interest Payable
xiv. Cost Center Category Summary
xv. Cost Center wise Break-Up
xvi. Exceptional Reports
xvii. List of Account
xviii.Statistics
xix. Ratio Analysis
xx. Cash/Funds Flow Analysis
xxi. Trial Balance
xxii. Final Accounts
a) Profit & Loss A/c
b) Balance Sheet

4) Other Accounting Features
i. Cheque Printing
ii. Banck Reconciliation

VI Inventory management using Tally.ERP 9

1) Masters
i. Stock Groups (Single / Multiple)
a) Create
b) Alter
c) Display
ii. Stock Category (Single / Multiple)
a) Create
b) Alter
c) Display
iii. VAT / Excise Commodities
a) Create
b) Alter
c) Display
iv. Unit of Measurement (Simple & Compound Units.)
a) Create
b) Alter
c) Display
v. Stock Items (Single & Multiple)
a) Create
b) Alter
c) Display
vi. Godowns / Excise Units (Single & Multiple)
a) Create
b) Alter
c) Display
vii. Reorder Levels
viii. Voucher Types (Inventory)
a) Create
b) Alter
c) Display

2) Inventory Vouchers (Creation, Alteration, Cancelation & Deletion)
i. Order Vouchers
a) Purchase Orders
b) Sales Orders
ii. Vouchers for Goods Inward / Outward
a) Receipt Note (Goods Receipt Note)
b) Delivery Note (Delivery Challan)
c) Goods Rejections In
d) Goods Rejections Out
iii. Stock Journal
a) Simple Stock Journal
b) Inter Godown Transfer Class
c) Manufacturing Journal (Linked to BOM)
d) Class for Consumption (Excisable Goods)
e) Class onsite Consumption (Job Costing)
f) Physical Stock Verification Voucher

3) Inventory Reports
i. Stock Summary
a) Item Wise
b) Group Wise
c) Category Wise
d) Godown Wise
ii.Sales Order Book
iii. Sales Order Analysis
iv. Purchase Order Book
v. Purchase Order Analysis
vi. Stock Transfer
vii. Physical Stock Register
viii. Movement Analysis
ix. Batch Wise Analysis
x. Ageing Analysis
a)Purchase Date Wise
b)Manufacturing Date Wise
c)Expiry Date Wise
d)To be Expired
xi. Stock Query
xii. Cost Estimate of Goods Produced
xiii. Job Work Analysis
xiv. Reorder Status
xv. Purchase Bills Pending (Purchases Against GRN)
xvi. Sales Bills Pending (Sales Against Challan)

VII Statutory Reports
1)  VAT - Value Added Tax
i.VAT Computation
ii. VAT Forms
iii. E-VAT Forms
iv. Audit Forms
v. VAT Register
2)  CST - Central Sales Tax
i.Forms Receivable
ii. Forms Issuable
iii. CST Return Form
iv. ECST Forms
v.  CST Register
3)  Service Tax
i.Service Tax Computation
ii. Service Tax Payables
iii. Input Credit
iv. ST3
v. Exception Reports
4)  TDS - Tax Deducted at Source
i.Computation
ii. Challan Reconciliation
iii. Return
iv. E-Return
v. TDS Outstanding
5)  Excise for Manufacturer
i.Excise Computation
ii. Daily Stock Register
iii. PLA Register
iv. PLA Summary
v.  Form ER 1
vi. Form ER 3
vii. Form ER 5
viii. Form ER 6
ix. Form ER 8
x. CENVAT Registers
xi. E-Return
6) Excise for Dealers
i. Excise Stock Register
ii. Excise Purchase Bill Register
iii. Party Wise Duty Extract
iv. Customs Clearance Register
v. Sales And Purchase Extract
vi. Form RG 23D
vii.Form - 2
viii. E-Return

VIII   Other Features
1)  Different Actual &Billed
2)  Zero Valued Entries
3)  Additional Cost of Purchase
4)  Multiple Price Level & Price List
5)  Aging Analysis
6)  Data Backup & Restore
7)  Data Export & Import
8)  Extending Accounting Period
9)  Splitting of Data
10) Printing &Rendering
11) e-mail
12) Data Upload to Website
13) Tally Audit Feature
14) Multi-Lingual Capabilities
15) Tally.NET