DIPLOMA IN OFFICE AUTOMATION & ACCOUNTING
Course Objective
Module Objective: The objective of this module is to prepare the student with in-depth knowledge of Office Automation Tools and Tally to handle daily business accounting system of any organization. The participant learns the use of Advanced Excel tools for making reports useful for management.
Office Automation – Ms-Office
- Computer Fundamentals
- Ms Word
- Ms Excel
- Ms PowerPoint
Advanced Automation - Advanced Excel
- Sorting, Advance Filtering, Data Validation
- Lookup & Reference Functions
- Logical Functions
- Statistical Functions
- Date and Time Functions
- Math and Trigonometry Functions
- Financial Functions
- Pivot Tables and Sparklines
Tally ERP Accounting Software
- Tally Basics
- Company Creation in Tally
- Inventory Records
- Ledger Entry
- Journal Entry
- Profit & Loss Account, Balance Sheet
GST Foundation with Tally ERP
- GST Basics