Module 1
Introduction to Accounting and MS Office
Overview of basic accounting principles and their applications.
Introduction to MS Office suite: Word, Excel, and PowerPoint.
Understanding how accounting integrates with MS Office tools.
Module 2
Accounting Package Basics
Setting up company profiles and ledgers in Tally or similar software.
Recording day-to-day transactions: Sales, purchases, and payments.
Generating financial reports: Trial Balance, P&L, and Balance Sheet.
Module 3
Advanced Accounting Functions
Managing GST, VAT, and tax compliance in accounting software.
Payroll management and reconciliation of accounts.
Inventory management and financial forecasting.
Module 4
MS Excel for Accounting
Using Excel for bookkeeping: Formulas and financial templates.
Advanced Excel tools: PivotTables, charts, and financial dashboards.
trees
Data validation and error checking for accounting accuracy.
Module 5
MS Word and PowerPoint for Business
Drafting professional documents like invoices and agreements in MS Word.
Creating financial summaries and reports in Word.
Designing impactful financial presentations using PowerPoint.
Module 6
Practical Applications and Project
End-to-end simulation of accounting for a small business.
Customizing Excel for financial data management and reporting.
Preparing a complete financial summary and presenting it in Word and PowerPoint.
