Course Syllabus – Advanced Accounting with Excel (6 Months)

Module 1: Accounting Fundamentals

• Introduction to Accounting
• Types of Accounts & Golden Rules
• Accounting Concepts & Principles
• Journal Entries & Adjustments

Module 2: Ledger & Trial Balance

• Ledger Creation & Posting
• Balancing of Accounts
• Trial Balance Preparation
• Error Identification & Rectification

Module 3: Final Accounts

• Profit & Loss Account
• Balance Sheet Preparation
• Depreciation & Provisions
• Closing Entries

Module 4: Introduction to Excel

• Excel Interface & Shortcuts
• Data Entry & Formatting
• Rows, Columns & Sheets
• Cell Referencing (Relative / Absolute)

Module 5: Excel Formulas for Accounting

• Basic Formulas (SUM, AVERAGE, COUNT)
• Logical Functions (IF, AND, OR)
• Lookup Functions (VLOOKUP / HLOOKUP)
• Date & Financial Functions

Module 6: Accounting Work in Excel

• Ledger Maintenance in Excel
• Trial Balance in Excel
• Profit & Loss Statement using Excel
• Balance Sheet Preparation in Excel

Module 7: Charts & Financial Graphs

• Chart Types (Bar, Line, Pie)
• Financial Data Visualization
• Trend Analysis using Charts

Module 8: MIS Reporting

• Introduction to MIS
• Monthly & Yearly MIS Reports
• Sales, Purchase & Expense Reports
• Management Decision Reports

Module 9: Financial Analysis

• Ratio Analysis
• Cash Flow Analysis
• Budgeting & Forecasting
• Business Performance Analysis

Module 10: Practical Project Work

• Real Business Case Study
• Complete Accounting Cycle in Excel
• Project Report Preparation
• Presentation & Viva

Module 11: Career Guidance & Certification

• Office Accounting Work Handling
• Interview Preparation (Basics)
• Final Assessment
• Certificate Issuance

Course Outcome

• Advanced accounting practical skills
• Strong Excel-based financial reporting
• Job-ready for accounts & office roles
• Better salary & career growth opportunities