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

Course Objective :

To train students in creating professional documents, mastering formatting, automation tools, and advanced features of Microsoft Word 2024 for office, academic, and freelance work.

• Introduction to Microsoft Word
• Basic Document Creation & Editing
• Text Formatting & Styles
• Page Layout & Design
• Working with Tables
• Images, Shapes & SmartArt
• Headers, Footers & Page Numbering
• Advanced Document Features
• Mail Merge (Highly Important)
• Cross Reference & Table of Content (TOC)
• Automation & Productivity Tools
• Document Protection & Sharing
• Printing & Exporting
• Cloud Integration & Modern Features
• Troubleshooting & Best Practices
• Real-World Projects

Activities:

• Create a professional resume
• Design a business letterhead
• Build a project report with TOC
• Generate certificates using Mail Merge

Create a brochure/poster

• 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

• Creating professional presentations
• Slide design, transitions & animations
• Master slides & templates
• Embedding media & charts
• Presentation delivery techniques

• Database concepts & structure
• Creating tables, queries & forms
• Relationships & data integrity
• Reports & data export
• Basic SQL queries

• 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

• Learn types and elements of accounts, Commerce introduction, Accounting, Book-Keeping
• Company & Ledger Creation, Alteration, Deletion & Securing Company data & profile
• Basic and functional key commands and Tally Shortcut Keys
• Understanding all accounting groups
• Learn the basic rules, when & why use of different Tally Pre-Defined accounting vouchers
• Learn all Tally Accounting Vouchers such as Contra, Payment, Receipt & Journal Vouchers
• Learn how to manage outstanding & advanced journal entries using Journal Voucher in Tally
• Understanding top Tally Reports such as Balance Sheet, Trial Balance, P/L Report, Day Book Report, Stock Summary Report, Ratio Analysis, different essential accounting & Inventory reports such as Sales and Purchase Registers, Outstanding Reports, Party-wise Reports, Ledger-wise reports, Stock Item-wise reports, Batch number wise reports, Purchase & Sales order history and many more…
• Learn when & how to use cost centres and cost categories, a method to use multiple cost categories, and pre-defined cost centre allocation
• Tally Banking features- Cheque Book Configuration, Post Dated Cheque & Bank Reconciliation (BRS)
• Explore Inventory or stock 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 with additional cost
• Learn the purchase and selling of Capital Goods & trading items
• Learn about Batch Control, Part Number, and 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, such as purchase & Sales orders Processing
• Learn the beauty and difficulties of purchase and sales returns, stock adjustment through rejection inward/outward and bill adjustment using Debit or Credit note entries
• Learn to create a Point of Sales (POS) Invoice
• Learn late fine and interest calculation in Tally
• Learn & explore Rejection in and Rejection Out inventory vouchers in Tally
• Learn how to create a Tax Invoice in Tally & Voucher Numbering in Tally
• Auto Billing, Logo Printing, Printing Configuration, Rate Inclusive of GST, Item Description
• Learn how to set predefined multiple price levels, where we can set prices for the product
• Learn how to use non-accounting vouchers in Tally, such as memorandum vouchers
• Explore Tally utility options such as multi-currency, splitting the 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 the 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 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
• Manufacturing & Stock Journal in Tally, and also learn about Bill of Materials (BOM)
• Learn how to create a Pay Slip in Tally using Payroll management, and also explore the elements of a Pay Slip, Payroll setup entries, and Payroll Reports
• Security features, Tally Backup features, Budgets & Controls and Tally Audit features
•