Goal: Build complete operational fluency in Windows, digital communication, professional documentation, and presentations.
Week 1: Computer Fundamentals, Windows 10/11 & Typing
Computer components (CPU, RAM, ROM, SSD/HDD), input/output devices, and peripheral connections.
Navigating Windows 10/11, Control Panel, Task Manager, folder hierarchy, file compression (ZIP/RAR), and touch typing fundamentals.
Week 2: Internet Productivity, Email & Digital Utilities
Web browsers, search operators, online form filling, Google Drive/Docs, and PDF merging/converting tools.
Writing professional emails (To, CC, BCC, attachments) and basic cyber hygiene.
Week 3: Application Software — MS Word
Page margins, paragraph formatting, styles, tables, headers/footers, page numbers, and watermarks.
Mail Merge for bulk letters/certificates, hyperlinks, and print-ready PDF exports.
Week 4: Application Software — MS PowerPoint & Month-1 Exam
Slide layouts, Slide Master, themes, SmartArt, charts, custom animations, slide transitions, and presenter view.
Month-1 Evaluation: Typing speed & file-management test + formatted official letter (Word) and 6-slide presentation (PowerPoint).
Goal: Master workplace data analysis in Excel and transition into computerized double-entry accounting in Tally ERP 9.
Week 5: MS Excel — Core Formulas & Logical Functions
Workbook navigation, relative vs. absolute cell referencing, sorting, filtering, and SUM, AVERAGE, COUNT, MIN/MAX.
Conditional and lookup formulas: IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, and XLOOKUP.
Week 6: MS Excel — Pivot Tables, Charts & Business Trackers
Conditional formatting, Data Validation dropdowns, Pivot Tables, Pivot Charts, and print page-break setup.
Building an automated employee attendance/salary register and a monthly sales summary sheet.
Week 7: Tally ERP 9 — Accounting Principles & Company Setup
Golden rules of accounting, assets, liabilities, income, and expenses.
Company creation, alteration, security control, Tally Vault, F11/F12 configurations, and creating Accounting Groups and Ledgers (Single & Multiple modes).
Week 8: Tally ERP 9 — Day-to-Day Vouchers & Month-2 Exam
Recording Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), Purchase (F9), Debit Note (Ctrl+F9), and Credit Note (Ctrl+F8).
Inspecting Day Book, Cash/Bank Book, Trial Balance, Profit & Loss Account, and Balance Sheet.
Month-2 Evaluation: Timed Excel formula/Pivot test + 1-month service and trading company voucher entry assignment in Tally ERP 9.
Goal: Manage multi-location stock, process GST-compliant tax invoices, reconcile bank statements, and complete an end-to-end business project.
Week 9: Inventory Management & Order Processing
Creating Stock Groups, Stock Categories, Units of Measure, Stock Items, and multiple Godowns/Locations.
Inter-godown Stock Journal (Alt+F7) transfers, Purchase Orders (Alt+F4), Sales Orders (Alt+F5), Receipt/Delivery Notes, and Stock Summary analysis.
Week 10: Goods & Services Tax (GST) in Tally ERP 9
Activating GST, configuring HSN/SAC codes, and creating CGST, SGST, and IGST ledgers.
Recording intrastate and interstate B2B/B2C tax invoices, credit/debit notes, and generating GSTR-1, GSTR-2, and GSTR-3B reports.
Week 11: Banking (BRS), TDS/Payroll & Data Security
Cheque printing, payment advice, and Bank Reconciliation Statement (BRS).
Basic TDS deduction entries, simple monthly salary/payroll vouchers, Data Backup, Restore, and exporting financial reports to PDF/Excel.
Week 12: Final Integrated Capstone & Certification Exam
Capstone Project: Prepare an employee salary & sales tracker in Excel alongside a complete 1-month GST-compliant trading business (vouchers, inventory, BRS, and Balance Sheet) in Tally ERP 9.
Final Certification Exam: Practical lab exam + viva voce covering Basic Computer, MS Office, and Tally ERP 9.
Call us at:
+91-9779600740, 9855474016