EIFA-CERTIFIED
FINANCE PROFESSIONAL (CFP)
COMPUTER OPERATING & MANAGEMENT
Logical Functions, Data Management:-
Data Collection Method With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality
Analysis:-
Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table
Lookup and Reference Functions:-
Retrieve approximate matched value instead of position, find the value in the last non-empty cell in a row or column, etc.
How to retrieve the value at the position returned by MATCH & INDEX function?
How to map cell values directly to cell ranges
Retrieving value, based on a text string.
Mathematical Functions, Text Functions and Data Validation, Date & Time Functions:-
Storing and manipulating dates and times in Excel, inserting days and months to particular dates; create dynamic date-based fields; and perform complex time-based calculations.
Mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.
Advanced Chart, Graph and Dashboard:-
Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Advanced Sort &Filter, Validation and Pivot Table:-
Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split.
Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
INDUSTRIAL CORPORATE ACCOUNTING
-
An overview of Indian GAAP(Generally Accepted Accounting Principles) and Indian AS and its applicability on Finalization of accounts.
-
Real World demo of Grouping of Heads of income and expenses through trial balance.
-
Analysis of Balance Sheet and its components as per Revised Schedule of Companies Act 2013.
-
Logical Process of preparing balance sheet on Excel of a company registered under companies Act.
-
Comparative Analysis of provisions of Depreciation in Income Tax Act and Companies Act.
-
Bank Reconciliation Statement and its importance for finalization.
-
Year End Adjustment entries, Deferred Tax.
-
Practical demo on linking skill of cells in Excel and preparation Financial Statement on multi excel sheet with its other component.
-
Financial Analysis (how to read the financial accounts of a Company – important ratio analysis)
Tally Prime PLUS+
Accounting with GST in Tally Prime
-
Tally Gateway and its elements
-
Company formation
-
Working in Accounts Master in Tally Prime
-
Finalizing and reporting of various accounts books and financial statement
-
Working in Inventory Masters & Inventory Vouchers in Tally Prime
-
Generating Inventory Books and Reports
-
Introducing BOM – Bill of Materials
-
Setting Up GST Rates for Your Company
-
Working in Inventory items with effect of GST
-
Updating Party GSTIN
-
Creating GST Ledgers
-
Other Scenarios
-
Sales – Nil Rated, Exempt, SEZ, and Deemed Export
-
Working in Debit Note & Credit Note
-
Cost Accumulation & Cost Management
-
Recording Direct Cost & Indirect Cost
INVENTORY MANAGEMENT & ACCOUNTING
-
Management Reports
-
Aging stock Analysis
-
Batch-wise or lot-wise Inventory with Expiry
-
Re-Order Levels
-
Stock categories
-
Multiple godowns
-
Stock transfers to Locations/godowns
INDIRECT TAX LAWS
Overview of Model GST Law
-
Overview of Indirect Taxes & GST
-
Important Definitions under GST
Registration Structure under GST
-
When GST is required?
-
Voluntary registration & compulsory registration
-
Guidelines and principles in the process of Registration under GST
-
Amendment &Cancellation of Registration.
-
Various Forms for GST Registration
-
Practical case study of registration under GST from virtual documents.
GST charging sections
-
How GST is charged?
-
When GST is charged?
-
Where GST is charged?
-
On which goods & services GST will be charged?
-
Exempted services
Input Tax Credit - Section 16-21 with GST Rules
-
Eligibility and Conditions for taking ITC (Section-16)
-
Rules regarding Block Credit (Section-17)
-
Availability of Credit in Special Cases (Section-18)
-
Guidelines of ITC for Job Work (Section-19)
-
ITC Distribution by ISD (section-20)
Time of supply of Goods & Services
Place of supply of Goods & Services
Valuation of supply of Goods & Services
GST bills / E-Way bills / Accounts & records to be maintained in GST
-
How to generate E-way bills?
-
Concepts of HSN code, Turnover and many more…..
-
Journal entries of adjustment of ITC and many more……
Returns under GST Section (37-48) with GST Rules and Formats
-
Overview on return filing procedure, rules & formats
-
Types of Returns. (Annual Return, First Return, Regular Return)
-
Regulations & Actions for Return Defaulters.
-
Levy of Late Fee.
-
Various Return Form (GSTR-I, II ,III, 3B)
DIRECT TAX LAWS
Overview of IT law
How to apply PAN card
Practical cases of applying PAN card
COMPUTATION OF INCOME UNDER VARIOUS HEADS OF INCOME
Computation of income from Salary
-
Computation of Salary
-
Valuation of salary concerning Allowances (Exempted and Non Exempted) and Perquisites
-
Practical case studies of filing various IT returns for salaried person
Computation of income from House Property
-
How to compute income from House Property
-
Standard Deduction
-
Interest on borrowed capital
-
Practical case studies of filing various IT returns with income from House Property
Computation of income from Profit and Gains from Business Profession
-
Expenses Allowed and Expenses Disallowed
-
Rules regarding Depreciation and Additional depreciation
-
TDS Compliances and computation of business income
-
Set off and carry forward of Business Loss
-
Carry Forward of unabsorbed depreciation
-
Practical case studies of filing various IT returns under income from Business & Profession
Computation of income from Capital Gain
-
Introduction To Capital Assets, Holding Period and Transfer
-
Full Value Consideration, Cost of Acquisition
-
Capital Gain on Transfer of Shares and Debentures
-
Different Rates of Taxes on Capital Gain
-
Exemption under section 54, Set off and Carry Forward of capital loss
-
Practical case studies of filing various IT returns under income from Capital Gain
Computation of income from Other Sources
-
Income liable under other Sources
-
Deduction Available
-
Practical case studies of filing various IT returns under income from other sources
INCOME TAX RETURN PREPARATION
E-filing & uploading of various returns
Tax planning
Various deductions & rebate to save tax with Practical case studies
PLANNING & COMPUTATION OF INCOME TAX
-
Tax Planning by Understanding Your Pay slip
-
Objectives of Tax Planning
-
Types of Tax Planning
-
Results of good tax planning
E-COMMERCE ACCOUNTING
-
Place of Supply for E-Commerce
-
E-commerce benefits both customers and sellers
-
Registration Procedure under GST for E-Commerce
-
Issues faced by the E-Commerce Sector in present scenario
-
GST Return Filing for E-Commerce
BANKING AND FINANCE
-
Introduction to Banking
-
Retail Banking
-
Wholesale Banking
-
KYC Norms
-
How to Get Various Types of Loan Like CC, OD, Housing Loan, Mortgage Loan Etc.
-
Project Analysis
-
Risk Management
-
MIS Reporting
-
Record Keeping of Banks
-
Project
INSURANCE
-
Overview
-
Life Insurance
-
General Insurance
-
Health Insurance
-
Reinsurance
-
How to Start Insurance Business
Advance Excel
-
Advance Number Formatting
-
Advance Conditional Formatting
-
Match & Index
-
Financial Functions
-
Array Formulas
-
Power Pivot
-
Power View
-
Power Map
-
Power Query
-
Dashboard
-
Macro
-
Google Drive
-
VIVA
Advance Accounting
-
Accounts Reconciliation
-
Bank Reconciliation
-
Advanced Journal Entries
-
Ledger Scrutiny
-
Accounts
-
Finalisation
-
Company Final Accounts
Formation of Society & Trust
-
Overview of Society & Trust
-
Rules & Regulations of Society & Trust
-
Co-Operative Society
-
Charitable Society
-
Registration of Society & Trust
-
Retirement or Joining of a Member & Trustee
-
How to Make Changes
-
Public Trust
-
Charitable Trust
-
Project
ESI & Provident Fund
-
Basic Concept of ESI & PF
-
Applicability
-
Employees Contribution
-
Employer's Contribution
-
Methods of Payment
-
Maintenance of Register under ESI & PF
-
Returns
-
Penalties
-
Benefits to Employee & Their Family
-
Exemptions
-
Project
Business Communication & Interview Preparation
-
Resume Building
-
Workplace Etiquette
-
Interper-Sonal Skills
-
E-mail Etiquette
-
Interview Skills
-
Goal Setting & Time Management
Personality Development
-
Meeting People
-
Asking Questions
-
Holidays Getaway
-
Food for thought
-
Making Friends
-
Buying Things
-
Home Improvement
-
Know Your Planet
-
Better Than the Best
-
Leisure Time
-
Who's This