Advanced Diploma in Financial Accounting – Course Outline
Module 1: Computer Fundamentals
- Introduction to Computers
- Hardware and Software Basics
- Operating System Fundamentals
- File and Folder Management
- Internet and Email Basics
Module 2: Microsoft Office
- Introduction to Microsoft Office
- Microsoft Word
- Document Creation and Formatting
- Tables, Images, and Mail Merge
- Microsoft PowerPoint
- Presentation Design
- Animations and Transitions
Module 3: Microsoft Access
- Introduction to Databases
- Creating Tables and Forms
- Queries and Reports
- Database Management Basics
Module 4: Advanced Microsoft Excel
- Advanced Formulas and Functions
- Pivot Tables and Charts
- Data Validation and Conditional Formatting
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Financial and MIS Reports
- Dashboard Creation
Module 5: Advanced Tally
- Introduction to Tally Prime
- Company Creation and Configuration
- Ledger and Voucher Entries
- Inventory Management
- Payroll Management
- Banking Features
- Financial Statements
Module 6: GST (Goods and Services Tax)
- Basics of GST
- GST Registration Process
- GST Invoice Creation
- Input Tax Credit
- GST Returns Filing
- GST in Tally
Module 7: TDS (Tax Deducted at Source)
- Introduction to TDS
- TDS Rules and Rates
- TDS Calculation
- TDS Return Filing
- TDS in Tally
Module 8: ITR (Income Tax Return)
- Basics of Income Tax
- Types of ITR Forms
- Income Tax Calculation
- Online ITR Filing Process
- Tax Saving Concepts
Module 9: Internet Applications
- Internet Basics
- Online Banking
- Digital Payments
- Cloud Storage and File Sharing
- Cyber Security Awareness
Practical Training
- Real-Time Accounting Projects
- GST and TDS Filing Practice
- Excel-Based Financial Reports
- Office Productivity Assignments