MODULE 1: (BASIC COMPUTING)

1. Computer Fundamentals

• Introduction to Computers
• Types of Computers
• Hardware & Software
• Input/Output Devices
• Storage Devices
• Number System (Binary basics)

2. Operating System – Windows

• Desktop, Taskbar, Start Menu
• File & Folder Management
• Copy, Move, Rename, Delete
• Control Panel & Personalization
• Keyboard Shortcuts
• System Settings

3. Typing & Productivity Skills

• English Typing Basics
• Speed & Accuracy Practice
• Shortcut Keys for Fast Work

4. MS Office

MS Word

• Document Creation
• Formatting & Editing
• Tables & Images
• Mail Merge
• Resume & Letter Design

MS Excel

• Cell/Row/Column Basics
• Basic Formulas (SUM, AVERAGE, MAX, MIN)
• Formatting Sheets
• Sorting, Filtering
• Basic Charts
• Attendance & Expense Sheet

MS PowerPoint

• Slides & Themes
• Animations & Transitions
• Presentation Creation
• Tips for Effective PPT

5. Internet & Email

• Web Browsing & Searching
• Online Forms & Downloads
• Email Creation
• Gmail Features (Labels, Filters, Attachments)
• Google Drive Basics

6. Basic Projects

• Word Project (Resume)
• Excel Project (Report Sheet)
• PPT Project (Presentation)

MODULE 2:(Advance Excel)

1. Excel Basics

• Excel Interface
• Workbook/Worksheet
• Rows, Columns, Cells
• Basic Formatting
• Number Formatting (Date, Currency, %, etc.)
• Basic Formulas:
• SUM, AVERAGE, MIN, MAX
• COUNT, COUNTA
• Percentage formulas

2. Data Handling Tools

• AutoFill & Flash Fill
• Sorting (Single & Multi-Level)
• Filtering (Auto, Custom)
• Remove Duplicates
• Text to Columns
• Data Cleaning Techniques
• TRIM, PROPER, UPPER, LOWER

3. Intermediate Formulas

• IF, AND, OR, NOT
• Text Functions: LEFT, RIGHT, MID, LEN, CONCAT
• Date Functions: TODAY, NOW, DATEDIF, MONTH, YEAR
• Lookup Functions:
• VLOOKUP
• HLOOKUP
• XLOOKUP (if needed)

4. Advanced Excel

• INDEX + MATCH
• Nested IF
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• FILTER, UNIQUE, SORT
• INDIRECT
• Error Handling Functions:
• IFERROR, ISBLANK, ISNUMBER

5. Data Analysis Tools

• Pivot Table
• Pivot Chart
• Grouping
• Slicers
• Data Consolidation
• What-If Analysis
• Goal Seek
• Scenario Manager

6. Charts & Dashboards

• Column, Line, Pie Charts
• Combo Charts
• Trendlines
• Sparklines
• KPI Charts
• Creating Professional Dashboards

7. Data Validation & Protection

• Drop-down lists
• Restrict data entries
• Protect Sheet
• Protect Workbook
• Lock & unlock cells

8. Reporting & MIS

• Sales Report
• Purchase Report
• Attendance Sheet
• Stock & Inventory Sheet
• Expense & Profit Sheet
• Bank Reconciliation Format
• Automated Business Templates

9. Productivity & Automation (Non-Macro)

• Keyboard Shortcuts
• Dynamic Ranges
• Template Creation
• Time-saving techniques

10. Practical Projects

• Full MIS Project
• Dashboard Creation
• Lookup-based project
• Data cleaning & analysis project
• Monthly Report preparation project

MODULE 3:(Intermediate Graphic Designing)

1. Introduction to Graphic Designing

• What is Designing?
• Types of Design
• RGB/CMYK Concepts
• Designing Basics (Layout, Typography, Color Theory)

2. Adobe Photoshop

Basic

• Photoshop Interface & Workspace
• Tools (Move, Brush, Eraser, Gradient)
• Layers & Layer Styles
• Selection Tools
• Cropping & Image Resize
• Color Mode & Image Adjustments
• Text & Shape Tools
• Basic Photo Retouching
• Social Media Post Basics

Intermediate

• Smart Objects & Smart Filters
• Advanced Masking
• Double Exposure Effects
• Matte Painting Basics
• Color Correction (Curves, Levels, LUTs)
• Advanced Retouching
• Poster Design Layout
• Creative Blending Techniques

3.CorelDRAW

Basic

• Corel Interface
• Shapes & Curve Tools
• Color Fill & Outlines
• Page Setup & Document Layout
• Text & Typography Basics
• Logo Basics
• Simple Visiting Card Design

Intermediate

