Module 1: Fundamentals of Computer and MS Office Suite (3months)
Course Objectives:
- To provide a solid foundation in computer hardware and software.
- To develop proficiency in using MS Office Suite applications.
- To enhance productivity and efficiency through effective technology utilization.
Unit 1: Computer Basics
- Introduction to Computers:
- Define a computer and its components.
- Differentiate between hardware and software.
- Explain the concept of input/output devices.
- Describe the role of the central processing unit (CPU).
- Discuss the concept of memory (RAM, ROM).
- Explain the functions of storage devices (hard disk, SSD, USB).
- Operating Systems:
- Define an operating system.
- Explain the functions of an operating system.
- Differentiate between different types of operating systems (Windows, macOS, Linux).
- Basic navigation in Windows OS.
- File and folder management (creating, renaming, deleting, copying, moving).
- Control panel settings.
- Internet Basics:
- Introduction to the internet and its uses.
- Web browsers (Chrome, Firefox, Edge).
- Search engines (Google, Bing, Yahoo).
- Basic internet safety (phishing, malware, online scams).
- Email accounts (creating, sending, receiving emails).
Unit 2: MS Word
- Word Processing Basics:
- Creating, opening, and saving documents.
- Formatting text (font, size, style, alignment, line spacing).
- Editing text (cut, copy, paste, find, replace).
- Page setup (margins, orientation, paper size).
- Print preview and printing.
- Document Formatting:
- Headers and footers.
- Page numbers.
- Borders and shading.
- Columns.
- Tables:
- Creating, formatting, and manipulating tables.
- Table styles and formatting options.
- Merging and splitting cells.
- Mail Merge:
- Understanding the concept of mail merge.
- Creating a data source.
- Merging documents.
Unit 3: MS Excel
- Spreadsheet Basics:
- Understanding worksheets, cells, rows, and columns.
- Entering data (text, numbers, dates).
- Basic arithmetic operations using formulas.
- Data Analysis:
- Sorting and filtering data.
- Creating charts and graphs.
- Using basic Excel functions (SUM, AVERAGE, COUNT, IF).
- Formatting:
- Cell formatting (number formats, alignment, fonts).
- Conditional formatting.
Unit 4: MS PowerPoint
- Presentation Basics:
- Creating presentations.
- Slide layouts and design templates.
- Adding text, images, shapes, and charts.
- Slide Design:
- Choosing appropriate colors, fonts, and images.
- Effective use of white space.
- Presentation Delivery:
- Slide show options (manual, automatic).
- Presenter view.
- Tips for effective presentations.
Unit 5: MS Outlook
- Email Management:
- Creating, sending, and receiving emails.
- Email organization (folders, labels).
- Email formatting (attachments, formatting options).
- Contacts:
- Creating and managing contacts.
- Organizing contacts into groups.
- Calendar:
- Scheduling appointments, meetings, and events.
- Setting reminders and alerts.
Practical Assignments and Projects:
- Create a formatted resume using MS Word.
- Develop a simple budget using MS Excel.
- Design a presentation on your favorite hobby using MS PowerPoint.
- Create a contact list and schedule a meeting using MS Outlook.
Module 2: Advanced Excel with Data Analysis and VBA (3months)
Course Objectives:
- To enhance Excel skills for data analysis and manipulation.
- To master advanced Excel functions and formulas.
- To develop skills in data visualization and presentation.
- To acquire programming skills through VBA for automation.
Course Content:
Unit 1: Advanced Excel Functions and Formulas
- Complex Formulas: Nested functions, array formulas, logical functions (AND, OR, NOT, IFERROR)
- Data Validation: Creating data validation rules, input messages, error alerts
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH
- Statistical Functions: AVERAGE, STDEV, COUNTIF, SUMIF
- Financial Functions: PMT, FV, PV, NPV
Unit 2: Data Analysis Tools
- PivotTables: Creating, formatting, and analyzing data
- Pivot Charts: Creating visualizations based on PivotTables
- Data Sorting and Filtering: Advanced sorting and filtering techniques
- What-If Analysis: Goal Seek, Scenario Manager
- Data Consolidation: Combining data from multiple sources
- Data Tables: Creating one-variable and two-variable data tables
Unit 3: Excel Automation with VBA
- Introduction to VBA:
- VBA environment, macros, modules
- Recording and editing macros
- VBA Basics:
- Variables, data types, operators
- Control flow (if-then-else, loops)
- Subroutines and functions
- Excel Object Model:
- Working with Excel objects (workbook, worksheet, range, cells)
- Automating tasks (formatting, calculations, data manipulation)
- User-defined functions
Practical Assignments and Projects:
- Create complex Excel models for financial analysis.
- Develop interactive dashboards using PivotTables and PivotCharts.
- Automate repetitive tasks using VBA macros.
- Analyze real-world datasets and extract meaningful insights.
Module 3: Basics of Accounting and Tally Prime with GSTand Tax (3 months)
Course Objectives:
- Develop a strong foundation in accounting principles and practices.
- Master the use of Tally Prime for accounting and financial management.
- Ensure compliance with GST regulations.
Course Content:
Unit 1: Accounting Fundamentals
- Introduction to Accounting:
- Definition, scope, and objectives of accounting
- Types of accounting (financial, management, cost)
- Basic accounting concepts (business entity, money measurement, going concern, matching principle, duality)
- Accounting equation (assets = liabilities + equity)
- Accounting Cycle:
- Journalizing transactions
- Posting to ledger accounts
- Trial balance preparation
- Financial statements (profit and loss account, balance sheet, cash flow statement)
Unit 2: Tally Prime Basics
- Company Setup:
- Creating a company in Tally Prime
- Defining chart of accounts (groups, ledgers)
- Setting up inventory items
- Configuring GST details
- Voucher Entry:
- Sales, purchase, receipt, payment, journal vouchers
- Contra, debit, credit notes
- Inventory transactions (purchase, sales, returns)
- Inventory Management:
- Stock valuation methods (FIFO, LIFO, weighted average)
- Stock adjustments
- Inventory reports (stock summary, stock valuation)
Unit 3: GST in Tally Prime
- GST Concepts:
- Understanding GST (CGST, SGST, IGST)
- Input tax credit (ITC)
- GST registration and compliance
- Tally Prime GST Setup:
- Configuring GST details in company setup
- Creating GST-related ledgers
- GST Returns:
- Preparing GSTR-1, GSTR-2, GSTR-3B
- Reconciling GST returns
- Handling GST adjustments and refunds
- GST Invoicing:
- Creating tax invoices
- Handling inter-state and intra-state supplies
- Reverse charge mechanism
Unit 4: Advanced Tally Features
- Banking Reconciliation:
- Bank statement import and reconciliation
- Payroll Processing:
- Basic payroll calculations
- Statutory deductions (TDS, PF, ESI)
- Salary slip generation
- Financial Reporting:
- Customized reports
- Ratio analysis
- Auditing and Internal Controls:
- Basic audit concepts
- Internal control procedures
Practical Assignments and Projects:
- Create a general journal and ledger accounts for a hypothetical business.
- Prepare financial statements (profit and loss, balance sheet) for a given data set.
- Create a GST-compliant company in Tally Prime.
- Record sales, purchases, and expenses in Tally Prime.
- Prepare GST returns (GSTR-1, GSTR-2, GSTR-3B).
- Perform bank reconciliation.
Module 4: Busy Software with Tax and GST (3 months)
Course Objectives:
- To gain proficiency in Busy accounting software.
- To understand the integration of accounting and taxation.
- To prepare financial reports and tax returns using Busy.
Course Content:
Unit 1: Busy Software Basics
- Introduction to Busy Software
- Company setup and configuration
- Creating groups, ledgers, and stock items
- Voucher entry (sales, purchase, journal, etc.)
- Inventory management
- Bank reconciliation
Unit 2: Accounting and Taxation in Busy
- Accounting concepts and principles within Busy
- GST setup and configuration
- Creating GST-related ledgers and reports
- TDS and TCS setup and calculations
- Service tax and excise duty (if applicable)
- Inventory valuation and costing methods
Unit 3: Advanced Features in Busy
- Financial reporting (profit and loss, balance sheet, cash flow)
- Ratio analysis
- Budgeting and forecasting
- Payroll processing (optional)
- Integration with other software (e.g., MS Office)
- Audit trail and security features
Unit 4: Practical Applications and Projects
- Creating and managing accounting data
- Generating financial reports
- Filing GST returns
- Preparing TDS and TCS returns
- Analyzing financial performance
- Implementing internal controls
Assessment:
- Practical assignments using Busy software
- Accounting projects
- Tax return preparation
- Case studies and simulations
- Mid-term and end-term exams
The Diploma in Financial Accounting program aims to:
- Develop a comprehensive understanding of accounting principles and practices.
- Equip students with practical skills in financial accounting and reporting.
- Foster proficiency in using accounting software for efficient financial management.
- Enhance analytical and problem-solving abilities for informed decision making.
- Prepare students for entry-level accounting positions and further studies in finance.
- Develop a strong foundation for understanding business operations and financial performance.
- Ensure compliance with relevant accounting standards and tax regulations.
By the end of the program, students will be able to:
- Apply accounting concepts to real-world business scenarios.
- Prepare accurate and timely financial statements.
- Utilize accounting software effectively for financial management.
- Analyze financial information to support decision-making.
- Demonstrate understanding of tax regulations and compliance requirements.
Additional Benefits:
- Free English communication classes
- Free e-books
- Free personality development workshops
- Free interview preparation workshops and seminars
- Extra practice time
- Scholarship opportunities