Tally ERP 9 + TallyPrime + GST + Microsoft Excel Training

A Complete Tally ERP 9 and TallyPrime with GST along with Basic to Advance level of MS Excel (2016, 2019, Excel 365)

Created by: Himanshu Dhar
MIS Trainer

What Will I Learn?

• Training on Tally ERP 9 and latest TallyPrime as well
• How to Create Company in Tally
• Learn to create ledger and Understanding Group
• Learn to do Voucher Entry in Tally
• Stock & Inventory Management in Tally
• Point of Sale (POS)
• Bill of Materials (BOM)
• Cost Center and Cost Categories
• Budget in Tally
• TCS and TDS in Tally
• Old Taxation
• GST in Tally
• Payroll in Tally
• Good understanding of Excel at MIS level
• Expertise in Text Function, Logical Function and Math Function
• Updated features of MS Office 2013, 2016 & 2019 like Power Tools, Quick Analysis, Textjoin, XOR, IFS, Draw Tab and many more
• Expertise in Lookup and Reference Function with latest XLOOKUP Function
• Expertise in Lookup and Reference Functions
• Expertise in Date and Time settings and Functions
• Mastery in Pivot Table and Chart Preparation
• Mastery in 'What if Analysis' tools
• Print Option in Excel
• Data Validation, Filter, Sorting 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
• Working with Power Pivot and Power Map

Requirements

• Basic Computer Knowledge

Target audience

• Anyone want to learn Tally ERP along with Advance Excel