Tally.ERP9-TallyPrime-GST-IncomeTax-TDS-MS Excel: Combo Pack

Learn accounting, financial, MIS, data analysis for tax professional, auditors and business management sectors.

Software Microsoft Excel

By: Ravi

Tally.ERP9-TallyPrime-GST-IncomeTax-TDS-MS Excel: Combo Pack

Learn accounting, financial, MIS, data analysis for tax professional, auditors and business management sectors.

Software Microsoft Excel

By: Ravi

211

views

Share the link to this page

Copied

Facebook

Twitter

Add the class to your calendar

Add to Google Calendar

Add to Apple Calendar

Add to Yahoo Calendar

Add to Outlook Calendar

About the Class

Learn basics of accounting, Tally.ERP9, TallyPrime, GST, Income Tax, TDS, and MS Excel

Course Highlights

Faculty: A Person who trains the trainers
Tally authorized institute faculty
Well known as TallyGuru and office expert
GSTN recognized tax practitioner
All topics covered course(Like-nothing left in the tally)
Classes on licensed version tally
Case-studies explained
Quiz for each individual chapter
100% satisfactory results/reviews
Reference questions/soft copy material available
After these course student can handle all books of accounts and GST
All GST classes based on real-time data
Assignments
Quizzes
Practices tests

Author

Ravi

School

Ravi's School

Requirements

There are no additional requirements.

Class Contents

Free Sample Videos of course

Company Creation in TallyPrime

Preview

GST Registration - live Case Study

Preview

Group Company Cration in TallyPrime

Preview

MS Excel - EMI Calculator in Excel

Preview

Tally.ERP9 Download and Installation

Preview

Accounting Basics

What is Commerce - Introduction - Accounting Systems - Accounting

Double Entry Accounting Systems - Elements - Steps - Structure Explained

Golden Rules of Accounts

Fundamentals of Accounting

Course Material

Download Material Here

TallyPrime-Full Course

1. TallyPrime-Downloading and Installation

2. TallyPrime-Launching, Working in Education Mode, Licensing

3. How to Get Familiar with your TallyPrime

4. TallyPrime-Company Creation, Alteration and Deletion

5. TallyPrime-Group Company-Creation, Alteration and Deletion

6. TallyPrime-Data Entry Steps - Ledgers, Items and Vouchers

7. TallyPrime-Predefined Vouchers Introduction

8. Understanding Pre-Defined Vouchers-Explained

9. Tally Prime I Ledger Creation I Alteration I Deletion I Traditional Method

10. Tally Prime Stock Item Creation I Groups I Units I Creation I Alteration I Deletion

11. How to update Opening Balances and Opening Stock in TallyPrime

12. Stock Group - Introduction, Creation and Alteration

13. Creation and Alteration of Stock Category

14. Creation of Unit of Measurement and FAQ

15. Creation and Alteration of Stock Item

16. Recording Purchases and Sales

17. Recording Contra, Receipt and Payment Vouchers

18. Golden Rules of Accounts

19. Recording Journals in TallyPrime

20. Basic Illustration to Understand TallyPrime Vouchers

21. Bill-wise Accounts - An Introduction

22. Bills wise details for Purchases

23. Bill-wise Details for Sales - Bills Receivable

23. Z. How to View and Analyse Bills Outstanding Reports in TallyPrime

24. Bill-wise Accounts Supply Against Advances

25. Bill-wise Accounts-Tracking Overdue Supplies

26. Cheque Book Configuration in TallyPrime

27. Cheque Printing in TallyPrime

28. Enabling All-Banking Transaction Types

29. An Introduction to Post Dated Cheques Management

30.Post Dated Cheques Management in TallyPrime

31. Applying for TallyPrime License

32. Introduction to Bank Reconciliation Process in TallyPrime

33. Bank Reconciliation in TallyPrime

34. How to Do Auto Bank Reconciliation

35. Enabling GST in TallyPrime

36. Recording GST Transactions - Single Slab - Inter and Intra State Supply, Analyze GSTR1

37. Recording GST Transactions - Multiple Tax Slabs

38. GST Configuration in Stock Group Level and Stock Item Level

39. Enabling Auto-Billing in TallyPrime

40. GST Returns - An Introduction Video

41. GSTR-1 Tables I Understanding GSTR-1 Basic and Amendments Tables

42. GSTR-1 Filing using TallyPrime

43. Nil GSTR-1 filing I No Sales

44. Recording GST Services in TallyPrime

45. Recording Expenses - Claimable and Non-Claimable GST Expenses

