| Part Time | |
|---|---|
| Duration | 6 Weeks |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 3 Weeks |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 2 Weeks |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
CERTIFICATE COURSE IN TALLY
Introduction of Tally
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
Book Keeping
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
Financial Reports & Consolidate Ledger Accounts
- Balance sheet
- Profit & loss a/c
- Ratio analysis
Fund management with list of account
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
Mode of Invoice Punching/billing
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
Inventory Management
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
Purchase & Sales Order Processing
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
Internal Report of Finance
- Display (inventory books, day book, list of account)
- Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)
Controlling (Cost Center & Cost Categories)
- Cost centre
- Creation of cost centre
- Alteration of cost centre
- Cost categories
- Create cost categories
- Alter cost categories
Multi godown creation
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
Tax Deducted at Source (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
Tax Collected at Source (TCS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods and Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Budgets and Controls in Tally
- Budget
- Types of budget
Scenarios and Optional Vouchers
- Creation of scenario
- Alter or display scenario information
Export, Backup and Splitting company data
- Splitting company data
- Steps of splitting
- From tally to excel
- Importing into MS-excel
- Removing companies
- Copy companies
Printing Reports
- Printout of balance sheet, p&l a/c, ledger
- Printing Different Reports
- Sales Invoice
Multi-Currency
- Currency creation (How to create
- New currency & how to set the price Lists.
Point of Sales
- POS (Point of Sale)
Payroll Accounting Functions
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
Manufacturing Vouchers
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
Batch wise Details
- Batchwise Inventory
Interest Calculations
- Interest Calculations
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Voucher Types and Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
| Part Time | |
|---|---|
| Duration | 3.5 Months |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1.5 Months |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 3 Weeks |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
DIPLOMA IN TALLY with Taxation & E-filling
Module 1
TALLY
Introduction of Tally
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
Book Keeping
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
Financial Reports & Consolidate Ledger Accounts
- Balance sheet
- Profit & loss a/c
- Ratio analysis
Fund management with list of account
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
Mode of Invoice Punching/billing
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
Inventory Management
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
Purchase & Sales Order Processing
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
Internal Report of Finance
- Display (inventory books, day book, list of account)
- Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)
Controlling (Cost Center & Cost Categories)
- Cost centre
- Creation of cost centre
- Alteration of cost centre
- Cost categories
- Create cost categories
- Alter cost categories
Multi godown creation
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
Tax Deducted at Source (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
Tax Collected at Source (TCS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods and Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Budgets and Controls in Tally
- Budget
- Types of budget
Scenarios and Optional Vouchers
- Creation of scenario
- Alter or display scenario information
Export, Backup and Splitting company data
- Splitting company data
- Steps of splitting
- From tally to excel
- Importing into MS-excel
- Removing companies
- Copy companies
Printing Reports
- Printout of balance sheet, p&l a/c, ledger
- Printing Different Reports
- Sales Invoice
Multi-Currency
- Currency creation (How to create
- New currency & how to set the price Lists.
Point of Sales
- POS (Point of Sale)
Payroll Accounting Functions
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
Manufacturing Vouchers
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
Batch wise Details
- Batchwise Inventory
Interest Calculations
- Interest Calculations
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Voucher Types and Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 2
TAXATION
- Residential Status & Slab rate of Taxes
- Certain Incomes Exempt from Tax
- Income under Head Salary
- Income under the Head House Property
- Profit & Gains from Business & Profession
- Income under the Head Capital Gains
- Income under the head Other Sources
- Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
- Agricultural Income, Illustration on Computation of Total Income & Liability
- Assessment of Firms, Return of Income & Assessment of individual
- TDS/TCS-Types of Forms, return filing
- Tax Deduction of Source, Advance Tax,
- Interest, Refund, Penalty,
- Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
- Legal Documentation
- GST (GOODS AND SERVICE TAX)
- Legal Documentation For GST
Module 3 - E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
| Part Time | |
|---|---|
| Duration | 2 Months |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1 Month |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 3 Weeks |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
Certificate Course IN TALLY With A/C’s
Module 1
TALLY
Introduction of Tally
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
Book Keeping
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
Financial Reports & Consolidate Ledger Accounts
- Balance sheet
- Profit & loss a/c
- Ratio analysis
Fund management with list of account
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
Mode of Invoice Punching/billing
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
Inventory Management
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
Purchase & Sales Order Processing
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
Internal Report of Finance
- Display (inventory books, day book, list of account)
- Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)
Controlling (Cost Center & Cost Categories)
- Cost centre
- Creation of cost centre
- Alteration of cost centre
- Cost categories
- Create cost categories
- Alter cost categories
Multi godown creation
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
Tax Deducted at Source (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
Tax Collected at Source (TCS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods and Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Budgets and Controls in Tally
- Budget
- Types of budget
Scenarios and Optional Vouchers
- Creation of scenario
- Alter or display scenario information
Export, Backup and Splitting company data
- Splitting company data
- Steps of splitting
- From tally to excel
- Importing into MS-excel
- Removing companies
- Copy companies
Printing Reports
- Printout of balance sheet, p&l a/c, ledger
- Printing Different Reports
- Sales Invoice
Multi-Currency
- Currency creation (How to create
- New currency & how to set the price Lists.
Point of Sales
- POS (Point of Sale)
Payroll Accounting Functions
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
Manufacturing Vouchers
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
Batch wise Details
- Batchwise Inventory
Interest Calculations
- Interest Calculations
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Voucher Types and Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 2
ADVANCE MANUAL ACCOUNTING
- Activities and user of Accounting Information
- Accounting Terminology Assumption of accounting,
- Principal of Accounting, Accounting cycle and source /Accounting document,
- Accounting equation Classification of Account, Types of expenditure
- Compound entry
- Subsidiary book and types of book
- Trial balance and objectives
- Transfer
- Rectification
- Rectification of errors
- Bank Reconciliation Statement
- Provision & Reserve
- Depreciation
- Inventories & Cost for inventory Valuation
- Financial Statements
- Suspense Account
- Share capital of company
- Kinds of share
- Forfeiture of share
- Over Subscription and Pro-rata allotment,
- Ratio analysis
- Cash Flow Statements
- MIS Report
- Budget and Types of Budgets
- Accounting Standard
Module 3 - E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
| Part Time | |
|---|---|
| Duration | 2 Months |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1 Month |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 3 Weeks |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
Certificate Course IN TALLY With E-filling
Module 1
TALLY
Introduction of Tally
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
Book Keeping
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
Financial Reports & Consolidate Ledger Accounts
- Balance sheet
- Profit & loss a/c
- Ratio analysis
Fund management with list of account
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
Mode of Invoice Punching/billing
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
Inventory Management
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
Purchase & Sales Order Processing
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
Internal Report of Finance
- Display (inventory books, day book, list of account)
- Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)
Controlling (Cost Center & Cost Categories)
- Cost centre
- Creation of cost centre
- Alteration of cost centre
- Cost categories
- Create cost categories
- Alter cost categories
Multi godown creation
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
Tax Deducted at Source (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
Tax Collected at Source (TCS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods and Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Budgets and Controls in Tally
- Budget
- Types of budget
Scenarios and Optional Vouchers
- Creation of scenario
- Alter or display scenario information
Export, Backup and Splitting company data
- Splitting company data
- Steps of splitting
- From tally to excel
- Importing into MS-excel
- Removing companies
- Copy companies
Printing Reports
- Printout of balance sheet, p&l a/c, ledger
- Printing Different Reports
- Sales Invoice
Multi-Currency
- Currency creation (How to create
- New currency & how to set the price Lists.
Point of Sales
- POS (Point of Sale)
Payroll Accounting Functions
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
Manufacturing Vouchers
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
Batch wise Details
- Batchwise Inventory
Interest Calculations
- Interest Calculations
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Voucher Types and Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 2 - E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
| Part Time | |
|---|---|
| Duration | 2 Weeks |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1 Week |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 3 Days |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
Certificate Course IN E-filling
Module - E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
| Part Time | |
|---|---|
| Duration | 3 Months |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1.5 Months |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 1 Month |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
Certificate Course IN TALLY with Professionals Excel & E-filling
Module 1
TALLY
Introduction of Tally
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
Book Keeping
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
Financial Reports & Consolidate Ledger Accounts
- Balance sheet
- Profit & loss a/c
- Ratio analysis
Fund management with list of account
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
Mode of Invoice Punching/billing
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
Inventory Management
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
Purchase & Sales Order Processing
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
Internal Report of Finance
- Display (inventory books, day book, list of account)
- Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)
Controlling (Cost Center & Cost Categories)
- Cost centre
- Creation of cost centre
- Alteration of cost centre
- Cost categories
- Create cost categories
- Alter cost categories
Multi godown creation
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
Tax Deducted at Source (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
Tax Collected at Source (TCS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods and Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Budgets and Controls in Tally
- Budget
- Types of budget
Scenarios and Optional Vouchers
- Creation of scenario
- Alter or display scenario information
Export, Backup and Splitting company data
- Splitting company data
- Steps of splitting
- From tally to excel
- Importing into MS-excel
- Removing companies
- Copy companies
Printing Reports
- Printout of balance sheet, p&l a/c, ledger
- Printing Different Reports
- Sales Invoice
Multi-Currency
- Currency creation (How to create
- New currency & how to set the price Lists.
Point of Sales
- POS (Point of Sale)
Payroll Accounting Functions
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
Manufacturing Vouchers
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
Batch wise Details
- Batchwise Inventory
Interest Calculations
- Interest Calculations
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Voucher Types and Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 2 - E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
TDS/TCS Forms
- TDS/TCS Challan
- TDS 24Q
- TDS 26Q
- TCS 27EQ
Module 3
Prof. MS EXCEL
Mathematical & Statical Function’s
- Sum
- Product
- Average
- Ceiling
- Floor
- Round
- Round Up
- Round Down
- Power
- Count
- Counta
- Maximum
- Minimum
- Mode
- Median
- Log
- Dollar
- Average A
- Mina
- Maxa
- Large
- Sqrt
- Mod
- Roman
- Rank
- Rank Average
- Rand
- Rand Between
Logical Function
- If
- Nested if
- SumIf
- Sumifs
- Averageif
- Averageifs
- Countif
- Countifs
- Or
- Not
- And
- If error
- If Function & Nested If Statements And & Or Functions
- Maxifs
- Minifs
Text Function’s
- Upper
- Lower
- Left
- Right
- Exact
- Len
- Mid
- Concatenate
- Proper
- Trim
- Substitute
- Search
- Find
Date & Time Function’s
- Days360
- Date
- Network days
- Now
- Today
- Weekday
- Effect
- Eomonth
- Edate
- Workdays
- Datedif
Lookup &Reference Function’s
- Index
- Match
- Lookup
- Choose
- Offset
- Offset with Match
- Xlookup
- Transpose
- Hlookup For Single Worksheet
- Vlookup For Single Worksheet
- Hlookup & Vlookup For Multiple Sheet
- Match and Find Record by Vlookup And Hlookup
- Approximate Match with Vlookup
- Exact Match with Vlookup
- Nesting Lookup Function
- Show Formula
- Choose Function with Vlookup
- Indirect
Financial Function’s
- Pmt
- Rate
- Ppmt
- Ipmt
- Fv
- Pv
- Coupdays
- Coupnum
- Ispmt
- Sln
- Cumprinc
- Cumipmt
- Ddb
- Db
- Received
Database Function’s
- Daverage
- Dproduct
- Dmin
- Dmax
- Dcount
- Dsum
- Dget
Working with Charts
- Creating a Chart with the 2D or 3D
- Create Column Chart, Pie Chart
- Create Pateros Charts
- Create Speed- O-Meter Chart
- Moving a Chart One to another Sheet
- Resizing a Chart, Changing a Chart Type
- Editing Chart Text, Modifying Chart Options
- Formatting Category & Value Axis Data
- Formatting a Data Series
- Changing a Chart’s Source Data
Format Cells
- Cell Format.
- Data Bars, Color Scales & Icon Sets.
- Sorting basic.
- Sorting based on Customized List.
- Customized Sorting (Advanced).
Conditional Formatting with Rules & Color Scale
- Using Conditional Formatting
- Removing Conditional Formatting
- Format As table
- Create our Styles
- Conditional formatting with formulas
- Conditional formatting with Form Controls.
Data Management with Data Validation
- Data Validation and dealing with Invalid Data.
- Group and Outline Data
- Data Consolidation.
- Data text to column.
- Custom Views
Data Analysis
- Tracing Formula Precedents
- Tracing Cell Dependents
- Error Checking
Summarizing Data by Subtotal With grouping
- Adding Subtotals to a List
- Nesting Subtotals
- Adding Group & Outline Criteria to Ranges
- Using Data Validation
- Text to Column
What –If Data Analysis
- Using Goal Seek
- Using Data Table
- Creating & Displaying Scenarios
Sorting & Filtering
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
- Applying Advance Filters
Protecting Excel Workbook & Sheet
- Locking/Unlocking Cells in a worksheet
- Protecting a Worksheet
- Protecting a Workbook
- Creating a Shared Workbook
- Tracking Changes to a Workbook
- Accepting & Rejecting Changes to a Workbook
- Password Protecting a Workbook
- Merging Workbooks
Workgroup Collaboration
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
Customizing Macro by Action Button
- Creating a Macro with Condition
- Running a Macro, Editing a Macro
- Adding a menu to the Menu Bar
- Adding a Commands to a Menu
- Adding Buttons to a Toolbar
Working with Pivot Table & Pivot Chart
- Creating a Pivot Table
- Rearranging a Pivot Table
- Filtering Pivot Table Data
- Creating a Pivot Chart
Reporting with Payroll Statement
- MIS Report
- Profit & Loss a/c statement
- Balance sheet
- Worker contribution statement
- Cash flow statement
- Debtor’s & Creditors statement
- Inventory statement
- BRS Statement
- Fixed Assets & fund statement
- Payroll Report
- P.F & E.S.I Report
Advance Paste Special Techniques
- Paste Formula’s, Paste Formats
- Paste Validations
- Transpose Tables
- Paste data
Special Operation
- Find record by drop down list according To condition
- Dash Board
- Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
- Speed o Meter
Print Settings
- Page Break
- Print Area
- Print Titles
- Background
| Part Time | |
|---|---|
| Duration | 3 Months |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1.5 Months |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 1 Month |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
Professional Diploma in Tally
Module 1
TALLY
Introduction of Tally
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
Book Keeping
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
Financial Reports & Consolidate Ledger Accounts
- Balance sheet
- Profit & loss a/c
- Ratio analysis
Fund management with list of account
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
Mode of Invoice Punching/billing
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
Inventory Management
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
Purchase & Sales Order Processing
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
Internal Report of Finance
- Display (inventory books, day book, list of account)
- Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)
Controlling (Cost Center & Cost Categories)
- Cost centre
- Creation of cost centre
- Alteration of cost centre
- Cost categories
- Create cost categories
- Alter cost categories
Multi godown creation
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
Tax Deducted at Source (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
Tax Collected at Source (TCS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods and Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Budgets and Controls in Tally
- Budget
- Types of budget
Scenarios and Optional Vouchers
- Creation of scenario
- Alter or display scenario information
Export, Backup and Splitting company data
- Splitting company data
- Steps of splitting
- From tally to excel
- Importing into MS-excel
- Removing companies
- Copy companies
Printing Reports
- Printout of balance sheet, p&l a/c, ledger
- Printing Different Reports
- Sales Invoice
Multi-Currency
- Currency creation (How to create
- New currency & how to set the price Lists.
Point of Sales
- POS (Point of Sale)
Payroll Accounting Functions
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
Manufacturing Vouchers
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
Batch wise Details
- Batchwise Inventory
Interest Calculations
- Interest Calculations
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Voucher Types and Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 2
Advance Manual Accounting
- Activities and user of Accounting Information
- Accounting Terminology Assumption of accounting,
- Principal of Accounting, Accounting cycle and source /Accounting document,
- Accounting equation Classification of Account, Types of expenditure
- Compound entry
- Subsidiary book and types of book
- Trial balance and objectives
- Transfer
- Rectification
- Rectification of errors
- Bank Reconciliation Statement
- Provision & Reserve
- Depreciation
- Inventories & Cost for inventory Valuation
- Financial Statements
- Suspense Account
- Share capital of company
- Kinds of share
- Forfeiture of share
- Over Subscription and Pro-rata allotment,
- Ratio analysis
- Cash Flow Statements
- MIS Report
- Budget and Types of Budgets
- Accounting Standard
Module 3
TAXATION
- Introduction of Income Tax
- Residential Status and Incident of Tax
- Certain Incomes Exempt from Tax
- Income under Head Salary
- Income under the Head House Property
- Profit &Gains from Business& Profession
- Income under the Head Capital Gains
- Income under the Head Other Sources
- Clubbing of Income, set off & Carry Forward of Losses
- Deduction from Gross Total Income
- Agricultural Income
- Illustration on Computation of Total Income & Liability
- Assessment of Firms, Return of Income & Assessment of Individuals
- Tax Deduction of Source
- Advance Tax
- Interest
- Refund
- Penalty
- Goods Service Tax (GST)
- Tax Deducted at Source (TDS)
- Tax Collected at Source (TCS)
- Return filling(Manually)
Module 4 - E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
| Part Time | |
|---|---|
| Duration | 2 Months |
| Class | 1.5 Hrs. Daily |
| Days | Mon-Fri |
| Half Time | |
|---|---|
| Duration | 1 Month |
| Class | 3 Hrs. Daily |
| Days | Mon-Fri |
| Full Time | |
|---|---|
| Duration | 3 Weeks |
| Class | 4.5 Hrs. Daily |
| Days | Mon-Fri |
Certificate Course IN E-filling
Module 1
TAXATION
- Residential Status & Slab rate of Taxes
- Certain Incomes Exempt from Tax
- Income under Head Salary
- Income under the Head House Property
- Profit & Gains from Business & Profession
- Income under the Head Capital Gains
- Income under the head Other Sources
- Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
- Agricultural Income, Illustration on Computation of Total Income & Liability
- Assessment of Firms, Return of Income & Assessment of individual
- TDS/TCS-Types of Forms, return filing
- Tax Deduction of Source, Advance Tax,
- Interest, Refund, Penalty,
- Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
- Legal Documentation
- GST (GOODS AND SERVICE TAX)
- Legal Documentation For GST
Module 2- E-Filing
GST Forms
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
Income Tax Return Forms
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
Tally Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.
