All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 3 Days!

Browse Library

Get Unlimited Learning Access
$29
3 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access upto 16000+ online courses
  • Play & Pause Course Viewing
  • HD Recorded Lectures
  • Access on Mobile/PC/Tablet
  • Includes Real Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Cancel Anytime
$29
  • you will learn TallyPrime+Tally.ERP9+GST+IncomeTax+TDS+MS Excel

Commerce Basics

Accounting Fundamentals

Tally.ERP9 All Levels

TallyPrime Full Course

GST Concepts & GST Portal concepts

Income Tax Slabs

ITR1 Filing

ITR4 Filing

TDS Introduction

TDS Slabs

TDS Forms

TDS Returns

TDS Filing

Excel - Basics to Pro 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

Commerce Basics

Accounting Fundamentals

Tally.ERP9 All Levels

TallyPrime Full Course

GST Concepts & GST Portal concepts

  • Income Tax Slabs

    ITR1 Filing

    ITR4 Filing

    TDS Introduction

    TDS Slabs

    TDS Forms

    TDS Returns

    TDS Filing

    Excel - Basics to Pro 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 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

  • a desire to learn new skills
  • A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Professional & Business Management Sectors.
View More...
  • Section 1 : Accounting Basics 4 Lectures 00:37:44

    • Lecture 1 :
    • 1. What is Commerce I Introduction I Accounting Systems I Accounting I Preview
    • Lecture 2 :
    • 2. Double Entry Accounting Systems I Elements I Steps I Structure Explained
    • Lecture 3 :
    • 11 Golden Rules of Accounts
    • Lecture 4 :
    • Fundamentals of Accounting
  • Section 2 : Tally Prime Full Course 89 Lectures 08:24:22

    • Lecture 1 :
    • 1. TallyPrime-Downloading & Installation
    • Lecture 2 :
    • 2. TallyPrime-Launching, Working in Education Mode, Licensing
    • Lecture 3 :
    • 3. How to Get Familiar with your TallyPrime
    • Lecture 4 :
    • 4. TallyPrime-Company Creation, Alteration and Deletion
    • Lecture 5 :
    • 5. TallyPrime-Group Company-Creation, Alteration and Deletion
    • Lecture 6 :
    • 6. TallyPrime-Data Entry Steps - Ledgers, Items and Vouchers
    • Lecture 7 :
    • 7. TallyPrime-Predefined Vouchers Introduction
    • Lecture 8 :
    • 8. Understanding Pre-Defined Vouchers-Explained
    • Lecture 9 :
    • 9. Tally Prime I Ledger Creation I Alteration I Deletion I Traditional Method
    • Lecture 10 :
    • 10. Tally Prime Stock Item Creation I Groups I Units I Creation I Alteration I D
    • Lecture 11 :
    • 11. How to update Opening Balances & Opening Stock in TallyPrime
    • Lecture 12 :
    • 12. Stock Group - Introduction, Creation and Alteration
    • Lecture 13 :
    • 13. Creation and Alteration of Stock Category
    • Lecture 14 :
    • 14. Creation of Unit of Measurement & FAQ
    • Lecture 15 :
    • 15. Creation and Alteration of Stock Item
    • Lecture 16 :
    • 16. Recording Purchases & Sales
    • Lecture 17 :
    • 17. Recording Contra, Receipt and Payment Vouchers
    • Lecture 18 :
    • 18. Golden Rules of Accounts
    • Lecture 19 :
    • 19. Recording Journals in TallyPrime
    • Lecture 20 :
    • 20. Basic Illustration to Understand TallyPrime Vouchers
    • Lecture 21 :
    • 21. Bill-wise Accounts - An Introduction
    • Lecture 22 :
    • 22. Bills wise details for Purchases
    • Lecture 23 :
    • 23. Bill-wise Details for Sales - Bills Receivable
    • Lecture 24 :
    • 23. Z. How to View and Analyse Bills Outstanding Reports in TallyPrime
    • Lecture 25 :
    • 24. Bill-wise Accounts Supply Against Advances
    • Lecture 26 :
    • 25. Bill-wise Accounts-Tracking Overdue Supplies
    • Lecture 27 :
    • 26. Cheque Book Configuration in TallyPrime
    • Lecture 28 :
    • 27. Cheque Printing in TallyPrime
    • Lecture 29 :
    • 28. Enabling All-Banking Transaction Types
    • Lecture 30 :
    • 29. An Introduction to Post Dated Cheques Management
    • Lecture 31 :
    • 30.Post Dated Cheques Management in TallyPrime
    • Lecture 32 :
    • 31. Applying for TallyPrime License
    • Lecture 33 :
    • 32. Introduction to Bank Reconciliation Process in TallyPrime
    • Lecture 34 :
    • 33. Bank Reconciliation in TallyPrime
    • Lecture 35 :
    • 34. How to Do Auto Bank Reconciliation
    • Lecture 36 :
    • 35. Enabling GST in TallyPrime
    • Lecture 37 :
    • 36. Recording GST Transactions - Single Slab - Inter and Intra State Supply, Ana
    • Lecture 38 :
    • 37. Recording GST Transactions - Multiple Tax Slabs
    • Lecture 39 :
    • 38. GST Configuration in Stock Group Level and Stock Item Level
    • Lecture 40 :
    • 39. Enabling Auto-Billing in TallyPrime
    • Lecture 41 :
    • 40. GST Returns - An Introduction Video
    • Lecture 42 :
    • 41. GSTR-1 Tables I Understanding GSTR-1 Basic & Amendments Tables
    • Lecture 43 :
    • 42. GSTR-1 Filing using TallyPrime
    • Lecture 44 :
    • 43. Nil GSTR-1 filing I No Sales
    • Lecture 45 :
    • 44. Recording GST Services in TallyPrime
    • Lecture 46 :
    • 45. Recording Expenses - Claimable and Non-Claimable GST Expenses
    • Lecture 47 :
    • 46. Recording Assets - Claimable & Non Claimable
    • Lecture 48 :
    • 47. How to Reconcile GSTR-2 in TallyPrime
    • Lecture 49 :
    • 48. Voucher Numbering - Invoice Numbering in TallyPrime
    • Lecture 50 :
    • 49. Logo Creation & Printing in TallyPrime
    • Lecture 51 :
    • 50. Adding Additional Description
    • Lecture 52 :
    • 51. Rate Inclusive of Tax GST
    • Lecture 53 :
    • 51.Y PRINTING PREFERENCES in Tally Prime.mp4
    • Lecture 54 :
    • 51.Z. How to Optimise Page Size when Printing Invoices in TallyPrime
    • Lecture 55 :
    • 52. GST Tax Computation & Tax Adjustments.mp4
    • Lecture 56 :
    • 53. GSTR-3B Filing I Online and Offline methods.mp4
    • Lecture 57 :
    • 54. Course Introduction - Inventory Management
    • Lecture 58 :
    • 55. Inventory Management - Introduction, Importance, Advantages
    • Lecture 59 :
    • 56. Activation of Batches for Stock Item
    • Lecture 60 :
    • 57. Allocation of Batch Details in Purchase Invoice
    • Lecture 61 :
    • 58. Selling of Stock Items from Batch and Identifying of Expired Batch in Sales
    • Lecture 62 :
    • 59. Returning of Expired Batch Stock Item
    • Lecture 63 :
    • 60. Activating Price Levels
    • Lecture 64 :
    • 61. Defining Price Levels, Creating Price List, Usage of Price List in Sale Vouc
    • Lecture 65 :
    • 62. Revise Price List
    • Lecture 66 :
    • 63. Different Types of Inventory Valuations
    • Lecture 67 :
    • 64. Activation of Purchase Order and Sales Order.mp4
    • Lecture 68 :
    • 65. Activation of Delivery & Receipt Notes.mp4
    • Lecture 69 :
    • 66. Activation of Debit & Credit Note.mp4
    • Lecture 70 :
    • 67. Purchases Management - Purchase Order, Receipt Note, Purchase, Purchase Retu
    • Lecture 71 :
    • 68.Z. How to Manage Sales & Purchase Order Processing in TallyPrime
    • Lecture 72 :
    • 69. Creation of Godown
    • Lecture 73 :
    • 70. How to Create and Manage Multiple Godowns in TallyPrime
    • Lecture 74 :
    • 71. How to Record Inter Godown Stock Transfer in TallyPrime
    • Lecture 75 :
    • Advanced TCS Transactions in TallyPrime
    • Lecture 76 :
    • Basic TCS Transactions in TallyPrime
    • Lecture 77 :
    • How to Backup Data in TallyPrime
    • Lecture 78 :
    • How To Migrate Your Data in Tally Prime
    • Lecture 79 :
    • How to Move to the New Financial Year in TallyPrime
    • Lecture 80 :
    • How to Record Manufacturing of Finished Goods in TallyPrime
    • Lecture 81 :
    • How to Restore Data in TallyPrime
    • Lecture 82 :
    • How to Use the Right Buttons in TallyPrime to Work Faster
    • Lecture 83 :
    • How to View and Analyse Accounting Reports in TallyPrime
    • Lecture 84 :
    • How to View and Analyse Balance Sheet in TallyPrime
    • Lecture 85 :
    • How to View and Analyse Inventory in TallyPrime
    • Lecture 86 :
    • Setting up TCS Masters in TallyPrime
    • Lecture 87 :
    • Steps to Enable TCS in TallyPrime
    • Lecture 88 :
    • TCS Reports and Returns in TallyPrime
    • Lecture 89 :
    • How to View and Analyse Profit and Loss Account in TallyPrime
  • Section 3 : Tally ERP9 Full Course 79 Lectures 06:51:04

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

    • Lecture 1 :
    • 1. GST Overview Introduction
    • Lecture 2 :
    • 2. GST CLASSIFICATIONS
    • Lecture 3 :
    • 3. GST Revenue Sharing Rations between Centre & State Govt's
    • Lecture 4 :
    • 4. Key Points about GST Council
    • Lecture 5 :
    • 5 Know Your PAN CARD STATUS
    • Lecture 6 :
    • 6. GST Registration - Live (Case Study 1)
    • Lecture 7 :
    • 7. GST Registration - Filing Clarifications
    • Lecture 8 :
    • 8. GST Registration - Tracking Submitted Applications
    • Lecture 9 :
    • 9. Viewing Submitted Applications - GST Registration
    • Lecture 10 :
    • 10. GST Download Registration Certificate in a Minute
    • Lecture 11 :
    • 11. GST Registration - Core Filed Amendments
    • Lecture 12 :
    • 12. GST Registration - Non-Core Filed Amendments
    • Lecture 13 :
    • 13. GST Registration -CANCELLATION
    • Lecture 14 :
    • 14. Opting Withdrawal of Composition Levy in GST Portal
    • Lecture 15 :
    • 15. GST Tax Practitioner Registration
    • Lecture 16 :
    • 16. Introduction to GST Returns
    • Lecture 17 :
    • 16.z.GST Returns - An Introduction Video
    • Lecture 18 :
    • 17. a. GSTR-1 Tables I Understanding GSTR-1 Basic & Amendments Tables-new new
    • Lecture 19 :
    • 17. GSTR-1 Filing ( GST-Regular) Offline Online Methods Explained with Live Dat
    • Lecture 20 :
    • 18.A. GSTR-1 Filing using TallyPrime
    • Lecture 21 :
    • 18.Z. Nil GSTR-1 filing I No Sales
    • Lecture 22 :
    • 19. How to Reconcile GSTR-2 in TallyPrime
    • Lecture 23 :
    • 20. Z.GSTR - 3B Filing
    • Lecture 24 :
    • 21. GSTR-3B Filing I Online and Offline methods.mp4
    • Lecture 25 :
    • 20. GST Tax Computation & Tax Adjustments.mp4
    • Lecture 26 :
    • 22. Generate E-Way Bills Creation, Alter & Cancellation Online Offline methods
    • Lecture 27 :
    • 23. E-Way Bill Registration, Generation, Update Vehicle Number, Cancellation and
    • Lecture 28 :
    • 24.GST Application for Refund
  • Section 5 : Income Tax & TDS 10 Lectures 01:01:31

    • Lecture 1 :
    • 1 What is Tax, when Taxes Introduced in India
    • Lecture 2 :
    • 2 Direct Taxes Vs Indirect Taxes
    • Lecture 3 :
    • 3 Income Tax Basics, Ways of collecting Income Tax
    • Lecture 4 :
    • 4 What is TDS, TDS Basics
    • Lecture 5 :
    • 4. Income Tax Slabs
    • Lecture 6 :
    • 5 Who can deduct TDS
    • Lecture 7 :
    • 6 How to Apply for TAN
    • Lecture 8 :
    • 7. TDS Process Over View
    • Lecture 9 :
    • 8 TDS Payment
    • Lecture 10 :
    • 9 TDS Returns
  • Section 6 : MX - Excel Full Course 83 Lectures

    • Lecture 1 :
    • 1. Introduction to Microsoft Excel-Course-English
    • Lecture 2 :
    • 2. How to Open Close Save Excel Application2
    • Lecture 3 :
    • 3. How to Open and Close MS Excel, What is Menus, Tools, Sheets, Columns, Rows &
    • Lecture 4 :
    • 4. Excel Commonly Used Formulars I Sum I Substraction I Avg I Percentage I Multi
    • Lecture 5 :
    • 5. Learn How to Create Tabs, Groups and add Toll to it in MS Excel
    • Lecture 6 :
    • 6. Excel - Editing Data I over writing I editing I find & replace I undo & redo
    • Lecture 7 :
    • 8. MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
    • Lecture 8 :
    • 10. MS Excel - Characteristics of Cell
    • Lecture 9 :
    • 11. Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsfot
    • Lecture 10 :
    • 7. MS Excel - Home Tab - Group Clip Board Explained - Copy, Cut, Paste, Copy as
    • Lecture 11 :
    • 12. MS Excel - Text to Columns
    • Lecture 12 :
    • 13. MS Excel - Comments - add, edit, delete & Show all
    • Lecture 13 :
    • 14. MS Excel - Fill Series - with formatting, without formatting & more
    • Lecture 14 :
    • 15. Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add,
    • Lecture 15 :
    • 16. Fill Series - Flash Fill
    • Lecture 16 :
    • 17. MS Excel - How to Hide and Unhide Rows, Columns, Sheets
    • Lecture 17 :
    • 18. Freeze Panes - Top Row, Columns & Multiple Rows & Columns
    • Lecture 18 :
    • 19. MS Excel - Filters - Learn How to Use Filter to analysis a Big Data
    • Lecture 19 :
    • 20. MS Excel - Split Sheet Window
    • Lecture 20 :
    • 21. MS Excel - How to Insert & Delete Cells, Rows, Columns
    • Lecture 21 :
    • 22. MS Excel - Working with Sheets
    • Lecture 22 :
    • 23. MS Excel - View Sheets Side by Side from One Excel File
    • Lecture 23 :
    • 24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
    • Lecture 24 :
    • 25. MS Excel - Sheet & Cells Protection
    • Lecture 25 :
    • 26. MS Excel - Create & Remove Drop Down List
    • Lecture 26 :
    • 27. Concatenate - Join Multiple Text Strings into ONE
    • Lecture 27 :
    • 28. MS Excel - Trim Functions - Remove unnecessary Elements from strings
    • Lecture 28 :
    • 29. MS Excel - Print Formulas Left, Right, Middle
    • Lecture 29 :
    • 30. MS Excel - Date Related Formulas
    • Lecture 30 :
    • 31. MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New D
    • Lecture 31 :
    • 32. MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
    • Lecture 32 :
    • 33. MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date,
    • Lecture 33 :
    • 34. MS Excel - Conditional Formatting
    • Lecture 34 :
    • 35. Introduction to Data Validation - Time limitation
    • Lecture 35 :
    • 35. Data Validation - Restrict Cells, Input & Error Message, Drop Down List, Da
    • Lecture 36 :
    • 36. Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Info Me
    • Lecture 37 :
    • 37. MS Excel - Data Validation - Dependent - Multiple Drop Down Lists
    • Lecture 38 :
    • 38. MS Excel - Import Data from Web
    • Lecture 39 :
    • 39. MS Excel - Import Data from Text Document - with Auto Refresh
    • Lecture 40 :
    • 40. MS Excel - Import - Text, Word, PPT, Jpeg, Video, PDF & More Objects
    • Lecture 41 :
    • 41. MS Excel - Format Multiple Sheets at a time
    • Lecture 42 :
    • 42. MS Excel - 3d Sum
    • Lecture 43 :
    • 43. MS Excel - Consolidate ( 3d Sum extension)
    • Lecture 44 :
    • 44. MS Excel - Age Calculator in Multiple Ways - Exclusive formula
    • Lecture 45 :
    • 45. MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
    • Lecture 46 :
    • 46. MS Excel - Charts - Pie Charts - Create & Customize
    • Lecture 47 :
    • 47. MS Excel - Charts - Columnar Charts
    • Lecture 48 :
    • 48. Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I Comp
    • Lecture 49 :
    • 49. Logical Test - IF Function
    • Lecture 50 :
    • 50. Logical Functions - Nested IF - Learn How to work with Nested if Formula
    • Lecture 51 :
    • 51. Logical Functions - AND function
    • Lecture 52 :
    • 52. Logical Function - Not & IFERROR
    • Lecture 53 :
    • 53. Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, FormulaT
    • Lecture 54 :
    • 54. Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Av
    • Lecture 55 :
    • 55. Formulas - sumproduct, mround, floor, ceiling
    • Lecture 56 :
    • 56. Student Mark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Statu
    • Lecture 57 :
    • 57. Vlookup - Formula, Functionality, Rules, Approximate & Exact Match & more
    • Lecture 58 :
    • 58. Hlookup - Formula, Functionality, Rules, Approximate & Exact Match & more
    • Lecture 59 :
    • 59. Download, Add & use X Lookup New Formula in MS Excel
    • Lecture 60 :
    • 60. X Lookup - Introduction
    • Lecture 61 :
    • 60. X Lookup New Formula in MS Excel
    • Lecture 62 :
    • 61. Index Formula - Find a Position of the Value, and Call cells references
    • Lecture 63 :
    • 62. Match Formula - Find Position of the Value
    • Lecture 64 :
    • 63. Pivot Table Introduction & Basics of Pivot Table
    • Lecture 65 :
    • 64. Create a PivotChart from Table & Pivot Table
    • Lecture 66 :
    • 65. Pivot Table - Use slicers to filter data
    • Lecture 67 :
    • 66. Pivot Table, Charts, Progress Dashboard
    • Lecture 68 :
    • 67. MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
    • Lecture 69 :
    • 68. Working with Tables
    • Lecture 70 :
    • 69. Create & Maintain Registers - Using Group Sheets, Drop Down Lists, Data Lavi
    • Lecture 71 :
    • 70. Share a workbook with Co Authors, Employees or with Anyone
    • Lecture 72 :
    • 71. MS Excel - Copy Cells, Move Cells
    • Lecture 73 :
    • 72. Commission Calculation in MS Excel
    • Lecture 74 :
    • 73. Attendance Sheet Preparation in MS Excel
    • Lecture 75 :
    • 74. Attendance Sheet Extension - Salary Calculation with CA, DA, Commission, Adv
    • Lecture 76 :
    • 75. Creating Professional Invoice in Excel
    • Lecture 77 :
    • 76. Excel to SMS Free (1)
    • Lecture 78 :
    • 77. VBA & Macro Introduction
    • Lecture 79 :
    • 78. MS Excel - Enabling Developer Tab
    • Lecture 80 :
    • 81. Basics of Macros - Record & Run1
    • Lecture 81 :
    • 82. Saving Macros
    • Lecture 82 :
    • 83. MS Excel - VBA Coding - Disply Message BOX
    • Lecture 83 :
    • 9. Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

8017 Course Views

1 Courses

  • learn-ms-excel-from-basic-to-advance

    Learn MS Excel From Basic to Advanc...

    By : Ashwini Bissa

    Lectures 14 Beginner Level 0:24:50
  • odoo-purchases-sales-inventory-with-accounting-modules

    Odoo: Purchases, Sales, Inventory w...

    By : Quantic Statistics R spatial analysis

    Lectures 13 Beginner Level 3:20:52
  • hotel-management-course-analyse-financial-statements-and-performance

    Hotel Management Course - Analyse f...

    By : Manish Gupta

    Lectures 34 Intermediate Level 2:58:18
  • how-to-carry-out-financial-analysis-as-a-banker

    How to carry out Financial Analysis...

    By : CA N Raja Natarajan

    Lectures 25 Intermediate Level 2:57:27
  • advanced-capital-budgeting-improve-long-term-roi

    Advanced Capital Budgeting: Improve...

    By : Blair Cook

    Lectures 7 Intermediate Level 0:54:52
  • envision-the-future-financial-modeling-using-excel

    Envision the Future: Financial Mode...

    By : Blair Cook

    Lectures 8 Intermediate Level 1:32:15
Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Create New Password
Enter your email address and we'll send you a link to reset your password.