Address : 279/1, New Railway Road Gurgaon
Call us : 99 10 192 454 | 98 11 170 798
Email: usflindia@gmail.com

"Speak a new language
so that the world
will be a new world."

Diploma in Financial Accounting

Software Covered: -Advance Excel, MIS Report, TALLY ERP 9& GST Fees: Duration: 06 Months (Daily Batch: Mon to Sat)

Module 1: Overview of the Basics


  1. Customizing common option in Excel
  2. Absolute and Relative cells
  3. Protecting and un-protecting worksheets and cells

Module 2: Working with Functions


  1. Writing conditional expressions (using IF)
  2. Using logical functions (AND, OR, NOT)
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

Module 3: Data Validation


  1. Specifying a valid range of values for a cell
  2. Specifying a list of valid values for a cell
  3. Specifying custom validations based on formula for a cell

Module 4: Working with Templates


  1. Designing the structure of a template using templates for standardization of worksheets

Module 5: Sorting and Filtering Data


  1. Sorting tables
  2. Using Multiple-level sorting
  3. Using custom sorting
  4. Filtering data for selected view (Auto Filter)
  5. Using advance filter options

Module 6: Working with Reports


  1. Creating subtotals
  2. Multiple-level subtotals
  3. Creating Pivot tables
  4. Formatting and customizing Pivot tables
  5. Using advanced options of Pivot tables Pivot charts
  6. Consolidating data from multiple sheets and files using Pivot tables
  7. Using external data sources
  8. Using data consolidation feature to consolidate data

Module 7: More Functions


  1. Date and time functions
  2. Text functions
  3. Database functions

Module 8: Formatting


  1. Using auto formatting option for worksheets
  2. Using conditional formatting option for rows, columns and cells

Tally 9 & ERP 9

Tally 9 & ERP 9 Fundamentals of Tally ERP 9


  1. Introduction
  2. Getting Functional with Tally.ERP 9
  3. Company Features
  4. Configurations
  5. Creation of Company

Creating Accounting Masters


  1. Chart of Accounts
  2. Group
  3. Ledgers

Creating Inventory Masters


  1. Stock Group
  2. Stock Categories
  3. Units of Measure
  4. Godowns
  5. Stock Items
  6. Accounting Voucher
  7. Walkthrough for recording Accounting Voucher

Voucher Entry


  1. Inventory Vouchers
  2. Walkthrough for recording Inventory Vouchers
  3. Invoicing
  4. Security Controls

Security Controls Technological Advantages of Tally ERP 9


  1. Backup and Restore
  2. Print Preview and Online Help
  3. Printing Reports

Advance Accounting


  1. Bill-wise Details
  2. Cost Centres and Cost Categories
  3. Multiple Currencies
  4. Stock Summary

Advance Inventory


  1. Order Processing
  2. Tracking Numbers
  3. Bill of Material (BOM)
  4. Price Levels and Price Lists
  5. Different Actual and Bill Quantities

Taxes & Payroll


  1. TDS
  2. TCS
  3. PAYROLL
  4. GST
    1. Introduction to GST
    2. GST Registration
    3. Why is GST Registration important?
    4. How to Register for GST
    5. What is GSTIN – Goods & Services Tax Identification Number
    6. Casual Registration
    7. Composition Dealer
    8. Migration to GST
    9. Multiple Registrations under GST
    10. HSN Code
    11. Type of GST (SGST, CGST, IGST)
    12. ITC (Input Tax Credit)
    13. GST Rates
    14. Types of GST Return and their Due Dates

your interest

Universal School