Tally.ERP9 + GST + Excel (Combo Pack)

A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Professional & Management Sectors

Created by Urs Ravi & Vedanta Educational Academy, Last Updated 28-Sep-2020, Language:English

What Will I Get ?

Accounting Fundamentals
Tally.ERP9 Full Course
GST Concepts & GST Portal Concepts
MS Excel Full Course
Downloadable Materials

Requirements

Basic Computer Fundamentals & Terminologies

Description

Commerce Basics

Accounting Fundamentals

Tally.ERP9 All Levels

GST Concepts & GST Portal concepts

Excel - All Levels

Course Highlights

Faculty : A Person who trains the trainers
Tally Authorised Institute Facutly
well known as TallyGuru & Office Expert
GSTN Recognized Tax Practitioner
All topics covered Course(Like-nothing left in 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 Book of Accounts & GST
All GST Classes Based on Real-Time Data
Assignments
Quizzes
Practices Tests

Course Content

Tally.ERP9 Full Course

83 Lectures 16:58:40
- 1. What is Commerce I Introduction I Accounting Systems I Accounting I
  
  Preview
  
  00:10:33
- 2. Double Entry Accounting Systems I Elements I Steps I Structure Explained
  
  00:10:33
- 3. Tally - Introduction, History, Advantages
  
  Preview
  
  00:03:40
- 4. Costing of Tally
  
  00:00:39
- 5. Tally.ERP9 Downloading, Installation & Activation
  
  Preview
  
  00:03:56
- 6. Golden Rules of Accounts
  
  00:10:54
- 8. Company - Creation, Alteration, Deletion & Securing
  
  Preview
  
  00:16:07
- 9. Understanding Tally Pre- defined Vouchers
  
  00:08:43
- 10. Tally Data Processing Structure
  
  00:11:07
- 11. Understanding Tally with Basic Illustrations
  
  00:17:54
- 12. Recording & Maintaining Installments in Tally.ERP9 I Bill-wise accounts
  
  00:24:26
- 13. Recording & Maintaining Supply against Advances- Advances Management
  
  00:15:22
- 14. Tracking OverDue Supply - Credit Sales
  
  00:05:44
- 15. Multi - Currency Accounting in Tally.ERP9 & Adjustment Entries of Forex Gain & Loss
  
  00:17:20
- 16. Cheque Book Configuration in Tally.ERP9
  
  00:13:40
- 17. Banking - Transaction Types ATM, Credit & Debit Cards, Online Banking & more
  
  00:05:38
- 18. Post Dated Cheques Management in Tally.ERP9 I PDC's
  
  Preview
  
  00:29:31
- 19. Bank-Reconciliation-Introduction-Theory
  
  00:06:32
- 20. Bank-Reconciliation-in-Tally.ERP9-I-Practical-CaseStudy1
  
  00:40:38
- 21. Bank Reconciliation in Tally.ERP9 I CaseStudy2
  
  00:35:47
- 22. GST Revenue Sharig Rations between Centre & State Govt's
  
  Preview
  
  00:07:02
- 23. GST CLASSIFICATIONS
  
  00:04:02
- 24. Enabling GST Features in Tally.ERP9
  
  00:09:10
- 25. Recording GST Transactions in Tally.ERP9 I SMART method
  
  00:25:57
- 26.Recording-GST-Transaction Traditional-Method
  
  00:14:26
- 27. Recording GST Transactions - CaseStudy2
  
  00:17:54
- 28. GST Tax Invoice Configuration - Voucher Numbering
  
  00:04:58
- 29. Recording GST Transaction with Auto Billing
  
  00:07:51
- 30. GST Tax Invoice, Bank Details, Customer Seal Signature, Jurisdiction - Printing Configuration
  
  00:16:48
- 31. Rate Inclusive of Tax Item Description in Tally.ERP9
  
  00:05:26
- 32. Recording GST Transactions - Services
  
  00:06:15
- 33. Recording GST Transactions - Assets I with Input Tax Credit I without ITC
  
  00:06:50
- 34. Recording GST Transactions - Expenses with & without Input Tax Credit
  
  00:06:07
- 35. Recording GST Transactions - Sales with Additional Expenditure
  
  00:05:01
- 36. Genarate E-Way Bills Creation, Alter & Cancellation Online Offline methods
  
  00:22:36
- 37. GST- Recording RCM in Tally.ERP9
  
  00:31:19
- 53. What is TDS ( Tax deduction at source ) - How to calculate TDS - Introduction
  
  00:06:10
- 54. How to Configure TDS in Tally.ERP9 & Recordinng TDS Entries in Tally
  
  00:08:20
- 55. Recording TDS Transaction in Tally.ERP9
  
  00:10:29
- 56. Purchase Returns & Sales Returns in Tally.ERP9
  
  00:11:45
- 57. Delivery Notes & Receipt Notes in Tally.ERP9
  
  00:14:08
- 58. Sales OrdersQuotations in Tally.ERP9
  
  00:06:39
- 59. Tally.ERP9 Discounts I TradeDiscounts & Cash Discounts
  
  00:14:16
- 60. PriceList's in Tally.ERP9 I Party Level & Product Level
  
  00:08:38
- 61. Auto-Interest Calculation on Overdue Installments
  
  00:40:01
- 62. Basic of Manufacturing
  
  Preview
  
  00:07:59
- 63. Standard Manufacturing Practicals in Tally.ERP9
  
  00:41:55
- 64. Cost Centres in Tally.ERP9 (Departments Handling)
  
  00:14:55
- 65. Branch-Wise Accounts-Using Cost Centers & Godowns in Tally.ERP9
  
  00:37:45
- 66. Multi User Creation in Tally.ERP9
  
  00:05:50
- 67. Security , Password for Users in Tally.ERP9
  
  00:05:55
- 68. Tally Internal Data Verification & Tally Audit
  
  00:04:59
- 69. Recording - Year End Adjustments in Tally.ERP9
  
  00:32:11
- 70. Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split
  
  00:23:21
- 71. Payroll - in Tally.ERP9 Introduction to Steps
  
  00:04:34
- 72. Payroll-Complete Setup Monthly Process & Stop Computation - Overall Coverage
  
  00:35:33
- 73. Budgets in Tally.ERP9
  
  00:10:14
- 74. Calculator Usage in Tally.ERP9
  
  00:03:10
- 75. Tally Data Backup & Restore
  
  00:19:17
- 76. Alternate Units of Measurement in Tally.ERP9
  
  00:04:02
- 77. Batches Management (with Date of Manufacturing & Expiry )
  
  00:07:31
- 78. Data Searching in Tally.ERP9
  
  00:06:21
- 79. Day Book Features in Tally.ERP9
  
  00:13:34
- 80. POS in Tally.ERP9
  
  00:05:49
- 81. Splitting in Tally.ERP9
  
  00:06:57
- 82. Part Numbers in Tally.ERP9
  
  00:03:54
- 83. Standard Rate Setup in Tally.ERP9
  
  00:03:39
- 84. Zero Valued Transaction
  
  00:02:12
- 85. Exports I Tally to JPEG, PDF, HTML, XML
  
  00:05:43
- 86. Data Export & Import in Tally.ERP9
  
  00:11:39
- 87. Live Mailing from Tally.ERP9
  
  00:17:24
- 88. Tax Audit Due Dates Extended
  
  00:00:20
- 89. Logo Printing in Tally.ERP9
  
  00:04:52
- 90. Reply to Students Request Refund Applied I Deducted on GSTN INot Credited2 bank
  
  00:07:53
- 92. Budget-2020-I-Highlights-I-Old-New-Slabs
  
  00:04:42
- 93. 37th GST Council meeting I 2 Major decisions I Relaxation of filing GSTR-9 & more
  
  00:01:24
- 94. Highlights-of-38th-GST-Council-Meeting
  
  00:04:01
- 95 Know Your PAN CARD STATUS
  
  00:00:50
- 96. Item Description in Tally.ERP9 - without instructor
  
  00:05:26
- 97. JobOrderProcessing-in-Tally-Application
  
  00:45:48
- 98. Tally Certifications - Student Dashboard & Job Portal Benefits
  
  00:01:19
- 99. Tally Certification Types & How to Apply for it
  
  00:03:00
- 100. Interview Tips
  
  Preview
  
  00:01:50
GST Concepts

16 Lectures 02:46:36
- 38. GST Overview Introduction
  
  00:06:31
- GST Revenue Sharing Rations between Govts
  
  Preview
  
  00:07:02
- 39. Key Points about GST Council
  
  00:01:59
- GST Classification
  
  Preview
  
  00:04:02
- 40. Introduction to GST Returns
  
  00:02:47
- 41. GSTR - 3B Filing
  
  00:25:19
- 42. GSTR-1 Filing ( GST-Regular) Offline Online Methods Explained with Live Data
  
  00:37:56
- 43. GST Registration - Live (Case Study 1)
  
  Preview
  
  00:24:07
- 44. GST Registration - Filing Clarifications
  
  00:04:54
- 47. GST Registration - Core Filed Amendments
  
  00:03:47
- 48. GST Registration - Non-Core Filed Amendments
  
  00:03:51
- 49.GST Application for Refund
  
  00:25:44
- 50. GST Registration -CANCELLATION
  
  00:05:23
- 51. GST Tax Practitioner Registration
  
  00:08:35
- 52. Opting Withdrawal of Composition Levy in GST Portal
  
  00:03:24
- 53. How to Download GST Registration Certificate from GST Portal
  
  00:01:15
MS Excel - Full course

81 Lectures 08:15:43
- 1. Introduction to Microsoft Excel-Course-English
  
  00:02:39
- 2. How to Open Close Save Excel Application
  
  00:01:28
- 3. How to Open and Close MS Excel, What is Menus, Tools, Sheets, Colums, Rows & Cells
  
  Preview
  
  00:06:26
- 4. Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Multiplication I Product I Division & more
  
  Preview
  
  00:10:50
- 5. Learn How to Create Tabs, Groups and add Toll to it in MS Excel
  
  00:05:16
- 6. Excel - Editing Data I over writing I editing I find & replace I undo & redo I Go to
  
  00:05:45
- 7. MS Excel - Home Tab - Group Clip Board Explained - Copy, Cut, Paste, Copy as Picture, Format Painter, Past Special
  
  00:09:33
- 8. MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold Italic, Underline, Borders, Fill color, Font Color
  
  00:08:46
- 9. Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
  
  00:05:34
- 10. MS Excel - Characteristics of Cell
  
  00:01:11
- 11. Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft Excel Excel
  
  00:03:41
- 12. MS Excel - Text to Columns
  
  00:05:34
- 13. MS Excel - Comments - add, edit, delete & Show all
  
  00:03:20
- 14. MS Excel - Fill Series - with formatting, without formatting & more
  
  00:02:46
- 15. Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add, Fill Down, Right & more
  
  00:07:11
- 16. Fill Series - Flash Fill
  
  00:03:48
- 17. MS Excel - How to Hind and Unhide Rows, Columns, Sheets
  
  00:06:06
- 18. Freeze Panes - Top Row, Columns & Multiple Rows & Columns
  
  00:07:00
- 19. MS Excel - Filters - Learn How to Use Filter a Big Data
  
  00:07:54
- 20. MS Excel - Split Sheet Window
  
  00:03:12
- 21. MS Excel - How to Insert & Delete Cells, Rows, Columns
  
  00:07:27
- 22. MS Excel - Working with Sheets
  
  00:06:50
- 23. MS Excel - View Sheets Side by Side from One Excel File
  
  00:04:15
- 24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel File
  
  00:03:35
- 25. MS Excel - Sheet & Cells Protection
  
  00:05:12
- 26. MS Excel - Create & Remove Drop Down List
  
  00:08:45
- 27. Concatenate - Join Multiple Text Strings into ONE
  
  00:01:15
- 28. MS Excel - Trim Functions - Remove unnecessary Elements from strings
  
  00:01:33
- 29. MS Excel - Print Formulas Left, Right, Middle
  
  00:03:26
- 30. MS Excel - Date Related Fromulas
  
  00:03:07
- 31. MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New Documents
  
  00:09:54
- 32. MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
  
  00:08:42
- 33. MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date, Time & more
  
  00:06:28
- 34. MS Excel - Conditional Formatting
  
  00:05:16
- 35 (a). Introduction to Data Validation - Time limitation, 35. (B) Data Validation - Restrict Cells, Input & Error Message, Drop Down List, Date & more
  
  Preview
  
  00:01:16
- 36. Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Info Messages Settings
  
  00:06:06
- 37. MS Excel - Data Validation - Dependent - Multiple Drop Down Lists
  
  00:06:10
- 38. MS Excel - Import Data from Web
  
  00:05:24
- 39. MS Excel - Import Data from Text Documnet - with Auto Refresh
  
  00:03:14
- 40. MS Excel - Import - Text, Word, PPT, Jpeg, Video, PDF & More Objects
  
  00:09:18
- 41. MS Excel - Format Multiple Sheets at a time
  
  00:04:52
- 42. MS Excel - 3d Sum
  
  00:03:56
- 43. MS Excel - Consolidate ( 3d Sum extention)
  
  00:04:08
- 44. MS Excel - Age Calculator in Multiple Wasy - Excluisve formula
  
  00:05:04
- 45. MS Excel - Bar Code I Install Bar code font I Genarate Bar Codes
  
  Preview
  
  00:05:33
- 46. MS Excel - Charts - Pie Charts - Create & Customize
  
  00:08:24
- 47. MS Excel - Charts - Columnar Charts
  
  00:09:02
- 48. Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I Comparative Operators
  
  00:03:41
- 49. Logical Test - IF Function
  
  00:10:12
- 50. Logical Functions - Nested IF - Learn How to work with Nested if Formula
  
  00:05:10
- 51. Logical Functions - AND function
  
  Preview
  
  00:04:57
- 52. Logical Function - Not & IFERROR
  
  00:02:13
- 53. Show Formula, Trace Dependents, Trace Precendents, Evaluate Formula, FormulaText
  
  00:09:16
- 54. Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Avgif, Avgifs
  
  00:15:53
- 55. Formulas - sumproduct, mround, floor, ceiling
  
  00:08:48
- 56. StudentMart Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
  
  00:10:50
- 57. (A) Vlookup - Introduction
  
  Preview
  
  00:01:09
- 57.(B) Vlookup - Formula, Functionality, Rules, Approximate & Exact Match & more
  
  00:12:58
- 58. Hlookup - Formula, Functionality, Rules, Approximate & Exact Match & more
  
  00:03:36
- 59. Download, Add & use X Lookup New Formula in MS Excel
  
  00:03:44
- 60.(A) X Lookup - Introduction
  
  00:01:06
- 60. (B) X Lookup New Formula in MS Excel
  
  00:06:15
- 61. Index Formula - Find a Position of the Value, and Call cells references
  
  00:08:36
- 62. Match Formula - Find Position of the Value
  
  00:01:37
- 63. Pivot Table Introduction & Basics of Pivot Table
  
  00:02:12
- 64. Create a PivotChart from Table & Pivot Table
  
  00:01:01
- 65. Pivot Table - Use slicers to filter data
  
  00:01:07
- 66. Pivot Table, Charts, Progress Dashboard
  
  00:26:05
- 67. MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
  
  00:18:49
- 68. Working with Tables
  
  00:05:48
- 69. Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Data Lavidation, 3D Sum, Name Ranges
  
  00:26:58
- 70. Share a workbook with Co Authors, Employes or with Anyone
  
  00:00:51
- 71. MS Excel - Copy Cells, Move Cells
  
  00:01:20
- 72. Commission Calculation in MS Excel
  
  00:06:39
- 73. Attendence Sheet Preparation in MS Excel
  
  00:09:59
- 74. Attendence Sheet Extention - Salary Calculation with CA, DA, Commission, Advance Salary, PF & ESI
  
  Preview
  
  00:06:21
- 75. Creating Professional Invoice in Excel
  
  00:13:21
- 76. Excel to SMS Free
  
  00:04:35
- 77. VBA & Macro Introduction
  
  00:01:05
- 78. MS Excel - Enabling Developer Tab
  
  00:00:53
- 79. Saving Macros
  
  00:02:26

Urs Ravi & Vedanta Educational Academy

Tally & GST Guru I Microsoft Office Expert

UrsRaviTelugu Chief Faculty at Tally Institute of Learning
Ravi Telugu is a Corporate Trainer with 6 Years of Training Experience on various technologies. He specializes in MS Office Tools, Tally, Focus, Wings, SAP, GST, Income Tax, TDS.

Ravi Telugu, Cheif Executive officer at @ Vedanta Educational Academy.

Authorized partner @ Tally Solutions and also Tally Education

Instructor at Tally Institute of Learning for last 3yrs.

Signed up Top 11 Colleges for Tally & GST(more than 10,000 students)

Speaker at OU Tally & GST awareness program.

Having 4yrs experience in Tally Training center/worked as faculty in Top Institutes.

Working as accounts admin for Valam Foods Pvt LTD. Sri Varun Scales, Digitam Intellect Pvt LTD etc.