Duration: 6 MONTHS

Course Syllabus

Computer Basic

MS word 2013
Creating New document
Writing and simple formatting
Page layout
Screen and Its Elements
Pictures and Graphics
Mail Merge
Envelop and Labels
Proofing(Spelling and grammar check, track changes, treasures)

MS PowerPoint 2013

Getting started with PowerPoint
Creating basic presentation
Using presentation views
Using text pictures and graphics
Using smart art, chart, tables and objects
Using slide show view
Appling animation, transition
Drawing object
Insert video and sound
Using themes, using presentation masters
Setting up the presentation (setting up slide show, recording narration, rehearsing time)
Applying action (hyperlink)

Ms Excel

Getting started with excel
Creating basic workbooks
Using ranges
Copying , pasting, creating formulas
Columns and rows
Worksheet tools
Formatting worksheets
Setting worksheet layouts, printing worksheets
Conditional formatting and cell styles
Paste special
Creating ,formatting, editing worksheet charts
Pivot tables
Sorting and filtering data

Tally Erp 9 with GST
Basic Tally Erp 9 with GST
Introduction to financial accounting and basic
Advance financial accounting
Taxes- TDS, VAT,
Non trading Organization
Business Organization
Service organization
Trading organization
Manufacturing organization
Accounting On computers
Basic Accounting concepts
Rules of Accounts
Basic Journals Entries
Benefits of A/c on Computers
Transaction in Tally ERP 9
Tally fundamentals
Features of Tally ERP9
Configuration of Tally ERP 9
Creation/ Setting up Company in Tally ERP 9
Use of vouchers
Ledgers and Groups
Service Organisation
Structure of Service Organisation
GST for service
GST for expenses
GST adjustments and payments voucher
GST for reports
Trading organisation
Inward and outward supply with GST
Cash and credit purchase and sales
Invoicing in tally ERP 9
Inventory creations with HSN
Inventory transaction with GST
Overview of tally ERP 9
Features of tally erp9
Advantages ac and inventory features
F11 features
F12 configuration
GST activation
Advanced accounting with GST features
Bill wise details with GST
Voucher class for GST
Cost centres/ cost categories with GST
Purchase from URO
Bank reconciliation statement
Zero valued entries
Backup restore
Additional cost of purchase
Interest calculations
Advanced inventory features
Actual and billed quantity
Separate discount columns
Multiple price levels
Point of sales POS
GST R accounting and inventory reports
Accounting reports
GST R1 reports
Inventory reports
GST R2 reports
GST R3 reports
B2B invoice reports
B2C invoice reports
Manufacturing organization
Purchase and sales with GST
Purchase of raw materials
Storage of goods
Production process
Processing in manufacturing
Maintenance of locations
Getting functional with tally erp9
Recording transactions with GST
Advance accounting vouchers with GST
Advance inventory vouchers with GST
Manufacturing vouchers with GST
Advance stock transactions
Order processing
Tracking numbers
Rejection notes
Invoicing and billing
Statutory features
GST for composition dealer
GST under E way bill
Capital good under GST
Technical advantages of tally erp 9
Predefined cost centers
Batch wise details
Consolidation of accounts
Bill of Material
Display & Reporting

Management & Control Systems
Budget & Control
Scenario Management
Variance Analysis
Reporting & Generations
Sales Register
Purchase Register
Re-order Levels
Optional Vouchers
Credit Limits

System Administration & Utilities
Consolidation of A/c
Split Company Data
Export & Import of Data
ODBC Compliance

Technical Advantage of Tally.ERP 9
Multi Lingual
Security Control
Audit in Tally.ERP 9
Key points of Display

Printing in Tally.ERP 9
Cheque Printing
Voucher Printing
Company Logo Printing
Receipt Printing

Finalization of Accounts
Closing Entries
Adjustment Entries
Profit Screening


Module I- Microsoft Excel
Introduction to Ms excel
Worksheet fundamental
Formatting cell and worksheet
Formatting cell and worksheet
Pivot table and pivot chart option
Graphics and designing in excel
Adds ins groups buttons of insert tab excel
Analysing data in excel
Data validation in excel
Using macros in excel
Module II- Functions and Formulas in Excel
Working with formulas and functions
Logical, text, financial, date and time functions
Lookup and reference function
Mathematical and trigonometry functions
Statistical, database function in excel
Information function in excel
Engineering function
Using names to work with ranges

Read More



Back to top