DFA (Diploma in Financial Accounting)

Duration: 6 Months

Tally ERP 9.0

  • BASIC OF ACCOUNTING Introduction
  • Types of Accounts
  • Accounting Principles or concepts
  • Mode of Accounting
  • Rules of Accounting
  • Double-entry system of bookkeeping

FUNDAMENTALS OF TALLY.ERP 9

  • Company Features
  • Configuration
  • Getting functions with Tally.ERP9
  • Creation / setting up of Company in Tally.ERP9

ACCOUNTING MASTERS IN TALLY.ERP 9

  • Chart of Groups
  • Groups
  • Multiple Groups
  • Ledgers
  • Multiple Ledgers

INVENTORY MASTERS IN TALLY.ERP9

  • Stock Groups
  • Multiple Stock Groups
  • Stock Categories
  • Multiple Stock Categories
  • Units of Measure
  • Stock Items

VOUCHERS ENTRIES IN TALLY.ERP9

  • Introduction
  • Types of Vouchers
  • Chart of Vouchers
  • Accounting Vouchers
  • Inventory Vouchers
  • Invoicing

ADVANCE ACCOUNTING IN TALLY.ERP9

  • Bill wise details
  • Cost centers and Cost Categories
  • Multiple currencies
  • Interest calculations
  • Budget and controls
  • Scenario management
  • Bank Reconciliation

ADVANCE INVENTORY IN TALLY.ERP9

  • Order Processing
  • Recorder Levels
  • Batch-wise details
  • Bill of Materials

TAXES IN TALLY.ERP9 TDS

  • TDS Reports
  • TDS Online Payment
  • TDS Returns filing
  • TDS Certificate issuing
  • 26AS Reconciliation
  • TCS
  • TCS Reports
  • GST
  • GST Returns
  • EPF
  • ESIC
  • Professional Tax

PAYROLL ACCOUNTING IN TALLY.ERP9

  • Employee Creation
  • Salary Define
  • Employee Attendance Register
  • Pay Heads Creation
  • Salary Report

GENERATING REPORTS IN TALLY.ERP9

  • Financial Statements
  • Trading Account
  • Profit & Loss Account Balance Sheet
  • Accounts Books and Reports
  • Inventory Books and Reports
  • Exception Reports
  • Statutory Reports
  • Payroll Reports
  • Trail balance
  • Day Book
  • List of Accounts
  • Stock Summary
  • Outstanding Statement

MS-Excel

Manage Workbook Options and Settings

  • Create Worksheets and Workbooks
  • Navigate in Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks

Apply Custom Data Formats and Layouts

  • Apply Custom Data Formats and Validation
  • Conditional Formatting and Filtering

Create Tables

  • Create and Manage Tables
  • Filter and Sort a Table

Perform Operations with Formulas and Functions

  • Summarize Data by using Functions
  • Format and Modify Text by using Functions
  • Perform Conditional Operations by using Functions

Create Charts and Objects

  • Create Charts
  • Insert and Format Objects
  • Format Charts

Apply Custom Data Formats and Layouts

Create Advanced Formulas

  • Apply Functions in Formulas
  • Look up data by using Functions
  • Apply Advanced Date and Time Functions
  • Troubleshoot Formulas

Create Advanced Charts and Tables

  • Create and Manage PivotTables
  • Create and Manage Pivot Charts

Advance Excel

  • What If Analysis
  • Logical Functions
  • Data Validation
  • Lookup Functions
  • Pivot Tables
  • Charts and slicers
  • Excel Dashboard
  • VBA Macro
  • Introduction to VBA
  • Variables in VBA
  • Message Box and Input box Functions
  • If and select statements
  • Looping in VBA
  • Mail Functions – VBA
Best Training Institute for IT Software Hardware & Networking Courses in LucknowClick to call
Best Training Institute for IT Software Hardware & Networking Courses in LucknowEnquiry Now