Tally.ERP9 + GST + Excel (Combo Pack)
Created by Urs Ravi & Vedanta Educational Academy, Last Updated 28-Sep-2020, Language:English
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
Preview00:10:33 -
2. Double Entry Accounting Systems I Elements I Steps I Structure Explained
00:10:33 -
3. Tally - Introduction, History, Advantages
Preview00:03:40 -
4. Costing of Tally
00:00:39 -
5. Tally.ERP9 Downloading, Installation & Activation
Preview00:03:56 -
6. Golden Rules of Accounts
00:10:54 -
8. Company - Creation, Alteration, Deletion & Securing
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00:01:50
-
-
GST Concepts
16 Lectures 02:46:36-
38. GST Overview Introduction
00:06:31 -
GST Revenue Sharing Rations between Govts
Preview00:07:02 -
39. Key Points about GST Council
00:01:59 -
GST Classification
Preview00: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)
Preview00: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
Preview00:06:26 -
4. Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Multiplication I Product I Division & more
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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.