Tally ERP 9 + MS Excel Baic to Advance Course Pack

Learn Tally ERP 9 + MS Excel Basic to Advance Course Learn Tally ERP and Microsoft Excel Function and Tricks

Created by: Saad Nadeem
Financial Consultant and Instrutor

What Will I Learn?

• Company creation, ledger management, and inventory setup.
• Handling day-to-day transactions like purchases, sales, and cash management.
• Dealing with customer advances, purchase orders, and returns.
• Generating various financial reports and customizing them.
• Setting up a manufacturing company in Tally ERP.
• Managing manufacturing processes, raw material inventory, and finished goods assembly.
• Handling production-related transactions like sales orders and purchase orders.
• Dealing with expenses, payments, and inventory adjustments.
• Backup, restore, and company deletion procedures.
• Stock management at multiple locations using go downs.
• User access rights and payroll system management.
• Dealing with foreign currencies and exchange rates.
• Fundamental Excel features such as fill series and editing custom lists.
• Absolute and relative referencing, IF conditions, and nested IFs.
• Data analysis tools like conditional formatting, sorting, and filters.
• Advanced functions like VLOOKUP, INDEX MATCH, and DSUM.
• Pivot tables, pivot charts, and dashboard reporting.
• Automation techniques including macros and automated cheque printing.

Requirements

• he course has no specific prerequisites. Basic computer literacy and familiarity with accounting concepts would be helpful

Target audience

• All accounts Related students
• This course is ideal for individuals who want to gain proficiency in Tally accounting software