46. Recording Assets - Claimable and Non Claimable

47. How to Reconcile GSTR-2 in TallyPrime

48. Voucher Numbering - Invoice Numbering in TallyPrime

49. Logo Creation and Printing in TallyPrime

TallyPrime-Full Course (Part-B)

50. Adding Additional Description

51. Rate Inclusive of Tax GST

51.Y PRINTING PREFERENCES in Tally Prime.mp4

51.Z.How To Optimize Page Size when Printing Invoices in TallyPrime

52. GST Tax Computation and Tax Adjustments.mp4

53. GSTR-3B Filing I Online and Offline methods.mp4

54. Course Introduction - Inventory Management

55. Inventory Management - Introduction, Importance, Advantages

56. Activation of Batches for Stock Item

57. Allocation of Batch Details in Purchase Invoice

58. Selling of Stock Items from Batch and Identifying of Expired Batch in Sales Invoice, Printing Batch Info

59. Returning of Expired Batch Stock Item

60. Activating Price Levels

61. Defining Price Levels, Creating Price List, Usage of Price List in Sale Voucher

62. Revise Price List

63. Different Types of Inventory Valuations

64. Activation of Purchase Order and Sales Order.mp4

65. Activation of Delivery and Receipt Notes.mp4

66. Activation of Debit and Credit Note.mp4

67. Purchases Management - Purchase Order, Receipt Note, Purchase, Purchase Returns.mp4

68. Sales Management - Sales Order, Delivery Note, Sales, Sales Return.mp4

68.Z. How to Manage Sales and Purchase Order Processing in TallyPrime

69. Creation of Godown

70. How to Create and Manage Multiple Godowns in TallyPrime

71. How to Record Inter Godown Stock Transfer in TallyPrime

Advanced TCS Transactions in TallyPrime

Basic TCS Transactions in TallyPrime

How to Backup Data in TallyPrime

How To Migrate Your Data in Tally Prime

How to Move to the New Financial Year in TallyPrime

How to Record Manufacturing of Finished Goods in TallyPrime

How to Restore Data in TallyPrime

How to Use the Right Buttons in TallyPrime to Work Faster

How to View and Analyse Accounting Reports in TallyPrime

How to View and Analyse Balance Sheet in TallyPrime

How to View and Analyse Inventory in TallyPrime

How to View and Analyse Profit and Loss Account in TallyPrime

Setting up TCS Masters in TallyPrime

Steps to Enable TCS in TallyPrime

TCS Reports and Returns in TallyPrime

Tally.ERP9 Full Course

1. Tally.ERP9 with GST and Excel Combo Pack Intro Video

2. Tally.ERP9 Download - New Portal

3 Tally - Introduction, History, Advantages

4. Costing of Tally

5. Tally.ERP9 Downloading, Installation and Activation

6. Golden Rules of Accounts

7. Tally.ERP9 with GST - Course Material

8. Company - Creation, Alteration, Deletion and Securing

9. Understanding Tally Pre- defined Vouchers

10. Tally Data Processing Structure

11. Understanding Tally with Basic Illustrations

12. Recording and Maintaining Installments in Tally.ERP9 I Bill-wise accounts

13. Recording and Maintaining Supply against Advances- Advances Management

14. Tracking OverDue Supply - Credit Sales

15. Multi - Currency Accounting in Tally.ERP9 and Adjustment Entries of Forex Gain and Loss

16. Cheque Book Configuration in Tally.ERP9

17. Banking - Transaction Types ATM, Credit and Debit Cards, Online Banking and more

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

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 - Printing Configuration

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 and without Input Tax Credit

35. Recording GST Transactions - Sales with Additional Expenditure

37. GST- Recording RCM in Tally.ERP9

53. What is TDS ( Tax deduction at source ) - How to calculate TDS - Introduction

54. How to Configure TDS in Tally.ERP9 and Recording TDS Entries in Tally

55. Recording TDS Transaction in Tally.ERP9

56. Purchase Returns and Sales Returns in Tally.ERP9

57. Delivery Notes and Receipt Notes in Tally.ERP9

58. Sales OrdersQuotations in Tally.ERP9

59. Tally.ERP9 Discounts I Trade Discounts and Cash Discounts

60. PriceList's in Tally.ERP9 I Party Level and 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 and Godowns in Tally.ERP9

66. Multi User Creation in Tally.ERP9

67. Security , Password for Users in Tally.ERP9

68. Tally Internal Data Verification and Tally Audit

Tally.ERP9 Full Course (Part-B)

69. Recording - Year End Adjustments in Tally.ERP9

