Course Objective :

To equip students with complete knowledge of Windows 11 Pro, including installation, configuration, security, troubleshooting, and productivity tools.

• Introduction to Windows 11
• Installation & Setup
• User Interface & Navigation
• File & Folder Management
• User Accounts & Access Control
• Networking & Internet
• Security Features
• System Settings & Personalisation
• Troubleshooting & Maintenance
• Cloud & Productivity Tools

Advanced Features (Pro Level) :

• Enable and use Remote Desktop
• Backup methods (File History, System Image)
• Reset this PC
• Recovery drive creation
• Perform backup and restore

• Microsoft Excel 2024 – Basic to Advanced Professional Training

  Course Objective:

To train students in data handling, analysis, reporting, and automation using Microsoft Excel 2024, enabling them to work efficiently in office, business, and freelance environments.

• Introduction to Excel
• Data Entry & Basic Operations
• Formatting & Cell Management
• Working with Tables
• Charts & Data Visualization
• Basic Functions

Key Topics:

• SUM, AVERAGE, COUNT, MAX, MIN
• IF (basic logic), Row, Column, Sumif, Sumifs,
• Text functions (LEFT, RIGHT, MID)
• Advanced Functions (Core of Course)
• Logical Functions (Decision Making)
• Lookup & Reference Functions (Most Important)
• Text Functions (Data Cleaning & Formatting)
• Date & Time Functions
• Mathematical & Statistical Functions
• Database functions (DSUM, DCOUNT etc.)
• Dynamic Array Functions (Excel 2024 Advanced)
• Financial Functions (Job-Oriented)
• Lookup + Logic Combination (Advanced Level)

• Data Analysis Tools
• Pivot Tables & Pivot Charts
• Data Cleaning & Preparation

Key Topics:

Text to Columns

TRIM, CLEAN functions

Handling errors (#N/A, #VALUE)

Linking & Data Integration

Key Topics:

• Linking worksheets and workbooks
• Import data from external sources
• Basics of Power Query

• Automation with Macros (Intro)
• Advanced Reporting & Dashboards
• Data Security & Sharing
• Printing & Exporting
• Cloud & Collaboration
• Troubleshooting & Best Practices

Key Topics:

• Fix formula errors
• Performance optimization
• Best practices for large files

Real-World Projects

Activities:

• Sales report with charts
• Student result analysis system
• Inventory management system
• Payroll calculation sheet
• Interactive dashboard

• Learn a to z Tally ERP (Enterprise Resource Planning) modules such as Finance & Accounts, Stock or Inventory Management, Manufacturing, Date Handling, Human Resource etc.
  • Learn types and elements of accounts, Commerce introduction, Accounting, Book-Keeping
  • Introduction & Advantages of Tally ERP
  • Company & Ledger Creation, Alteration, Deletion & Securing Company data & profile
  • Basic and functional key commands and Tally Shortcut Keys
  • Understanding all accounting group
  • Learn the basic rules, when & why use of different Tally Pre-Defined accounting vouchers
  • Learn how to manage outstanding & advance journal entries using Journal Voucher in tally
  • Understanding top Tally Reports
  • Learn Purchase and selling of Capital Goods

• • Learn when & how to use cost canter and cost categories, method to use of multiple cost categories, Pre-defined cost centre allocation
  • Tally Banking features- Cheque Book Configuration
  • Tally Banking features – Transaction types
  • Tally Banking features – Post Dated Cheque Management
  • Tally Banking features- Bank Reconciliation (BRS)
  • Explore Inventory management in Tally
  • Learn about Stock Group, Stock Categories and Stock Items, and Godown creation
  • Learn how to transfer goods from one location to another Godown
  • Learn about Batch Control, Part Number, Ageing Analysis of an item
  • Explore the beauty of inventory features such as different actual and billed quantity, separate discount columns, track additional cost on purchase, zero valued entries etc.
  • Learn about order processing in Tally
  • Learn the beauty and difficulties of purchase and sales return, stock adjustment through rejection inward/outward and bill adjustment using Debit or Credit note entries
  • Learn how to Tax Invoice Configuration in Tally & Voucher Numbering in Tally
  • Auto Billing, Logo Printing, Printing Configuration, Rate Inclusive of GST, Item Description
  • Recording Goods/Services, Recording Assets, Recording Expenses-GST
  • Learn how to set of predefined multiple price levels where we can set prices for the product

• • Learn to create Point of Sales (POS Invoice)
  • Learn late fine and interest calculation in Tally
  • Learn how to use non-accounting vouchers in Tally
  • Discover how to create documentation such as Purchase and Sales Order Quotation in Tally
  • Explore Tally utility options such as multi-currency, splitting company, group company, Migrating Data – Data Export/Import, multi-language features etc.
  • Explore Manufacturing Voucher, Bill of Materials (BOM)
  • Understanding GST, TDS, Direct or Indirect taxes
  • Learn about enamelling GST features in Tally
  • Learn how to apply GST, HSN Code of the item in Tally
  • Understanding GST Returns/Reports in Tally
  • Learn GST Returns Filing (Monthly/Quarterly)-GST Tax Payments /Adjustments
  • Learn GST Refunds-GST Annual Returns
  • GST-Registration-Live
  • GST Amendments (Core/Non-Core Fields)-Opting Regular & Composition
  • GST Cancellation / Revocation (All Live Classes-Based on Real time Clients Data)
  • Complete study with GSTR-1 FILING, GSTR-2 FILING, GSTR-3 & 3B FILING, GST E-Way Bills
  • GST Tax Payments & Adjustments
  • Learn how to create Pay Slip in Tally using Payroll management and also explore the elements of a Pay Slip, Payroll setup entries, Payroll Reports
  • Budgets & Controls and Tally Audit features
  • Tally resume Presentation and many more

• Web browsing & search techniques
• Email management (Gmail, Outlook)
• Cloud storage (Google Drive, OneDrive)
• Online collaboration tools
• Cyber safety & digital literacy

• Introduction to AI & prompt engineering
• Using ChatGPT for writing & research
• Microsoft Copilot in Office apps
• AI-powered data analysis in Excel
• AI for presentations & documents