Basic Courses

  • Duaration - 3 Months

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 : a] Application Software b]Systems software
    3] Programming Languages
    4] Representation of Data/Information
    5] Concept of Data processing
    6] Applications of IECT : a] e-governance b] 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 : 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
  • 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
  • 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

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

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
    1. Balance Sheet
    2. Profit & Loss Account
    3. Stock Summary
    4. Ratio Analysis
    5. Display
    a. Trail Balance
    b. Day Book
    c. Accounts Book
    i. Cash & Bank Book
    ii. Ledger
    iii. Group Summary
    iv. Group Vouchers
    v. Sales Register
    vi. Purchase Register
    vii. 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
    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
    a. Account Book
    b. Outstanding Statement
    c. Inventory Books
    d. Day Books
    e. Multi Voucher Printing

  • 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
        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
    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

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

Get The Coaching Training Today!

For more information for courses contact us