We are offering Online & Offline and Corporate Training Courses. For more inform please contact us – 9619341713
Limited Offers
Empower Your Data Journey With Informatica Courses 100% Job Placement. | Learn Java Programming Language 100% Job Placement | Devops Certification Training 100% Job Placement

Basic Course

Basic Courses

Duration – 3 Months
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.
Introduction To Computer
    • Introduction
    • Objectives
    • What is Computer?
      1. History of Computers
      2. Characteristics Of Computer System
      3. Basic Applications of Computer
    • Components of Computer System
      1. Central Processing Unit
      2. Keyboard, mouse and VDU
      3. Other Input devices
      4. Other Output devices
      5. Computer Memory
    • Concept of Hardware and Software
      1. Hardware
      2. Software :
        • Application Software
        • Systems software
      3. Programming Languages
      4. Representation of Data/Information
      5. Concept of Data processing
      6. Applications of IECT :
        • e-governance
        • Multimedia and Entertainment
      7. Summary
      8. Model Questions and Answers
      9. Introduction to angular
Introduction To Gui Based Operating System
  • Introduction
  • Objectives
  • Basics of Operating System :
    1. Operating system
    2. 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
    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<br>
    • 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
  • Introduction
  • Objectives
  • Word Processing Basics
    1. Opening Word Processing Package
    2. Menu Bar
    3. Using The Help
    4. Using The Icons Below Menu Bar
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<br>
  • 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
Overview
  • 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
Overview
  • Excel Macros
  • Excel Terms
  • Macro Comments
  • Message Box
  • Input Box
  • Operations
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Concatenation Operators
  • Variable
  • Data Types
  • Decisions
  • If Else Statement
  • If Else – Else Statement
  • Switch Statement
  • Loops
  • For Loop
  • For Each Loops
  • Events
  • Worksheet Events
  • Workbook Events
  • How to copy a data from one sheet to another sheet
  • How to copy a data from another workbook to current workbook
  • How to apply filter on a data and copy it
  • How to format a cell
  • How to create a new sheet in a workbook
  • How to delete existing sheet in a workbook
  • How to rename sheet in a workbook
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
    1. Creation of Group
    2. Alteration of Group
    3. Display of Group
    4. Display of Group Account Book
  • b. Ledger
    1. Creation of Ledger
    2. Alteration of Ledger
    3. Display of Ledger
    4. Display of Ledger Account Book ( D + A + L)
  • c. Cost Category & Cost Centre
    1. Creation of Cost Category
    2. Creation of Cost Centre
    3. Alteration of Cost Centre
    4. Display of Cost Centre
    5. Display of Cost Centre wse Report ( D + S + C or D + S + O )
  • d. Budget
    1. Creation of Budget
    2. Alteration of Budget
    3. Budget Variance Report (D + T + (Alt + B))
  • e. Scenario
    1. Creation of Scenario
    2. Alteration of Scenario
    3. Scenario Report ((B or P) + (Alt + C))
  • f. Voucher Type
    1. Creation of Voucher
    2. Alteration of Voucher
2. Inventory Info
  • a. Stock Group
    1. Creation of Group
    2. Alteration of Group
    3. Display of Group
  • b. Stock Category
    1. Creation of Category
    2. Alteration of Category
    3. Display of Category
  • c. Tariff Classification
    1. Creation of Tariff
    2. Alteration of Tariff
    3. Display of Tariff
  • d. Stock Item
    1. Creation of Stock Item
    2. Alteration of Stock Item
    3. Display of Stock Item
  • e. Unit of Measurement
    1. Creation of Unit of Measurement
    2. Alteration of Unit of Measurement
    3. Display of Unit of Measurement
  • f. Godowns
    1. Creation of Godown
    2. Alteration of Godown
    3. Displayof Godown
  • g. Voucher Type
    1. Creation of Voucher
    2. Alteration of Voucher
    3. Display of Voucher
C] Transactions:
  • 1. Accounting Vouchers
    1. Voucher Date (F2)
    2. Change of Current Company (F3)
    3. Contra Voucher (F4)
    4. Payment Voucher (F5)
    5. Receipt Voucher (F6)
    6. Journal Voucher (F7)
    7. Sales Voucher (F8)
    8. Credit Note (F8)
    9. Purchase Voucher (F9)
    10. Debit Voucher (F9)
    11. Reversal Journal (F10)
    12. Memo Entry (F10)
    13. Post Dated (T)
    14. Optional (L)
  • 2. Inventory Vouchers
    1. Purchase Order
    2. Sales Order
    3. Stock Journal
    4. Physical Stock Verification