70. Capital Adjustments I Drawings Adjustments and Closing I Profit Sharing I Split

71. Payroll - in Tally.ERP9 Introduction to Steps

72. Payroll-Complete Setup Monthly Process and Stop Computation - Overall Coverage

73. Budgets in Tally.ERP9

74. Calculator Usage in Tally.ERP9

75. Tally Data Backup and Restore

76. Alternate Units of Measurement in Tally.ERP9

77. Batches Management (with Date of Manufacturing and Expiry )

78. Data Searching in Tally.ERP9

79. Day Book Features in Tally.ERP9

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 and Import in Tally.ERP9

87. Live Mailing from Tally.ERP9

88. Tax Audit Due Dates Extended

89. Logo Printing in Tally.ERP9

90. Reply to Students Request Refund Applied I Deducted on GSTN INot Credited2 bank

92. Budget-2020-I-Highlights-I-Old-New-Slabs

93. 37th GST Council meeting I 2 Major decisions I Relaxation of filing GSTR-9 and more

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 and Job Portal Benefits

99. Tally Certification Types and How to Apply for it

100. Interview Tips

GST and GST Portal Concepts

1. GST Overview Introduction

2. GST CLASSIFICATIONS

3. GST Revenue Sharing Rations between Centre and State Govt's

4. Key Points about GST Council

5 Know Your PAN CARD STATUS

6. GST Registration - Live (Case Study 1)

7. GST Registration - Filing Clarifications

8. GST Registration - Tracking Submitted Applications

9. Viewing Submitted Applications - GST Registration

10. GST Download Registration Certificate in a Minute

11. GST Registration - Core Filed Amendments

12. GST Registration - Non-Core Fields Amendments

13. GST Registration -CANCELLATION

14. Opting Withdrawal of Composition Levy in GST Portal

15. GST Tax Practitioner Registration

16. Introduction to GST Returns

16. z. GST Returns - An Introduction Video

17. a. GSTR-1 Tables I Understanding GSTR-1 Basic and Amendments Tables-new new

17. GSTR-1 Filing ( GST-Regular) Offline Online Methods Explained with Live Data

18.A. GSTR-1 Filing using TallyPrime

18.Z. Nil GSTR-1 filing I No Sales

19. How to Reconcile GSTR-2 in TallyPrime

20. GST Tax Computation and Tax Adjustments.mp4

20. Z.GSTR - 3B Filing

21. GSTR-3B Filing I Online and Offline methods.mp4

22. Generate E-Way Bills Creation, Alter and Cancellation Online Offline methods

23. E-Way Bill Registration, Generation, Update Vehicle Number, Cancellation and more

24.GST Application for Refund

Taxation ( TDS + Income Tax Non Audit) Bonus Section

1 What is Tax, when Taxes Introduced in India

1. What is Tax Audit, When to Tax Audit, Objectives, Forms, Due Dates, Penalties.mp4

2 Direct Taxes Vs Indirect Taxes

2. What is ITR, Applicability of ITRs.mp4

3 Income Tax Basics, Ways of collecting Income Tax

3. When to File ITRs-English.mp4

4 What is TDS, TDS Basics

4. Income Tax Computation - Individual - English.mp4

4. Income Tax Slabs

5 Who can deduct TDS

6 How to Apply for TAN

7. TDS Process Over View

8 TDS Payments

9 TDS Returns

MS Excel - Beginner to Advanced Full Course

1. Introduction to Microsoft Excel-Course-English

2. How to Open Close Save Excel Application2

3. How to Open and Close MS Excel, What is Menus, Tools, Sheets, Columns, Rows and Cells

4. Excel Commonly Used Formulars I Sum I Substraction I Avg I Percentage I Multiplication I Product I Division and more

5. Learn How to Create Tabs, Groups and add Toll to it in MS Excel

6. Excel - Editing Data I over writing I editing I find and replace I undo and redo I Goto

7. MS Excel - Home Tab - Group Clip Board Explained - Copy, Cut, Paste, Copy as Picture, Formart Painter, Past Special

8. MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold Italic, Underline, Borders, Fill Folour, Fot Co

9. Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments and more

10. MS Excel - Characteristics of Cell

11. Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsfot Excel Excel

12. MS Excel - Text to Columns

13. MS Excel - Comments - add, edit, delete and Show all

14. MS Excel - Fill Series - with formatting, without formatting and more

15. Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit and Add, Fill Down, Right and more

16. Fill Series - Flash Fill

17. MS Excel - How to Hide and Unhide Rows, Columns, Sheets

Preview

