



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.