D] Import of Data
E] Reports
      1. Balance Sheet
      2. Profit &amp; Loss Account
      3. Stock Summary
      4. Ratio Analysis
5. Display
      1. Trail Balance
      2. Day Book
c. Accounts Book
      1. Cash & Bank Book
      2. Ledger
      3. Group Summary
      4. Group Vouchers
      5. Sales Register
      6. Purchase Register
      7. Journal Register
d. Statement of Accounts
      • i. Outstanding
        1. Receivables
        2. Payables
        3. Ledger
        4. Group
      • ii. Cost Centre
        1. Category Summary
        2. Cost Centre Breakup
        3. Ledger Breakup
        4. Group Breakup
      • iii. Statistics
        1. Inventory Books
        2. Statement of Inventory
        3. Statutory Info
        4. Statutory Report
        5. Cash & Fund Flow
        6. List of Accounts
        7. Exceptional Reports
6. Multi Accounting Printing
    1. Account Book
    2. Outstanding Statement
    3. Inventory Books
    4. Day Books
    5. Multi Voucher Printing
  • Accounting using Tally.ERP 91) Account Mastersii. Ledgers (Single / Multiple)
          • Create
          • Alter
          • Display
    ii. Ledgers (Single / Multiple)
          • Create
          • Alter
          • Display
          • Setting Credit Limits of Parties
    iii.Cost Categories (Single / Multiple)
          • Create
          • Alter
          • Display
    iv.Cost Centres (Single / Multiple)
          • Create
          • Alter
          • Display
    v. Budgets
          • Creation of Simple & Group Budgets
          • Alteration
    vii. Multiple Currencie
          • Creation of Simple & Group Budgets
          • Alteration
    viii. Voucher Types (Accounting)
          • Create
          • Alter
          • Display
    ix. Serial Numbers for Excise
        • Create
        • Alter
        • Display
  • 2) Accounting Vouchers (Creation, Alteration, Cancelation & Deletion)i. Purchase (As Voucher / As Invoice)
      • Recording Material Purchase (With or without VAT/CST)
      • Booking of Expenses (for TDS)
      • Entry for services received (for Service Tax)
      • Recording Material Purchase (Excisable for Dealers / Manufacturers)
    ii. Sales (As Voucher / As Invoice)
      • Sales of Goods (With or without VAT/CST)
      • Bill for Services (for Service Tax)
      • Recording Sales (Excisable for Dealers / Manufacturers)
      • POS – Point of Sale
    iii. Receipt (Single / Double Entry Mode)iv. Payment (Single / Double Entry Mode)
      • Cash / Bank Payments
      • Statutory Payments
        • VAT &amp; CST
        • TDS
        • Service Tax
        • Excise
        • Payroll (PF, EPS, ESI &amp; Admin Charges)
    v. Contra Entry (Single / Double Entry Mode)vi. Journals
      • Adjustment Entries for Accounts
      • TDS Deduction
      • Input Credit Adjustments
        1. VAT &amp; CST
        2. Service Tax
        3. Excise / CENVAT Adjustments
        4. Forex Gain/Loss Adjustment
    vii. Debit Note
      • Vouchers for Debiting Party Accounts
      • Interest Receivable
      • For Excise / CENVAT Adjustments
    viii. Credit Note
      • Vouchers for Crediting Party Accounts
      • Interest Payable
    ix. Memorandumx. Reversing Journal
  • 3) Accounting Reports
    • Cash / Bank Books
    • Ledger
    • Group Summary
    • Group Vouchers
    • Sales Register
    • POS Register
    • Purchase Register
    • Journal Register
    • Outstanding Receivable
    • Outstanding Payable
    • Ageing Analysis of Bills Receivable &amp; Payable
    • Interest Receivable
    • Interest Payable
    • Cost Center Category Summary
    • Cost Center wise Break-Up
    • Exceptional Reports
    • List of Account
    • Statistics
    • Ratio Analysis
    • Cash/Funds Flow Analysis
    • Trial Balance
    • Final Accounts
      1. Profit & Loss A/c
      2. Balance Sheet
  • 4) Other Accounting Features
    1. Cheque Printing
    2. Banck Reconciliation
  • VI Inventory management using Tally.ERP 9
    • 1) Mastersi. Stock Groups (Single / Multiple)
        1. Create
        2. Alter
        3. Display
      ii. Stock Category (Single / Multiple)
        1. Create
        2. Alter
        3. Display
      iii. VAT / Excise Commodities
        1. Create
        2. Alter
        3. Display
      iv. Unit of Measurement (Simple & Compound Units)
        1. Create
        2. Alter
        3. Display
      v. Stock Items (Single & Multiple)
        1. Create
        2. Alter
        3. Display
      vi. Godowns / Excise Units (Single & Multiple)
        1. Create
        2. Alter
        3. Display
      vii. Reorder Levelsviii. Voucher Types (Inventory)
        1. Create
        2. Alter
        3. Display
  • 2) Inventory Vouchers (Creation, Alteration, Cancelation & Deletion)
    • i. Order Vouchers
      1. Purchase Orders
      2. Sales Orders
    • ii. Vouchers for Goods Inward / Outward
      1. Receipt Note (Goods Receipt Note)
      2. Delivery Note (Delivery Challan)
      3. Goods Rejections In
      4. Goods Rejections Out
    • iii. Stock Journal
      1. Simple Stock Journal
      2. Inter Godown Transfer Class
      3. Manufacturing Journal (Linked to BOM)
      4. Class for Consumption (Excisable Goods)
      5. Class onsite Consumption (Job Costing)
      6. Physical Stock Verification Voucher
  • 3) Inventory Reports
    • i. Stock Summary
      1. Item Wise
      2. Group Wise
      3. Category Wise
      4. 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
      1. Purchase Date Wise
      2. Manufacturing Date Wise
      3. Expiry Date Wise
      4. 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
    • VAT – Value Added Tax
      1. VAT Computation
      2. VAT Forms
      3. E-VAT Forms
      4. Audit Forms
      5. VAT Register
    • CST – Central Sales Tax
      1. Forms Receivable
      2. Forms Issuable
      3. CST Return Form
      4. ECST Forms
      5. CST Register
    • Service Tax
      1. Service Tax Computation
      2. Service Tax Payables
      3. Input Credit
      4. ST3
      5. Exception Reports
    • TDS – Tax Deducted at Source
      1. Computation
      2. Challan Reconciliation
      3. Return
      4. E-Return
      5. TDS Outstanding
    • Excise for Manufacturer
      1. Excise Computation
      2. Daily Stock Register
      3. PLA Register
      4. PLA Summary
      5. Form ER 1
      6. Form ER 3
      7. Form ER 5
      8. Form ER 6
      9. Form ER 8
      10. CENVAT Registers
      11. E-Return
    • Excise for Dealers
      1. Excise Stock Register
      2. Excise Purchase Bill Register
      3. Party Wise Duty Extract
      4. Customs Clearance Register
      5. Sales And Purchase Extract
      6. Form RG 23D
      7. Form – 2
      8. E-Return
    • vii. Physical Stock Register
  • VIII Other Features
    • VAT – Value Added Tax
      1. Different Actual &amp;Billed
      2. Zero Valued Entries
      3. Additional Cost of Purchase
      4. Multiple Price Level &amp; Price List
      5. Aging Analysis
      6. Data Backup &amp; Restore
      7. Data Export &amp; Import
      8. Extending Accounting Period
      9. Splitting of Data
      10. Printing &amp;Rendering
      11. e-mail
      12. Data Upload to Website
      13. Tally Audit Feature
      14. Multi-Lingual Capabilities
      15. Tally.NET
    • Computer Typing (Marathi / Hindi / English)
    • Marathi Typing 30-40 Speed
    • Hindi Typing 30-40 Speed
    • English Typing 30-40-50 Speed

    Shorthand (Marathi / Hindi / English)
    • Marathi Typing (S/H) 60-80-100-120 Speed
    • Hindi Typing(S/H) 60-80-100-120 Speed
    • English Typing(S/H) 60-80-100-120 Speed

    Related Courses

    Fill the below form for Register

    Contact Form Demo

    Get The Coaching Training Today!

    For more information for courses contact us
    +91-9619341713

    We facilitate the best industry practices, theoretical and practical and intense training on real time scenario project, under the training of working professional of our most talented professional working faculty. 

    Important Links
    Airoli (Head Office)
    Branches
    Social Media
    Facebook Instagram Linkedin
    Copyright © 2023, S-IT Computer Education | All rights reserved.
    Designed by S-IT Computer

    You cannot copy content of this page