LSF Professional Club presents- 100 hours training and workshop on –
- Income Tax & VAT Management (including major changes in Finance Bill/Act 2023) (30 hours)
- MS Excel (From beginners to Advanced Level) & MS Power BI (30 hours)
- Practical Accounting & Finance for all professionals (24 hours)
- Soft Skills and Communication Skills (16 hours)
Program duration and Timing: 6 Months l 100 hours l 24 weeks l 4 hours a week l 8-10/10.30 pm l Online l
Course benefits:
- 100 plus hours of practical training and mentoring
- Professional networking and corporate grooming, our existing members are working for leading local and MNCs
- To develop competencies and knowledge by learning beyond the classrooms, we connect and empower professionals by integrating classroom learning with practical experiences acquired from the fields
- We are aiming to create, support, promote, inspire, and enable current and emerging leaders to perform at their best for making direct impacts at their workplace.
- Provide certificates after finishing each course duly completing the assignments by the learners
Eligibility
Employees working in accounts, treasury, Tax, VAT, MIS, risk management, recovery, commercial, banking, costing, budgeting, planning, ERP, supply chain, corporate secretariat departments & entrepreneurs.
Investment: BDT12,000; Early bird registration: BDT10,000 if payable in two instalments or BDT8,000 if payable in one time by 31 May 2023.
Will start from 6 June 2023
Facilitators: Highly Experienced professionals from the diversified fields
Details Course Content:
Part A:
Income Tax & VAT Management (including major changes in Finance Bill/Act 2023) (30 hours)
- Individual Tax Assessment with examples;
- About Corporate Tax
- TDS/Withholding Tax
- Corporate Tax Assessment with examples
- VAT & SD Act 2012 & VAT & SD Rule 2016
- Important definition and Coverage of VAT
- VAT Imposition Stage& Calculation of VAT at Import Stage
- Input Output Coefficient with examples
- Major Changes in Tax- Finance Bill/Act 2023
- Major Changes in VAT- Finance Bill/Act 2023
- VAT registration, Scope of VAT & VAT Rates
- Name of Deduction Authorities and VDS/Withholding VAT
- VAT- Different Forms with Examples
- Carry forward of negative balance
- Increasing and decreasing adjustments
- VAT Return with Examples
- Penalty for non-compliances or irregularities
- Appeals, Revisions & ADR
- Offence and Punishment
Part B:
Microsoft Excel (From beginners to Advanced Level) & Microsoft Power BI (30 hours)
- Interface with MS Excel, Cell formatting& Aggregate Functions
- Financial and Statistical Functions
- Sorting, filtering& Advance Search
- File Protection, Error Handling and Cleaning Data
- Decorate Your Report Using Advanced Conditional Formatting
- Lookup and References, Array Formulas and Advanced use of Array Functions
- Proofing your reports, INDEX, Match, Data validation and consolidation
- Describe Your Data Using PivotTable with Slicers and PivotChart
- Goal Seek, Scenario Manager and Data Table
- Dynamic Graphical Presentation
- Power Query (Import & Cleaning Messy Data)
- Introduction to Business Intelligence
- Power Bl Desktop (Creation of Dashboard)
- Power Bl Service (Dynamic Reporting)
Part C:
Practical Accounting & Finance for all professionals (24 hours)
- Key Financial Statements Preparation and Analysis
- Cash Conversion Cycle and Cash Management
- Cash Budget, Master Budget and Capital Budgeting
- Corporate and treasury fund management
- Ratio Analysis
- Cost & Cost Management
Part D:
Soft Skills and Communication Skills (16 hours)
- Key Soft Skills in Finance & Accounting Career
- Communication and Leadership Styles
- Emotional Intelligence at the Workplace