MODULE-1(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-2(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