ADAA (Advance Diploma in Accounting Application)
(Time Duration: 4 Months)
1. MS – OFFICE
- Computerized Typing
- MS-Word
- MS-Excel
- MS-PowerPoint
- Internet
2. Advance Excel
Course Syllabus
- What is MS Excel?
- How to Use Shortcut Keys of Excel
- What is Formatting/ Conditional Formatting?
- What are Formulas in Excel?
- What is Logical & Text Functions?
- What is Filter and Data Validation in MS Excel?
- How to use Pivot Tables for Data Analysis.
- How to Protect Worksheet.
- What is Name Range function in Excel?
- How to draw Charts.
- Trends and Scenarios using charts.
- What is Data Tool?
- How to record Macro in Excel.
- Introduction to Dashboards.
- Advanced Charting Techniques: Thermometer, Doughnut, Pareto, Panel, Step Chart.
- Designing Sample Dashboard using Form Controls.
- Tips and Tricks to Enhance Dashboard Designing.
- Introduction and Basic Overview: Workbook and Worksheet Formatting
- Customized Formatting of Cells in Excel
- Cell References (Absolute, Relative & Mixed) Shortcut Keys
- Other Features (Paste Special, Finding and Replacing Data, etc.)
- Text Formulas: CONCATENATE, UPPER, LOWER, PROPER, DATE, MOD, MODE, TODAY, NOW
- Inserting Comments
- Use of Go to Feature
- Use of Logical Formulas (IF, AND, OR, IFERROR)
- Conditional Formatting in Various Scenarios
- Nested IF Formula with Examples
- COUNT, COUNTA, COUNTBLANK, COUNTIF, SUBTOTAL
- Cell Range & Name Manager
- Auto Filter & Advanced Filter
- Freezing and Unfreezing Panes
- Linking of Worksheets & Workbooks
- Financial Formulas (PMT, PV, DISC, DB, IRR, NPV, etc.)
- Lookup & Reference Formulas (VLOOKUP, HLOOKUP, MATCH, OFFSET, SUMPRODUCT)
Eligibility
- Keen desire to learn Information Technology
- Preferably 10th Std. pass (not compulsory)
3. Advance Tally Prime
Course Syllabus
- ACCOUNTING
- BILLING
- INVENTORY
- BANKING
- Overview of Software
- Gateway and its Elements
- Creation of Company
- Basics of Accounting
- Financial Statements & Reports
- Inventory Masters and Vouchers
- Generating Inventory Books and Reports
- Introducing Bill of Materials (BoM)
- Advanced Tally Features: Debit/Credit Notes, Ledger Creation, Grouping
- Cost Centers, Cost Accumulation, Cost Management
- Voucher Class, Sale/Purchase Vouchers, Receipts, Payments
- Multiple Currencies, Interest Calculations
- Budget and Controls
- Stock Management & Order Processing
- Batch-wise Details, Stock Valuation
- Zero Valued Entries, Job Costing
GST
- Setting Up GST Rates
- Updating Stock Items and Stock Groups for GST
- Creating GST Ledgers
- Recording Sales, Purchases, Sales Returns, Purchase Returns
- Recording Tax Payments, Debit/Credit Notes
- Generating GSTR-1
- Challan Reconciliation and Export Sales
