Bestseller
Bestseller
Course Description
Tally Prime & Advanced Excel is a career-oriented course designed to build strong accounting and data management skills. This course combines practical accounting using Tally Prime with advanced Excel techniques used in businesses and offices.
Students will learn company accounts handling, GST billing, financial reports in Tally, along with advanced Excel skills like formulas, functions, data analysis, and reporting. This course is highly useful for students, job seekers, accountants, and business owners.
After completing the course, students will be able to manage accounts professionally and handle complex data efficiently using Excel.
Course Syllabus (Main Points)
Module 1: Basics of Accounting
• Introduction to Accounting
• Types of Accounts
• Golden Rules of Accounting
Module 2: Tally Prime
• Introduction to Tally
• Company Creation
• Ledger & Group Creation
• Voucher Entries (Sales, Purchase, Payment, Receipt)
Module 3: GST in Tally
• GST Basics
• GST Setup
• GST Billing
• GST Reports
Module 4: Reports in Tally
• Day Book
• Trial Balance
• Profit & Loss Account
• Balance Sheet
Module 5: Advanced Excel
• Advanced Formulas (IF, VLOOKUP, HLOOKUP, INDEX, MATCH)
• Data Sorting & Filtering
• Conditional Formatting
• Pivot Tables
• Charts & Dashboards
Module 6: Data Analysis & Reporting
• Data Validation
• MIS Reports
• Basic Financial Analysis
• Excel Shortcuts
Module 7: Practical Training
• Real-time Accounting Practice
• Excel Projects
• Business Case Studies
Copyright © 2026 WINDOWS EDUCATION. All Rights Reserved