18. Freeze Panes - Top Row, Columns and Multiple Rows and Columns

19. MS Excel - Filters - Learn How to Use Filter to analysis a Big Data

20. MS Excel - Split Sheet Window

21. MS Excel - How to Insert and Delete Cells, Rows, Columns

22. MS Excel - Working with Sheets

23. MS Excel - View Sheets Side by Side from One Excel File

24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel File

25. MS Excel - Sheet and Cells Protection

26. MS Excel - Create and Remove Drop Down List

27. Concatenate - Join Multiple Text Strings into ONE

28. MS Excel - Trim Functions - Remove unnecessary Elements from strings

29. MS Excel - Print Formulas Left, Right, Middle

30. MS Excel - Date Related Formulas

31. MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New Documents

32. MS Excel - Print, Page Setup, Margins, Size, Excel to PDF

33. MS Excel - Page Header and Footer I Add Page Numbers, Logo, Report Name, Date, Time and more

34. MS Excel - Conditional Formatting

35. Introduction to Data Validation - Time limitation

35. Data Validation - Restrict Cells, Input and Error Message, Drop Down List, Date and more

36. Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Info Messages Settings

37. MS Excel - Data Validation - Dependent - Multiple Drop Down Lists

38. MS Excel - Import Data from Web

39. MS Excel - Import Data from Text Document - with Auto Refresh

40. MS Excel - Import - Text, Word, PPT, Jpeg, Video, PDF and More Objects

41. MS Excel - Format Multiple Sheets at a time

42. MS Excel - 3d Sum

43. MS Excel - Consolidate ( 3d Sum extension)

44. MS Excel - Age Calculator in Multiple Ways - Exclusive formula

45. MS Excel - Bar Code I Install Bar code font I Generate Bar Codes

46. MS Excel - Charts - Pie Charts - Create and Customize

47. MS Excel - Charts - Columnar Charts

48. Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I Comparative Operators

49. Logical Test - IF Function

MS Excel - Beginner to Advanced Full Course (Part-B)

50. Logical Functions - Nested IF - Learn How to work with Nested if Formula

51. Logical Functions - AND function

52. Logical Function - Not and IFERROR

53. Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, FormulaText

54. Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Avgif, Avgifs

55. Formulas - sumproduct, mround, floor, ceiling

56. Student Mark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status

57. Vlookup - Formula, Functionality, Rules, Approximate and Exact Match and more

57. Vlookup - Introduction

58. Hlookup - Formula, Functionality, Rules, Approximate and Exact Match and more

59. Download, Add and Use X Lookup New Formula in MS Excel

60. X Lookup - Introduction

60. X Lookup New Formula in MS Excel

61. Index Formula - Find a Position of the Value, and Call cells references

62. Match Formula - Find Position of the Value

63. Pivot Table Introduction and Basics of Pivot Table

64. Create a PivotChart from Table and Pivot Table

65. Pivot Table - Use slicers to filter data

66. Pivot Table, Charts, Progress Dashboard

67. MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest

68. Working with Tables

69. Create and Maintain Registers - Using Group Sheets, Drop Down Lists, Data Lavidation, 3D Sum, Name Ranges

70. Share a workbook with Co Authors, Employees or with Anyone

71. MS Excel - Copy Cells, Move Cells

72. Commission Calculation in MS Excel

73. Attendance Sheet Preparation in MS Excel

74. Attendance Sheet Extension - Salary Calculation with CA, DA, Commission, Advance Salary, PF and ESI

75. Creating Professional Invoice in Excel

76. Excel to SMS Free

77. VBA and Macro Introduction

78. MS Excel - Enabling Developer Tab

81. Basics of Macros - Record and Run1

82. Saving Macros

83. MS Excel - VBA Coding - Disply Message BOX

One-time Fee

$10

List Price: $100

You save: $90

€8.66

List Price: €86.63

You save: €77.96

£7.55

List Price: £75.55

You save: £68

CA$13.92

List Price: CA$139.20

You save: CA$125.28

A$14.47

List Price: A$144.78

You save: A$130.30

S$12.85

List Price: S$128.56

You save: S$115.70

HK$78.37

List Price: HK$783.72

You save: HK$705.35

CHF 7.98

List Price: CHF 79.80

You save: CHF 71.82

NOK kr97.46

List Price: NOK kr974.66

You save: NOK kr877.19

DKK kr64.73

List Price: DKK kr647.36

You save: DKK kr582.63

NZ$17.51

List Price: NZ$175.19

You save: NZ$157.67

د.إ36.72

List Price: د.إ367.25

