What you’ll learn
TallyPrime + Microsoft Excel Training Course Catalog
- How to Create Company in TallyPrime
- Accounting basics like debits and credits will help you understand and post entries with confidence
- Learn to transfer account information (Bookkeeping) from physical to TallyPrime Software
- Learn to create ledger and alter ledger as well
- Voucher Entry – Learn to do voucher entry and checking Balance sheet and Profit and Loss Account on that basis
- Stock & Inventory Management in TallyPrime – Set up details of Inventory and filter reports like availability of certain stock in a particular warehouse and its cost.
- Learn how sales Bill is generated in TallyPrime in POS (Point of Sales)
- Bill of Materials (BOM) – Learn in how many ways Bill of material can be generated
- Learn the procedure of TDS and TCS in general and implementing it in Tally.
- GST in TallyPrime – Learn about implementing absolutely necessary and advanced GST topics like GST Taxation, Reverse Charge Mechanism, GST on Services, GST on Fixed Assets Multiple GST rates, etc
- Payroll in TallyPrime – Learn complete Corporate Payroll set up that complies with Govt. prescribed deduction rates
- Cost Center and Cost Categories
- Budget in Tally
- Bank Reconciliation
- Good understanding of Excel at MIS level
- Expertise in Text Function
- Expertise in Logical Function
- The Expertise in Math Function
- Expertise in Lookup and Reference Function
- Expertise in Date and Time Function
- Mastery in Pivot Table and Chart Preparation
- Mastery in ‘What if Analysis’ tools
- Print Option in Excel
- Data Validation, Filter, and Conditional Formatting
- Mastery in Data organizing Tools in Excel
- Mastery in Data creation and Data Manipulation in Excel
- Managing data protection and data sharing in Excel
- Work with Macro Recording