Advance Diploma in Financial Accounting & Taxation
Accounting, Finance & Taxation are the field in which there will never be recession, this is an ever-growing field to make career as professional. Every organization small or big irrespective of number of employees and individual business man need professionals of accounts, finance and taxation.
₹70000.00 ₹114900.00 39% OFF
/CourseBundles(26794)/2719556-excelinstitutecourses_(15).jpg)
What You’ll Learn
- Fundamental Introduction
- Entering and editing worksheet data
- Essential worksheet Operations
- Working with Cell and Ranges
- Introduction of Table
- Introduction of Formulas and Functions
- Worksheet Formatting
- Workbook Operations
- Designing Excel
- Templates
- Printing Work
- Basic Functions of excel
- Working with data
- Data Formatting
- Customisation of software
- Functions of excel
- LEN, UPPER, LOWER, PROPER
- List Sort & Filter
- Multi- Level of Sorting
- Creating Formulas that Manipulate Text
- Creating formulas that lookup values
- MIS with Pivots Tables
- MIS with Xlookup Function
- Types of Charts
- Conditional Formatting
- Special Paste content
- Protect Workbook
- MIS Structure
- Use of Data Validation
- Dashboard
- Formulas for Financial Application
- Performing spreadsheet what-if analysis
- Count and sum Functions
- Macro
- Using Data Validation
- Using Excel in a workgroup
- Analysing data with pivot table
- Making Worksheet error free
- Dashboard in Excel
- Share
- Formulas and Functions
- Logical Functions
- Date & Time Functions
- Text Functions
- Statistical Functions
- Round Function
- About Tally Software
- Basics of Tally
- Accounting Masters creation
- Accounting Entries
- Inventory Management
- Purchase process
- Sales Process
- Banking
- Accounting with Services
- Data Maintenance & Exchange
- Reports Working
- Tax Deducted at Source
- Depreciation
- Additional Concepts Under tally
- Implementation GST for Company
- GST Concepts under Tally
- Types of Goods & services under GST
- Types of Purchase under GST
- Reverse charge mechanism (RCM)
- Record of sales under GST
- TDS With GST
- GST Payment to Government
- Record GST For Goods
- Record GST For Services
- GST Reports
- Bad Debt
- GST Challan Updating
- Depreciation
- Provision
- Advance Depreciation
- E-Way Bill
- Godown Summery
- GST Advance Receipt
- GST For Composition Dealer
- Import
- Export
- Transportation Services
- GST Adjustment
- GST For ineligible ITC goods & Services
- HSN/ SAC Summery for GSTR1
- TDS Report
- Important Reports Work
- Payroll Accounting
- Tally Vault
- Tally Audit
- Individual GST Briefing
- Goods and services Tax Network (GSTN)
- Basic concept
- GST Registration
- Tax Invoice
- Levies and Tax Applicability
- Input Tax Credit Avail ITC Block ITC
- GST Portal Login
- Eway Bill
- HSN Code
- GSTR – 1
- GSTR - 2A
- GSTR - 2B
- GSTR - 3B
- GSTR - 4
- GSTR - 5
- GSTR - 6
- GSTR - 7
- GSTR - 8
- GSTR - 9
- GSTR - 9C
- GSTR - 10
- GSTR - 11
- Import and Export
- Tax Management
- GST Offline tools
- Many More…
Income Tax Act Basic
- Introduction of Income Tax
- Basic Concepts and Definitions
- Capital and Revenue Receipts
- Basis of Charge and Scope of Total Income
- Residential Status and Incidence of Tax
Income Tax E-filing
- Online Registration of PAN
- Computation and Filing of ITR01
- Computation and Filing of ITR02 (Income from House Property)
- Computation and Filing of ITR02 (Income from Capital Gain and Agriculture)
- Computation and Filing of ITR03
- Computation and Presumptive Income and Filing of ITR04
- Computation and Partnership Firm and Filing of ITR05
- Computation and Companies Return and Filing of ITR06
Tax Management, Administrative Procedure
Payroll & Income Tax
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy