Welcome to MS-IPFA ACADEMY
CERTIFICATE IN TALLY WITH EXCEL ( MS-IPFA01 )

BASIC INFORMATION

  • Course Fees : 5100.00 5100.00/-
  • Course Duration : 4 MONTHS
  • Minimum Amount To Pay : Rs.3100.00

Tally with Excel Course Content :

 

Basic & Advance Accounting

Basic of Accounting | Groups | Ledgers | Voucher Types  Cost Categories | Cost Centers | Cost Center Class | Currencies | Credit Limit | Budgets | Scenario Bank Reconciliation | Financial Year | Adjustment  |  Bad Dept

Basic & Advance Inventory Master Program

Stock Groups | Stock Items | Stock Categories | Units, Godowns | Bill Wise Details | Interest Calculation | Price List | Batches ( Mfg. & Expiry Date) | Invoice Printing| Invoice on Discount | Discount Colum Invoice | Actual & Bill Quantity on Invoice | Cost Tracking | Pos (Simple & Multiple) | Order Processing | Invoice on MRP | Manufacturing | Zero Value Entry | Track Additional Cost of Purchase | Voucher Class & Round off Method | MRP Margin / Standard  Buy & Sale Rs

Taxation

Fundamental of GST & TDS

Advance Excel Program

Introducing Excel | Formula & Function | Sales Report | Worksheet Formatting | Chart & Graph | Advance Filter |  Pivot Table | V-Lookup | H-Lookup | Data Validation | Goal seek | Scenario Manager | Condition Formatting | Invoice | Expanses / Income.

Project Work

Related from All Syllabus

  • REQUIRED
  •  
  • 1. 2 Photos
  • 2. 10th Markdheet
  • 3. Aadhar Card
  • 4. Minimum 12th Passout Any Subject