You save: د.إ330.52

৳1,224.28

List Price: ৳12,242.86

You save: ৳11,018.57

₹926.65

List Price: ₹9,266.56

You save: ₹8,339.90

RM40.31

List Price: RM403.10

You save: RM362.79

₦13,787.50

List Price: ₦137,875

You save: ₦124,087.50

₨2,783.99

List Price: ₨27,839.98

You save: ₨25,055.98

฿325.80

List Price: ฿3,258

You save: ฿2,932.20

₺445.92

List Price: ₺4,459.25

You save: ₺4,013.32

B$51.57

List Price: B$515.70

You save: B$464.13

R169.62

List Price: R1,696.28

You save: R1,526.65

Лв16.94

List Price: Лв169.44

You save: Лв152.49

₩15,105.07

List Price: ₩151,050.78

You save: ₩135,945.70

₪31.35

List Price: ₪313.58

You save: ₪282.22

₱604.14

List Price: ₱6,041.46

You save: ₱5,437.31

¥1,595.96

List Price: ¥15,959.65

You save: ¥14,363.68

MX$178.50

List Price: MX$1,785.08

You save: MX$1,606.57

QR36.38

List Price: QR363.80

You save: QR327.42

P136.88

List Price: P1,368.85

You save: P1,231.97

KSh1,298

List Price: KSh12,980

You save: KSh11,682

E£542.36

List Price: E£5,423.61

You save: E£4,881.24

ብር1,558

List Price: ብር15,580.08

You save: ብር14,022.07

Kz9,121.31

List Price: Kz91,213.10

You save: Kz82,091.79

CLP$9,174.31

List Price: CLP$91,743.11

You save: CLP$82,568.80

CN¥68.81

List Price: CN¥688.12

You save: CN¥619.30

RD$603.12

List Price: RD$6,031.21

You save: RD$5,428.09

DA1,330.59

List Price: DA13,305.96

You save: DA11,975.37

FJ$22.53

List Price: FJ$225.38

You save: FJ$202.84

Q76.32

List Price: Q763.29

You save: Q686.96

GY$2,088.28

List Price: GY$20,882.89

You save: GY$18,794.60

ISK kr1,251

List Price: ISK kr12,510

You save: ISK kr11,259

DH93.74

List Price: DH937.40

You save: DH843.66

L175.56

List Price: L1,755.61

You save: L1,580.05

ден534.18

List Price: ден5,341.84

You save: ден4,807.65

MOP$80.55

List Price: MOP$805.51

You save: MOP$724.95

N$169.54

List Price: N$1,695.47

You save: N$1,525.92

C$367.12

List Price: C$3,671.21

You save: C$3,304.09

रु1,487.01

List Price: रु14,870.13

You save: रु13,383.11

S/34.51

List Price: S/345.19

You save: S/310.67

K43.16

List Price: K431.60

You save: K388.44

SAR37.54

List Price: SAR375.42

You save: SAR337.88

ZK192.81

List Price: ZK1,928.14

You save: ZK1,735.32

L44.15

List Price: L441.58

You save: L397.42

Kč212.33

List Price: Kč2,123.37

You save: Kč1,911.03

Ft3,338.12

List Price: Ft33,381.20

You save: Ft30,043.08

SEK kr94.31

List Price: SEK kr943.10

You save: SEK kr848.79

ARS$13,894.97

List Price: ARS$138,949.79

You save: ARS$125,054.81

Bs68.94

List Price: Bs689.45

You save: Bs620.50

COP$36,404.53

List Price: COP$364,045.31

You save: COP$327,640.78

₡4,642.79

List Price: ₡46,427.98

You save: ₡41,785.18

L265.04

List Price: L2,650.44

You save: L2,385.39

₲64,542.50

List Price: ₲645,425.01

You save: ₲580,882.51

$U405.49

List Price: $U4,054.94

You save: $U3,649.45

zł37.05

List Price: zł370.58

You save: zł333.52

What's Included

Language: English

Level: All levels

Skills: Income Tax, Finance, Microsoft Excel, TDS, TallyPrim, Tally ERP9, Accounting, GST

Age groups: All ages

Certificate: On completion

Duration: 43 hours 38 minutes

305 Videos

Tally.ERP9-TallyPrime-GST-IncomeTax-TDS-MS Excel: Combo Pack

Tally.ERP9-TallyPrime-GST-IncomeTax-TDS-MS Excel: Combo Pack

About the Class

Author

Ravi

School

Ravi's School

Requirements

Class Contents

What's Included

Sign Up

Sign Up

Share