Wix Code:
 
1/12

ADVANCE COURSE IN COMPUTER & TALLY

 

BASIC COMPUTER

 

  • Introduction to Computer

  • English Typing

    • Golden rules for using the keyboard in the right way

    • A – Z Line typing

    • Words, Letters & Sentence

    • Using typing software

  • MS Word

    • Letter, Resume & Application writing

    • Creating Invoice & Purchase Order Template

    • Topic & Sub Topics using bullet & numbers

    • Creating Various types of Tables

    • Using shapes for creating design

    • Creating Various types of Smart Art

    • Charts & Hyperlinks

    • Header & footer

    • Watermark, Page Color, Page Border

    • Table of contents

    • Footnote, Citation & Caption

    • Index & Mail Merge

    • Printing documents & file menu.

    • Creating PDF

    • Enabling Autosave

    • Managing Multiple Version files

    • Creating Macros

  • MS Excel

    • Doing various practicals on

      • Mark Sheet & Attendance Sheet

      • Scenario Managers & Goal Seek

      • Calculation of Bonus on Salary & Product delivered

      • Using Sum if & Sum ifs

      • Vlookup & Hlookup

      • Using Slicer & Sparklines

      • Text & Date Functions

      • Sub Totals & DSum 

      • Text Functions

      • Remove Duplicate

      • Date & Text Functions

      • Creating Pivot Tables

      • Using Consolidate function

      • Data Validation

      • Graphs

  • MS PowerPoint

    • Creating & modifying the presentation

    • Using various themes

    • Downloading various themes

    • Various design

    • Setting up a Slide show

    • Converting PPT to Videos

  • MS Outlook

    • Creating email id

    • Changing email server settings

    • Using various functions of Outlook

  • MS Publisher

    • Creating

      • Forms

      •  Visiting Cards

      • Certificates

TALLY

  • Basic Terminology of Accounting

    • Doing Journal entries using Golden Rules of Accounts

  • Downloading & Installing Tally

  • Creating Company, Doing Alteration, Deletion & Securing

  • Data Backup & Restore

  • Understanding Pre Defined Groups & Ledgers

  • Various types of voucher entries on :

    • Purchase

    • Sales

    • Payment

    • Receipts

    • Contra

    • J.V.

    • Memo

    • Post Dated

    • Optional Vouchers  / Creating Quotation

  • Debit & Credit Notes

  • Purchase Order & Receipt Note

  • Sales Order & Delivery Note

  • Reverse Charge Mechanism

  • Working with payroll

  • Voucher class

  • Bill of materials. (Manufacturing process)

  • Using Price List for multiple buyers

  • Cost Centre & Cost Organization

  • TCS

  • Banking

  • Bank Reconciliation Auto

  • Bank Reconciliation Manual

  • Setting up cheque information & Cheque printing

  • TDS

  • Enabling TDS in tally

  • Creating ledgers

  • Creating vouchers

  • TDS Reports & Challan printing

  • Reports on :

  • Trial Balance

  • Trading Account

  • Profit & Loss Account

  • Balance sheet

  • Stock Summary

  • Statutory Reports

  • Stock & Inventory

  • Creating Stock items

  • Unit of Measures & Stock Group

  • Sale & Purchase entries

  • Managing Godown

  • GST

  • Introduction to GST (Basic terminology on GST Taxation)

  • Creating Stock with GST Rates & Creating ledgers of GST

  • Entries on Invoice, Purchase, Sales, Payment.

  • Auto calculate GST 

  • Appling for New GST No

  • Filling of GST Returns

  • Income Tax

    • Concept of Income Tax

    • Appling for New PAN no.

    • Various Tax Slab

    • Filing IT Return

Course Duration: - 4 Months (Daily 3 HRS) (Monday – Friday)

Certificate Issued: - On successfully completing the exam candidate will get one certificate from our institute.

FOR ANY QUERIES