• PowerClip, Transparency, Blend
• Professional Logo Design
• Flyer, Poster & Brochure Layout
• Page Layout Techniques
• Prepress Basic Settings
• Advanced Typography
• Print Setup & Exporting

4.Adobe Illustrator

Basic

• Illustrator Interface
• Pen Tool Basics
• Vector Shapes & Paths
• Color Theory, Swatches
• Typography Basics
• Icon Creation

Intermediate

• Flat Illustrations
• Character Illustration Basics
• 3D & Advanced Gradient Techniques
• Logo Variations & Branding Shapes
• Vector Scene Building
• Complex Pen Tool Paths

5. Adobe InDesign

Basic

• Interface & Tools
• Text Frame & Image Frame
• Master Pages
• Basic Page Layout
• Simple Magazine Page

Intermediate

• Multi-page Documents
• Catalog & Brochure Layout
• Table & Grid Layout
• Image Wrapping
• Advanced Master Page Use
• Portfolio / Book Layout

6.Adobe Animate

Basic

• Timeline, Keyframes
• Motion & Shape Tween
• Basic Logo / Text Animation

Intermediate

• Character Rigging Basic
• Complex Motion Tweens
• Vector Animation
• Social Media Ad Animation
• Animated Banner Design

MODULE 4:(Web Designing (HTML + CSS + JavaScript))

Basic

• HTML Tags, Text, Images
• Links, Lists, Tables
• Forms & Inputs
• Basic CSS Styling

Intermediate

• Flexbox & Grid
• Responsive Website Design
• Navigation Bar
• Basic JavaScript Functions
• Image Slider / Form Validation
• Portfolio Webpage

MODULE 5:(TALLY WITH GST)

1. Introduction to Tally Prime

·     What is Tally Prime

·     Features of Tally

·     Tally interface & navigation

·     Company creation, alteration, deletion

·     Data backup & restore

2. Basic Accounting Concepts

·     Accounting terms (Assets, Liabilities, Income, Expense)

·     Debit & Credit rules

·     Accounting cycle

·     Double entry system

3. Masters in Tally

A. Accounts Masters

·     Ledger creation

·     Groups & classifications

·     Creating sundry debtors/creditors

B. Inventory Masters

·     Stock groups

·     Stock items

·     Units of measure

·     Godown creation

·     MANUFACTURING

·     ODER PROCESSING

·     SALE AND PURCHASE

4. Voucher Entries (Accounting)

·     Contra

·     Payment

·     Receipt

·     Journal

·     Sales

·     Purchase

·     Debit Note

·     Credit Note

5. Inventory Management

·     Stock entry

·     Purchase & sales with inventory

·     Item-wise, group-wise reports

·     Godown / warehouse management

·     Batch-wise inventory

·     DISCOUNT (ALLOWE AND RECEIVED) DIRECT

·     USE DIOSCOUNT COLUMN IN INVOICE SALE & PURCHASE SPREAT

·     ACTUAL AND BILED QUANTITY

6. GST (Goods & Services Tax)

GST Basics

·     CGST, SGST, IGST

·     Input & Output GST

·     HSN & SAC codes

·     GST slab setup

7 .GST in Tally

·     Enabling GST in Tally

·     GST ledger creation

·     GST invoice creation

·     Auto GST calculations

·     GST adjustment entries

·     GST reports

·     E-way bill basics

7. Banking

·     Bank ledger

·     Bank reconciliation (BRS)

·     Cheque printing & management

·     Payment/Receipt through bank

8. TDS Module

·     TDS basics

·     TDS ledger creation

·     TDS deduction entries

·     TDS reporting

9. TCS Module

• TCS basics

• TCS ledger creation

• TCS deduction entries

• TCS reporting

10. Payroll Module

·     Employee creation

·     Attendance setup

·     Salary structure

·     Salary slip generation

11. Financial Reports

·     Trial Balance

·     Profit & Loss Account

·     Balance Sheet

·     Cash/Bank Book

·     Outstanding Reports

·     Ratio Analysis

12. GST Return Preparation

·     GSTR-1

·     GSTR-3B

·     GSTR-2A checking

·     Exporting data for GST portal

13. Advanced Features

·     Cost Centers & Cost Categories

·     Budget & Controls

·     Interest Calculations

·     User Roles & Security

·     Data Audit

14. Practical Projects

·     Complete company setup

·     Daily accounting entries

·     GST billing project

·     Inventory & stock project

·     GST return project

• Final financial statements preparation

MODULE 7:(English Communication)

• Grammar
• Daily Use Sentences
• Basic Conversation
• Email Writing
• Group Discussion
• Public Speaking Practice

MODULE 8:(Personality Development)

• Confidence Building
• Introduction & Body Language
• Interview Skills
• Teamwork & Leadership
• Communication Skills