IIRF Online > Finance & Accounting > Accounting & Bookkeeping > TallyPrime (Tally.ERP) > TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack)
TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack) by Udemy
A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Tax Professional, Auditors n Bsns Management sectors
Course Highlights
- TallyERP9 and TallyPrime
- GST & GST Portal Concepts
- Income Tax & TDS, TCS
- Payroll Management
- E-Way bill, E-Invoice, MS Excel
- Tally - Introduction, History, Advantages
- Costing of Tally
- TallyERP9 - Download , Install , Activation
- Golden Rules of Accounts
- Tally ERP9 with GST - Course Material
- Company-Creation, Alteration, Deletion & Securing
- Understanding Tally Pre-defined Vouchers
- Tally Data Processing Structure
- Understanding Tally with Basic Illustrations
- Recording & Maintaining Installments in Tally ERP9 I Bill-wise Accounts
- Recording & Maintaining Supply against Advances - Advances Management
- Tracking OverDue Supply - Credit Sales
- Multi-Currency Accounting in Tally ERP9 & Adjustment Entries for Forex GainLoss
- Cheque Book Configuration in Tally ERP9
- Banking - Transaction Types
- Post Dated Cheques Management in Tally ERP9 I PDC's
- Bank Reconciliation Introduction
- Bank Reconciliation in Tally ERP9 Practical I Case Study 1
- Bank Reconciliation In in Tally ERP9 I Case Study 2
- GST Revenue Sharing Ratios between Center & State Govt's
- GST Classifications
- Enabling GST Features in Tally ERP9
- Recording GST Transactions SMART RECORDING METHOD
- Recording GST Transactions TRADITIONAL METHOD
- Recording GST Transactions - CaseStudy 2
- GST Tax Invoice Configuration - Voucher Numbering
- Recording GST Transaction with Auto-Billing
- GST Tax Invoice, Bank Details-Cus Seal &Signature, Jurisdiction -Printing Confin
- Rate Inclusive of GST I Enabling Item Description in Tally ERP9
- Recording GST Transactions - Services
- Recording GST Transactions - Assets I with Input Tax Credit I without ITC
- Recording GST Transactions - Expenses with & without Input Tax Credit
- Recording GST Transactions - Sales with Additional Expenditure
- Genarate E-Way Bills Creation, Alter & Cancellation Online Offline methods
- GST- Recording RCM in Tally ERP9
- GST Overview Introduction
- Key Points about GST Council
- Introduction to GST Returns
- GSTR - 3B Filing
- GSTR-1 Filing ( GST-Regular) Offline Online Methods Explained with Live Data
- GST Registration - Live (Case Study 1)
- GST Registration - Filing Clarifications
- GST Registration - Tracking Submitted Applications
- Viewing Submitted Applications - GST Registration
- GST Registration - Core Filed Amendments
- GST Registration - Non-Core Filed Amendments
- GST Application for Refund
- GST Registration -CANCELLATION
- GST Tax Practitioner Registration
- Opting Withdrawal of Composition Levy in GST Portal
- What is TDS ( Tax deduction at source ) - How to calculate TDS - Introduction
- How to Configure TDS in Tally ERP9 & Recordinng TDS Entries in Tally
- Recording TDS Transaction in Tally ERP9
- Purchase Returns & Sales Returns in Tally ERP9
- Delivery Notes & Receipt Notes in Tally ERP9
- Sales Orders Quotations in Tally ERP9
- Tally ERP9 Discounts I Trade Discounts & Cash Discounts
- PriceList's in Tally ERP9 I Party Level & Product Level
- Auto-Interest Calculation on Overdue Installments
- Basic of Manufacturing
- Standard Manufacturing Practicals in Tally ERP9
- Cost Centres in Tally ERP9 (Departments Handling)
- Branch-Wise Accounts-Using Cost Centers & Godowns in Tally ERP9
- Multi User Creation in Tally ERP9
- Security , Password for Users in Tally ERP9
- Tally Internal Data Verification & Tally Audit
- Recording - Year End Adjustments in Tally ERP9
- Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split
- Payroll - in Tally ERP9 Introduction to Steps
- Payroll-Complete Setup Monthly Process & Stop Computation - Overall Coverage
- Budgets in Tally ERP9
- Calculator Usage in Tally ERP9
- Tally Data Backup & Restore
- Alternate Units of Measurement in Tally ERP9
- GSTR1 GSTR3B New Due Dates Late fee Updates (Feb-Mar-Apr-May) 2020
- Batches Management (with Date of Manufacturing & Expiry )
- Data Searching in Tally ERP9
- DayBook Features in Tally ERP9
- POS in Tally ERP9
- Splitting in Tally ERP9
- Part Numbers in Tally ERP9
- Standard Rate Setup in Tally ERP9
- Zero Valued Transactions
- Export to Excel, JPEG, PDF, HTML
- DATA Export & Import in Tally ERP9
- Live Mailings from Tally ERP9
- Tax Audit Due Date Extention
- Reply to Students Request Refund Applied I Deducted on GSTN INot Credited2 bank
- Reply to Students Request Know Your PAN Status
- Budget 2020 I Highlights I Income Tax Slabs I New & Old I Benefits
- 37th GST Council meeting I 2 major decisions I Relaxtion of Filing GSTR-9 &+more
- Highlights of 38th GST Council Meeting
- Microsoft Excel - Beginner to Advanced A Master Pro Course An Introduction to Microsoft Excel
- How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Cells
- MS Excel - Copy Cells, Move Cells
- Learn How to Create Tabs, Groups and add Toll to it in MS Excel
- MS Excel - Home Tab - Group Clipboard Features Functions Explained
- MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
- Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
- MS Excel - Characteristics of Cell
- Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
- MS Excel - Fill Series - with formatting, without formatting & more
- Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add,
- Fill Series - Flash Fill
- Excel - Editing Data I over writing I Go to I find & replace I undo & redo
- MS Excel - Text to Columns
- MS Excel - Comments - add, edit, delete & Show all
- MS Excel - How to Hide and Unhide Rows, Columns, Sheets
- Freeze Panes - Top Row, Columns & Multiple Rows & Columns
- MS Excel - Filters - Learn How to Use Filter to analyse Big Data
- MS Excel - Split Sheet Window
- MS Excel - How to Insert & Delete Cells, Rows, Columns
- MS Excel - Working with Sheets
- MS Excel - Format Multiple Sheets at a time I Sheet Formatting
- MS Excel - View Sheets Side by Side from One Excel File
- MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
- MS Excel - Sheet & Cells Protection
- MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
- Concatenate - Join Multiple Text Strings into ONE
- MS Excel - Trim Functions - Remove unnecessary Elements from strings
- MS Excel - Print Formulas Left, Right, Middle
- MS Excel - Date Related Formulas
- MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
- MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
- MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
- MS Excel - Create & Remove Drop Down List
- Introduction to Data Validation - Time limitation
- Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
- Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Inform-
- Data Validation - Dependent - Multiple Drop Down Lists
- MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
- MS Excel - Import Data from Websites - Live Data
- MS Excel - Import Data from Text Document - with Auto Refresh
- MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
- MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
- MS Excel - Charts - Columnar, Bar, Line Charts
- Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I
- Logical Test - IF Function
- Logical Functions - Nested IF - Learn How to work with Nested if Formula
- Logical Functions - AND function
- Logical Function - Not & IFERROR
- MS - Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Mu
- Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Av
- MS Excel - 3D Sum I Calculate Multiple Sheet Data at a time
- MS Excel - Consolidate ( 3d Sum extension)
- Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula
- Formulas - sumproduct, mround, floor, ceiling
- Index Formula - Find a Position of the Value, and Call cells references
- Match Formula - Find Position of the Value
- MS Excel - Age Calculator in Multiple Ways - Exclusive formula
- StudentMark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
- V Lookup - Introduction
- V Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
- H Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
- X Lookup - Introduction
- Download, Add & use X Lookup New Formula in MS Excel
- X Lookup New Formula in MS Excel
- Pivot Table Introduction & Basics of Pivot Table
- Create a Pivot Chart from Table & Pivot Table
- Pivot Table - Use slicers to filter data
- Pivot Table, Charts, Progress Dashboard
- MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
- Working with Tables
- Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Date Valid
- Share a workbook with Co Authors, Employees or with Anyone
- Commission Calculation in MS Excel
- Attendance Sheet Preparation in MS Excel
- Salary Calculation with CA, DA, Commission, Advance, PF, ESI
- Excel to SMS
- Macros
- VBA
Skills you will learn!
Curriculum
7 Topics
S1.1 What is Commerce
S1.2 What is Accounting Why do we need it
S1.3 Double Entry Accounting System Steps Structure
S1.4 Golden Rules of Accounts
S1.5 Rules of Accounts with Journals
S1.6 Fundamentals of Accounting
Quiz-1
2 Topics
S2.1 Download Link Here
S2.2 Tally Certifications awareness
14 Topics
S3.1 Overview on Tally - History Advantages Releases
S3.2 TallyPrime - Licnese Modules and Pricing
S3.3 Tally Rental License Request
S3.4 Download and Installation Update TallyPrime
S3.5 TallyPrime-Launching Working in Education Mode Licensing Operations
S3.6 TallyPrime-Company Creation Alteration and Deletion
S3.7 TallyPrime-Predefined Vouchers Introduction
S3.8 Recording Purchases & Sales
S3.9 Recording Contra Receipt and Payment Vouchers
S3.10 Recording Journals in TallyPrime
S3.11 How to update Opening Balances & Opening Stock in TallyPrime
S3.12 TallyPrime-Group Company-Creation Alteration and Deletion
S3.13 TallyPrime-Data Entry Steps - Ledgers Items and Vouchers
Quizzes for S3
14 Topics
S4.1 What is GST-a short Introduction to GST
S4.2 GST Classifications and Place of Supply
S4.3 Recording GST Purchases & Sales – Traditional Method
"S4.4 Recording GST with Auto Billing Exclusive GST Ledgers for Input n Output
"
S4.5 Billing Configuration – Company Logo
S4.6 Billing Configuration – Additional Description for Stock items & Ledgers
S4.7 Billing Configuration – Enable Rate Inclusive of Taxes column
S4.8 Billing Configuration – Update Sales Voucher Numbering
S4.9 Printing Preferences-Cust Seal and Signature Jurisdiction Bank Details I
S4.10 Optimize Printing Paper Size
S4.11 Recording GST Services I Sales and Purchases of Services in TallyPrime
S4.12 Recording GST Expenses Claimable and Non-claimable
S4.13 Recording GST Assets – claimable and non-claimable
Quizz for S4
20 Topics
S5.1 Understanding GST Returns & Types
S5.2 GST Tax Computation and Adjustments
S5.3 Learn GSTR-1 Tables
S5.4 GSTR-1 Filing using TallyPrime
S5.5 Filing Nil-GSTR-1 I when there is no Sales
S5.6 GSTR-1 Amendments I Modify Previous Months Invoices
S5.7 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods
S5.8 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary - Adjustments
S5.9 E-Way Bill-Registration
S5.10 E-WAYBILL Generation Cancellation Update and more
S5.11 E Invoice Introduction
S5.12 E-Invoice - GSTIN Registration of E Invoice Portal
S5.13 E-Invoice Enablement for GSTIN on E Invoice Portal
S5.14 E-Invoice - API User Creation for Your Accounting Software
S5.15 Generate E-Invoice using Tally - Generate and E-Invoice Print within Tall
S5.16 E - Invoice Cancellation in Tally as well as E-invoice Portal
S5.17 E-Invoice Generation - Tally to JSON JSON Manual Upload on E Invoice Por
S5.18 E-Invoice Generation Using Official Excel kit - Excel to JSON JSON upload
S5.19 GST Composition scheme introduction Slabs Eligibility
S5.20 GST CMP-08 Filing - Composition GST Return Filing
20 Topics
S6.1 Inventory Management - Introduction Importance Advantages
S6.2 Creation of Unit of Measurement
S6.3 Stock Group - Creation and Alteration
S6.4 Stock Category - Creation and Alteration
S6.5 Stock Items - Creation and Alteration
S6.6 Activation of Batches for Stock Item
S6.7 allocation of batch details in purchase invoice
S6.8 selling of stock items from batch and identifying of expired batch in sales
S6.9 Returning of Expired Batch Stock Item
S6.10 Activating Price Levels
S6.11 defining price levels creating price list usage of price list in sale vo
S6.12 Revise Price List
S6.13 Different Types of Inventory Valuations
S6.14 Activation of Purchase Order and Sales Order
S6.15 Activation of Delivery & Receipt Notes
S6.16 Activation of Debit & Credit Note
S6.17 purchases management - purchase order receipt note purchase purchase re
S6.18 Sales Management - Sales Order Delivery Note Sales Sales Return
S6.19 Creation of Godown
S6.20 How to Create and Manage Multiple Godowns in TallyPrime
6 Topics
S7.1 Bill-wise Accounts - An Introduction
S7.2 Bill-wise Accounts - Purchases
S7.3 Bill-wise Accounts - Sales
S7.4 Bill-wise Accounts - Tracking Overdue Supplies
S7.5 Bill-wise Accounts - Advances Management
S7.6 How to view and analyse bills outstanding reports in tallyprime
9 Topics
S8.1 Cheque book configuration in tallyprime
S8.2 Cheque Printing in TallyPrime
S8.3 Enabling All Banking Transaction Types
S8.4 An introduction to post dated cheques management
S8.5 Post dated cheques management in tallyprime
S8.6 Applying for TallyPrime License
S8.7 Introduction to bank reconciliation process in tallyprime
S8.8 Bank reconciliation in tallyprime
S8.9 How To Do Auto-Bank Reconciliation
6 Topics
S9.1 Calculator Usage in TallyPrime
S9.2 Alternative unit of Measurement
S9.3 Part Numbers in TallyPrime
S9.4 Standard Rate Setups in Tallyprime
S9.5 Export Reports from Tally I Excel PDF JPEG
S9.6 Group Company - Creation Alteration
6 Topics
S10.1 Golden Rules of Accounts Treatment Statements
S10.2 Capital and Drawings Related Adjustments
S10.3 Party Related Adjustments - Settlement Discounts Bad debts Reserves
S10.4 Appreciation and Depreciation related adjustments
S10.5 Prepaid and Outstanding related adjustments
S10.6 TallyPrime Closing - Backup Split Company Setup New FY
1 Topic
S11.1 Tally Test Paper-1 Comprehensive Case Study - Recap
25 Topics
S12.1 What is Payroll I An Introduction
S12.2 What is Basic Salary methods of calculating basic salary
S12.3 What is DA methods of Calculating DA
S12.4 What is HRA how to Calculate HRA Taxability and Exemption Calculation
S12.5 Payheads CA TA LTA I Conveyance Allowance I Travel Allowance I Leave TA
S12.6 EPF I Employee Provident Fund I Calculation I Employee and Employer Contri
S12.7 ESI I Employee State Insurance I Rules I Percentages I Contribution Period
S12.8 What is Gratuity I Calculation of Gratuity I Taxability I Ceiling Limit
S12.9 Bonus Act 1965 I What is Bonus How to Calculate Taxability
S12.10 Income Tax on Salary I TDS Computation Cess Surcharges Salary Incremen
S12.11 Professional Tax - Stat-wise I Applicability I Slabs
S12.12 CTC vs Gross Salary vs Net Salary
S12.13 Attendance Sheer Preparation I Present Paid Leaves Absents Holidays us
S12.14 Complete Payroll Processing I Basic DA HRA CA TA LTA Bonus PF ESI
S12.15 PaySlip Generation from Paysheet in MS Excel
S12.16 TDS Deposit on Income Tax Portal
S12.17 Employer Contributions PF ESI
S12.18 EPFESI Establishment Registration
S12.19 Add - Exit of Employee Records on EPFO website
S12.20 EPF Returns Preparation Filing
S12.21 EPF Nil Return Filing
S12.22 How to Add Employee in ESI website I generate IP Number
S12.23 ESI Returns Preparation and Filing
S12.24 Comprehensive Case Study - TDS ON SALARY P1- Payroll and TDS Deposits
S12.25 Comprehensive Case Study - TDS ON SALARY P2 - TDS Returns Filing 24Q
31 Topics
S13.1 What is GST-a short Introduction to GST
S13.2 GST Classifications and Place of Supply
S13.3 Understand GST Number
S13.4 GST Registration Threshold Limits and Documents Required for GST Registrat
S13.5 GST Registration-Proprietorship and Partnership
S13.6 Track Submitted Application Status
S13.7 GST Registration - Filing Clarifications
S13.8 GST Practitioner Registration
S13.9 How to Download GST Certificate
S13.10 GST Amendments- Core Fields and Non Core Fields
S13.11 GST - Opting Regular or Composition
S13.12 GST Cancellation and Revocation
S13.13 What is GST Returns Types of GST Returns
S13.14 Learn GSTR-1 Tables
S13.15 GSTR-1 Filing using TallyPrime
S13.16 Filing Nil-GSTR-1 I when there is no Sales
S13.17 GSTR-1 Amendments I Modify Previous Months Invoices
S13.18 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods
S13.19 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary - Adjustments
S13.20 GST Composition scheme introduction Slabs Eligibility
S13.21 GST CMP-08 Filing - Composition GST Return Filing
S13.22 GST Refund- Compete Process
S13.23 How to Generate E-way bill Registration Print Cancellation Masters Cr
S13.24 E Invoice Introduction
S13.25 E-Invoice - GSTIN Registration of E Invoice Portal
S13.26 E-Invoice Enablement for GSTIN on E Invoice Portal
S13.27 E-Invoice - API User Creation for Your Accounting Software
S13.28 Generate E-Invoice using Tally - Generate and E-Invoice Print within Tal
S13.29 E - Invoice Cancellation in Tally as well as E-invoice Portal
S13.30 E-Invoice Generation - Tally to JSON JSON Manual Upload on E Invoice Po
S13.31 E-Invoice Generation Using Official Excel kit - Excel to JSON JSON uploa
92 Topics
1. Tally.ERP9 with GST and Excel Combo Pack Intro Video
2. Tally.ERP9 Download - New Portal
Tally.ERP9 with GST Practice Tests1
3 Tally - Introduction History Advantages
4. Costing of Tally
5. Tally.ERP9 Downloading Installation & Activation
6. Golden Rules of Accounts
Quiz-1 Fundamentals
7. Tally.ERP9 with GST - Course Material
8. Company - Creation Alteration Deletion & Securing
9. Understanding Tally Pre- defined Vouchers
10. Tally Data Processing Structure
Quiz 1
11. Understanding Tally with Basic Illustrations
12. Recording & Maintaining Installments in Tally.ERP9 I Bill-wise accounts
13. Recording & Maintaining Supply against Advances- Advances Management
14. Tracking OverDue Supply - Credit Sales
15. Multi - Currency Accounting in Tally.ERP9 & Adjustment Entries of Forex Gain
16. Cheque Book Configuration in Tally.ERP9
17. Banking - Transaction Types ATM Credit & Debit Cards Online Banking & more
Quiz-- Tally Basics Bills receivable Bills Payable & Banking
18. Post Dated Cheques Management in Tally.ERP9 I PDC's
19. Bank-Reconciliation-Introduction-Theory
20. Bank-Reconciliation-in-Tally.ERP9-I-Practical-CaseStudy1
Quiz 2
21. Bank Reconciliation in Tally.ERP9 I CaseStudy2
24. Enabling GST Features in Tally.ERP9
25. Recording GST Transactions in Tally.ERP9 I SMART method
26.Recording-GST-Transaction Traditional-Method
27. Recording GST Transactions - CaseStudy2
28. GST Tax Invoice Configuration - Voucher Numbering
29. Recording GST Transaction with Auto Billing
30. GST Tax Invoice Bank Details Customer Seal Signature Jurisdiction - Print
31. Rate Inclusive of Tax Item Description in Tally.ERP9
32. Recording GST Transactions - Services
33. Recording GST Transactions - Assets I with Input Tax Credit I without ITC
34. Recording GST Transactions - Expenses with & without Input Tax Credit
35. Recording GST Transactions - Sales with Additional Expenditure
37. GST- Recording RCM in Tally.ERP9
Tally with GST Quiz
Quiz 3
55. Recording TDS Transaction in Tally.ERP9
54. How to Configure TDS in Tally.ERP9 & Recordinng TDS Entries in Tally
56. Purchase Returns & Sales Returns in Tally.ERP9
53. What is TDS ( Tax deduction at source ) - How to calculate TDS - Introductio
57. Delivery Notes & Receipt Notes in Tally.ERP9
58. Sales OrdersQuotations in Tally.ERP9
Quiz 4
59. Tally.ERP9 Discounts I TradeDiscounts & Cash Discounts
60. PriceList's in Tally.ERP9 I Party Level & Product Level
61. Auto-Interest Calculation on Overdue Installments
62. Basic of Manufacturing
63. Standard Manufacturing Practicals in Tally.ERP9
64. Cost Centres in Tally.ERP9 (Departments Handling)
65. Branch-Wise Accounts-Using Cost Centers & Godowns in Tally.ERP9
66. Multi User Creation in Tally.ERP9
67. Security Password for Users in Tally.ERP9
68. Tally Internal Data Verification & Tally Audit
69. Recording - Year End Adjustments in Tally.ERP9
Quiz 5
70. Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Spli
71. Payroll - in Tally.ERP9 Introduction to Steps
72. Payroll-Complete Setup Monthly Process & Stop Computation - Overall Coverag
73. Budgets in Tally.ERP9
74. Calculator Usage in Tally.ERP9
75. Tally Data Backup & Restore
76. Alternate Units of Measurement in Tally.ERP9
77. Batches Management (with Date of Manufacturing & Expiry )
78. Data Searching in Tally.ERP9
79. Day Book Features in Tally.ERP9
Quiz 6
80. POS in Tally.ERP9
81. Splitting in Tally.ERP9
82. Part Numbers in Tally.ERP9
83. Standard Rate Setup in Tally.ERP9
84. Zero Valued Transaction
85. Exports I Tally to JPEG PDF HTML XML
86. Data Export & Import in Tally.ERP9
87. Live Mailing from Tally.ERP9
88. Tax Audit Due Dates Extended
89. Logo Printing in Tally.ERP9
Quiz 7
90. Reply to Students Request Refund Applied I Deducted on GSTN INot Credited2 b
92. Budget-2020-I-Highlights-I-Old-New-Slabs
93. 37th GST Council meeting I 2 Major decisions I Relaxation of filing GSTR-9 &
94. Highlights-of-38th-GST-Council-Meeting
96. Item Description in Tally.ERP9 - without instructor
97. JobOrderProcessing-in-Tally-Application
98. Tally Certifications - Student Dashboard & Job Portal Benefits
99. Tally Certification Types & How to Apply for it
100. Interview Tips
Quiz 8
2 Topics
Tally.ERP9 with GST Assignment2
Tally.ERP9 with GST Practice Tests2
42 Topics
ITR-1 Filing - Advance Tax Payment - Comprehensive Case Study
ITR-4 Filing - Individual/Proprietor Business Partnership Firm
TDS-Comprehensive Case Study 26Q
1_what_is_tax_when_taxes_introduced_in_india (1080p)
2_direct_taxes_vs_indirect_taxes (1080p)
3_income_tax_basics_ways_of_collecting_income_tax (1080p)
4_when_to_file_itrs-english (1080p)
5_what_is_itr_applicability_of_itrs (1080p)
6_what_is_tax_audit_when_to_tax_audit_objectives_forms_due_dates_penalties
7_income_tax_computation_format_-_all_type_of_tax_payers (1080p)
8_income_tax_computation_-_individual_-_english (1080p)
9_how_to_register_pan_in_income_tax_portal (1080p)
10_what_is_form_26as_and_how_to_view_it (1080p)
Quiz 1
11_itr-1_filing-english (1080p)
12_itr-4_filing-business_and_profession (1080p)
13_filing_itr-4_for_partnership_firm (1080p)
14_what_is_tds_tds_basics (1080p)
15_tds_process_overview (1080p)
16_who_can_deduct_tds (1080p)
17_how_to_apply_for_tan_-_new_1_new (1080p)
18_tds_payment (1080p)
19_tds_returns (1080p)
20_recording_tds_transactions_in_tallyprime (1080p)
Quiz 2
21_tds_on_salary (1080p)
22_tds_payments (1080p)
23_maintaining_tds_challan_information (1080p)
24_download_and_install_tds_rpu-java-win_rar (1080p)
25_download_csi_file_-_challan_status_inquiry_files_to__import_in_tds_returns_pr
26_tds_return_preparation_form_26q (1080p)
27_tds_return_preparation_form_24q-new (1080p)
28_pan_and_tan_registration (1080p)
29_submitting_tds_files-new (1080p)
30_how_to_view_submitted_tds_and_collect_token_rrr_number (1080p)
Quiz 3
31_what_is_tds_certificate_and_types (1080p)
32_registration_tan_on_tds_traces_portal (1080p)
33_tds_return_status (1080p)
34_how_to_download_tds_certificates_form_16part_a_or_b (1080p)
35_download_tds_certificates-complete_process (1080p)
Quiz 4
69 Topics
1. MS Excel - Launching - Basics of Excel Main Dashboard Interface
2. MS Excel - Cells Rows Columns and Sheets Basics
3. MS EXCEL - Home Tab Basics - Editing and Formatting
4. Copy Paste Functions - All Types
5. Home Tab - Customisation of Tabs
6. MS Excel - Speak Cells
7. Text to Columns - MS Excel Split Tool
8. Characteristics of a Cell and Cell References
9. Comments in MS Excel - Insert Edit Paste and Customise Comment Background
10. Fill Series - Basics - Fill Data only Fill Format Fill Weekdays and more
11. Fill Series-Advanced - Fill Interval Custom Lists and Fill side
12. Fill Series - Flash Fill
13. MS Excel-How to Hide and Unhide Rows Columns Sheets
14. Freeze Panes-Top Row Columns & Multiple Rows & Columns
15. MS Excel-Filters-Learn How to Use Filter to analysis a Big Data
16. MS Excel- Split Sheet Window
17. MS Excel-How to Insert & Delete Cells Rows and Columns
18. MS Excel-Working with Sheets
19. MS Excel-View Sheets Side by Side from One Excel File
20. MS Excel- Workbook Protection- Learn how to setup a Password to open Excel F
21. MS excel- sheet & cells protection
22. MS Excel - Concatenate-Join Multiple Text Strings into ONE
23. MS Excel-Trim_Functions- Remove unnecessary Elements from strings
24. MS Excel- Print Formulas - Left Right Middle
25. MS Excel - Date Related Formulas
26. MS Excel-Print Page Setup Margins Size Excel to PDF
27. MS Excel-Page Header & Footer Add Page Numbers Logo Report Name Date Time &
28. MS Excel - Conditional Formatting
29. MS excel -import data from web
30. MS Excel-import data from text document with auto refresh
31. MS Excel-import-text word ppt jpeg video- pdf & more objects
32. MS Excel-format multiple sheets at a time
33. MS Excel - HyperLinks - Links to Sheet-File-WebPages and more
34. MS Excel Logical Functions Test Functions
35. MS Excel IF formulas - IF - IFand - IFor - nestedIF - IFerror
36. MS Excel - Student Marksheet Calculation using Sum Nested IF Rank Status
37. V Lookup - Exact Match and Approximate Match
38. MS Excel - H Lookup
39. MS Excel - X Lookup - Download and Add to your Excel
40. X Look up - Basics
41. MS Excel - X lookup Formula
42. MS Excel - EMI and Loan Statement Preparation - PMT PPMT IPMT
43. MS Excel - DropDownList Creation - Dependent List - Independent List - Data
44. Data Validation - Date-List-Whole Number - Text Length-Nested If-Ifs and mor
45. Macro Part1 - Designing a Form
46. Macro Part2 - Recording and Running a Macro
47._VBA_&_Macro_Introduction
48. 3D SUM - Calculate Multiple Sheet and analyse
49. CONSOLIDATE - 3D SUM EXTENSION
50. Age Calculator - Exclusive and Inclusive
51. BAR CODE GENERATOR in MS Excel
52. Charts - Pie Charts
53. Charts - Bar Charts and Column Charts
54. Auditing Tools - Trace Precedents-Dependent-Show Formula and more
55. Statistical Formulas - Sum-Sumif-sumifs-avg-avgif-avgifs-count-countif-count
56. INDEX
57. MATCH
58. PIVOT TABLE - BASICS
59. Create_a_Pivot Chart_from_Table_&_Pivot_Table
60. Pivot_Table_-_Use_slicers_to_filter_data
61. Sales Register Maintenance
62. commission calculation
63. Attendance Sheet Preparation
64. Salary Calculation
65. Creating_Professional_Invoice_in_Excel
66. 2D Geographi Charts - Map Chart Basics
67. 2D MAPS - ADVANCED
68. 3D Maps - Make scenes - Export Video - Time Lapse
69. 3D MAPS - Statewise Product Sale
4 Topics
Download CV/Resume for Accounting Executives
Shortcut Keys of Excel
Learn How to Download Certificate of Completion from Udemy
Know more about Student Dashboard - Tally Education Job Portal - Benefits
TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack)
Related TallyPrime (Tally.ERP) Courses
.webp)
Thank You!
Your review has been submitted successfully.