Certified Advanced Office Automation & Financial Accounting

by Keerti Computer Institute Claim Listing

Take your skills to the next level with courses on the most popular programming languages, developer tools, and software practices. Gain a deep understanding of how to build and stay up to speed on the ever-changing landscape of emerging software development tools and techniques.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Keerti Computer Institute Logo

img Duration

6 Months

Course Details

Take your skills to the next level with courses on the most popular programming languages, developer tools, and software practices. Gain a deep understanding of how to build and stay up to speed on the ever-changing landscape of emerging software development tools and techniques.

 

Content:

  • Fundamentals and Operating System
  • 1. Computer Competency
  • 2. System Software
  • 3. Windows OS
  • 4. Application Software
  • MS Office 2013
  • 1. MS Word 2013
  • 2. MS Excel 2013
  • 3. MS PowerPoint 2013
  • 4. MS Outlook 2013
  • Internet & Web
  • 1. Working of the Internet
  • 2. World Wide Web
  • 3. Email
  • Advance Excel 2013
  • 1. Advanced File Tasks
  • 2. Working with Formulas and Functions
  • 3. Managing Tables in Microsoft Excel
  • 4. Data Tools in Excel
  • 5. Sparkline
  • 6. Grouping & Outlining and Subtotals
  • 7. What-If Analysis
  • 8. Advanced PivotTables & Charts
  • 9. Advanced Excel Tasks
  • 10. Creating HLOOKUP and VLOOKUP Functions
  • 11. Advanced Conditional Formatting
  • 12. Advanced Lookup Functions
  • 13. Advanced Functions in Excel
  • Advance Tally ERP 9.0 Using GST
  • User Interface and Company Management
  • 1. Introduction to Tally ERP9
  • 2. Creating a Company
  • 3. Data Path for Tally ERP9 Companies
  • 4. Altering and Deleting Company
  • Ledgers & Groups
  • 1. Understanding Ledgers
  • 2. Creating Ledgers
  • 3. Creating Multiple Ledgers
  • 4. Altering and Deleting Ledgers
  • Inventory in Tally.ERP 9
  • 1. Stock Groups and Categories
  • 2. Godowns/Locations
  • 3. Units of Measure
  • 4. Stock Items
  • Accounting Vouchers
  • 1. Contra Vouchers
  • 2. Payment Voucher
  • 3. Receipt Voucher
  • 4. Journal Voucher
  • 5. Sales Vouchers
  • 6. Pre-defined Voucher Types in Tally.ERP 9
  • 7. Alter a Pre-defined Voucher Type
  • Advance Inventory in Tally.ERP 9
  • 1. Cost of Purchases
  • 2. Stock Categories
  • 3. Order Processing: Sales & Purchase Order
  • 4. Use Standard Rate for Stock Item
  • 5. Stock Summary/ Stock Transfer
  • 6. Tracking Numbers: Delivery Notes, Receipt Notes.
  • 7. Rejection Inward/Rejection Outward
  • 8. Batch Wise details
  • 9. Additional Cost Details
  • 10. Bill of Material(BOM)
  • 11. Different Actual and Bill quantities
  • 12. Price Levels and Price Lists
  • 13. Stock Valuation
  • 14. Zero Valued Entries
  • 15. Point of Sales(POS)
  • Advanced Accounting in Tally.ERP9
  • 1. Bill-wise Details, Cost/Profit Center Management
  • 2. Credit Period/Trade Discount/Cash Discount
  • 3. Cost Centers and Cost Categories
  • 4. Voucher Classes and cost center class
  • 5. Multiple Currencies
  • 6. Interest Calculation
  • 7. Bank Reconciliation
  • 8. Cheque Printing
  • 9. Budgets and Controls
  • 10. Scenario Management
  • Goods and Services Tax (GST)
  • 1. About Goods and Services Tax (GST)
  • 2. Activating Tally in GST
  • 3. Setting Up GST (Company Level, Ledger Level or Inventory Level)
  • 4. GST Taxes & Invoices
  • 5. Understanding SGST, CGST & IGST
  • 6. Creating GST Masters in Tally
  • Purchase Voucher with GST
  • 1. Updating GST Number for Suppliers
  • 2. Practical on Intra-State Purchase Entry in GST (SGST + CGST)
  • 3. Practical on Inter-State Purchase Entry in GST (IGST)
  • 4. GST Purchase Entry for Unregistered Dealer in Tally
  • 5. Accounting for return of Goods (With Credit Notes)
  • 6. Reverse Charge Mechanism Entry for GST in Tally
  • Sales Voucher with GST
  • 1. Updating GST Number for Suppliers
  • 2. Practical on Intra-State Sales Entry in GST (SGST + CGST)
  • 3. Practical on Inter-State Sales Entry in GST (IGST)
  • 4. Accounting for return of Goods (With Credit Notes)
  • GST in Services
  • 1. Basic of Services ( Accounts only)
  • 2. Creating Masters?
  • 3. Recording Transactions
  • Tax Deducted at Source (TDS)
  • 1. Understanding TDS
  • 2. Creating TDS Masters
  • 3. Practical Examples
  • 4. TDS Payment
  • 5. Tax Reports and Tax Forms
  • Reports in Tally ERP 9
  • 1. Analysing Purchase and Sales Register
  • 2. Analysing Debit and Credit Note
  • 3. Overdue Payables and Receivables
  • 4. Stock Valuation
  • 5. Stock transfer Report (Physical Stock & Shortage)
  • 6. Cash Book & Bank Book
  • 7. Trial Balance
  • 8. Profit and Loss Account and Balance Sheet
  • 9. Working Capital
  • 10. Cash Flow and Fund Flow Statements
  • Utilities in Tally ERP 9
  • 1. Multi Language
  • 2. Data Backup and Restore
  • 3. Data Security & Audit
  • Invoice Printing In Tally ERP 9
  • 1. Sales Invoice
  • 2. Printing Payment and Receipt Vouchers
  • 3. Printing Various Other Reports Module
  • 4. Logo Printing on Sales Invoice
  • GST Adjustment and Returns
  • 1. GSTR 1 & GSTR 2 in Tally 2. GSTR 1 Return Filing
  • 3. Input Tax Credit Set Off
  • 4. Challan Reconciliation
  • 5. GST Tax Payment
  • 6. Generating GSTR-3B Format
  • Mumbai Branch

    26/202, Anand Nagar, Vakola Bridge, Nehru Road, Mumbai
  • Thane Branch

    101/102, First Floor, Malhar, Opp. Gaondevi Mandir, Gokhale Road, Thane

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy