1. Basics of Accounting

• Introduction to Accounting Concepts & Principles
• Accounting Terminology and Rules of Debit & Credit
• Types of Accounts – Personal, Real & Nominal
• Journal Entries, Ledger Posting, and Trial Balance
• Cash Book, Bank Reconciliation Statement
• Final Accounts – Trading, Profit & Loss, and Balance Sheet
• Introduction to Taxation and GST Concepts
• Hands-on Practice: Manual Accounting Exercises

2. Advanced Excel for Accounting

• Introduction to Excel Interface and Shortcuts
• Data Entry, Formatting, and Formulas
• Functions for Accounting: SUMIF, COUNTIF, VLOOKUP, HLOOKUP, IF, and more
• Conditional Formatting & Data Validation
• Creating Financial Reports and Pivot Tables
• Charts, Graphs, and Dashboards for Data Visualization
• Data Cleaning & Automation using Macros
• Hands-on Project: Financial Dashboard Creation

3. Basic Tally Prime

• Introduction to Tally Interface and Company Creation
• Ledger, Group, and Voucher Management
• Recording Transactions – Sales, Purchase, Receipts, and Payments
• Inventory Management – Stock Items, Units, and Categories
• Generating Accounting Reports: Day Book, Ledger, Trial Balance
• Introduction to GST Setup and Basic Returns
• Hands-on Project: Company Bookkeeping in Tally

4. Advanced Tally Prime

• Advanced GST Concepts: Input Credit, GSTR-1, GSTR-3B
• TDS, TCS, and Payroll Management
• Cost Centers and Budgeting
• Interest Calculations and Outstanding Management
• Advanced Inventory Management
• Bank Reconciliation and Audit Features
• MIS Reporting and Data Analysis
• Exporting and Integrating Tally Data with Excel
• Hands-on Project: GST-Ready Business Accounting System

5. Power BI for Business Analytics

• Introduction to Business Intelligence and Data Visualization
• Connecting Power BI with Excel and Tally Data
• Power Query and Data Cleaning
• Creating Interactive Dashboards and Reports
• DAX Functions and Measures for Analysis
• Visualizing Financial & Tax Data for Insights
• Publishing Reports to Power BI Service
• Hands-on Project: Financial Performance Dashboard

6. Practical Taxation & Compliance Overview

• Understanding GST, TDS, and Income Tax Basics
• Filing and Compliance Procedures (Overview)
• Accounting for Tax Liabilities in Tally
• Generating Tax Reports and Audit Statements
• Real-world Case Studies and Practice Exercises

7. Final Project & Professional Skills

• End-to-End Accounting & Reporting Project
• Business Analysis using Excel, Tally, and Power BI
• Report Presentation and Decision-Making
• Career Guidance & Resume Building for Accounting Roles