This plan includes
- Limitedfree coursesaccess
- Play & PauseCourse Videos
- VideoRecorded Lectures
- Learn onMobile/PC/Tablet
- Quizzes andReal Projects
- Lifetime CourseCertificate
- Email & ChatSupport
What you'll learn?
- you will learn TallyPrime+Tally.ERP9+GST+IncomeTax+TDS+MS Excel
Course Overview
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
Pre-requisites
- a desire to learn new skills
Target Audience
- A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Professional & Business Management Sectors.
Curriculum 275 Lectures 24:49:34
Section 1 : Accounting Basics
- 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
- 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
- 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
- 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
- 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 : MS Excel - Beginner to Advanced
- Lecture 1 :
- 1. MS Excel - Launching - Basics of Excel Main Dashboard, Interface and many mor
- Lecture 2 :
- 2. MS Excel - Cells, Rows, Columns and Sheets Basics
- Lecture 3 :
- 3. MS EXCEL - Home Tab Basics - Editing and Formatting
- Lecture 4 :
- 4. Copy Paste Functions - All Types
- Lecture 5 :
- 5. Home Tab - Customisation of Tabs
- Lecture 6 :
- 6. MS Excel - Speak Cells
- Lecture 7 :
- 7. Text to Columns - MS Excel Split Tool
- Lecture 8 :
- 8. Characteristics of a Cell and Cell References
- Lecture 9 :
- 9. Comments in MS Excel - Insert, Edit, Paste and Customise Comment Background
- Lecture 10 :
- 10. Fill Series - Basics - Fill Data only, Fill Format, Fill Weekdays and more
- Lecture 11 :
- 11. Fill Series-Advanced - Fill Interval, Custom Lists and Fill side
- Lecture 12 :
- 12. Fill Series - Flash Fill
- Lecture 13 :
- 13. MS Excel-How to Hide and Unhide Rows Columns Sheets
- Lecture 14 :
- 14. Freeze Panes-Top Row Columns & Multiple Rows & Columns
- Lecture 15 :
- 15. MS Excel-Filters-Learn How to Use Filter to analysis a Big Data
- Lecture 16 :
- 16. MS Excel- Split Sheet Window
- Lecture 17 :
- 17. MS Excel-How to Insert & Delete Cells Rows and Columns
- Lecture 18 :
- 18. MS Excel-Working with Sheets
- Lecture 19 :
- 19. MS Excel-View Sheets Side by Side from One Excel File
- Lecture 20 :
- 20. MS Excel- Workbook Protection- Learn how to setup a Password to open Excel F
- Lecture 21 :
- 21. MS excel- sheet & cells protection
- Lecture 22 :
- 22. MS Excel - Concatenate-Join Multiple Text Strings into ONE
- Lecture 23 :
- 23. MS Excel-Trim_Functions- Remove unnecessary Elements from strings
- Lecture 24 :
- 24. MS Excel- Print Formulas - Left Right Middle
- Lecture 25 :
- 25. MS Excel - Date Related Formulas
- Lecture 26 :
- 26. MS Excel-Print Page Setup Margins Size Excel to PDF
- Lecture 27 :
- 27. MS Excel-Page Header & Footer Add Page Numbers Logo Report Name Date Time &
- Lecture 28 :
- 28. MS Excel - Conditional Formatting
- Lecture 29 :
- 29. MS excel -import data from web
- Lecture 30 :
- 30. MS Excel-import data from text document with auto refresh
- Lecture 31 :
- 31. MS Excel-import-text word ppt jpeg video- pdf & more objects
- Lecture 32 :
- 32. MS Excel-format multiple sheets at a time
- Lecture 33 :
- 33. MS Excel - HyperLinks - Links to Sheet-File-WebPages and more
- Lecture 34 :
- 34. MS Excel Logical Functions Test Functions
- Lecture 35 :
- 35. MS Excel IF formulas - IF - IFand - IFor - nestedIF - IFerror
- Lecture 36 :
- 36. MS Excel - Student Marksheet Calculation using Sum, Nested IF, Rank, Status
- Lecture 37 :
- 37. V Lookup - Exact Match and Approximate Match
- Lecture 38 :
- 38. MS Excel - H Lookup
- Lecture 39 :
- 39. MS Excel - X Lookup - Download and Add to your Excel
- Lecture 40 :
- 40. X Look up - Basics
- Lecture 41 :
- 41. MS Excel - X lookup Formula
- Lecture 42 :
- 42. MS Excel - EMI and Loan Statement Preparation - PMT PPMT IPMT
- Lecture 43 :
- 43. MS Excel - DropDownList Creation - Dependent List - Independent List - Data
- Lecture 44 :
- 44. Data Validation - Date-List-Whole Number - Text Length-Nested If-Ifs and mor
- Lecture 45 :
- 45. Macro Part1 - Designing a Form
- Lecture 46 :
- 46. Macro Part2 - Recording and Running a Macro
- Lecture 47 :
- 47._VBA_&_Macro_Introduction
- Lecture 48 :
- 48. 3D SUM - Calculate Multiple Sheet and analyse
- Lecture 49 :
- 49. CONSOLIDATE - 3D SUM EXTENSION
- Lecture 50 :
- 50. Age Calculator - Exclusive and Inclusive
- Lecture 51 :
- 51. BAR CODE GENERATOR in MS Excel
- Lecture 52 :
- 52. Charts - Pie Charts
- Lecture 53 :
- 53. Charts - Bar Charts and Column Charts
- Lecture 54 :
- 54. Auditing Tools - Trace Precedents-Dependent-Show Formula and more
- Lecture 55 :
- 55. Statistical Formulas - Sum-Sumif-sumifs-avg-avgif-avgifs-count-countif-count
- Lecture 56 :
- 56. INDEX
- Lecture 57 :
- 57. MATCH
- Lecture 58 :
- 58. PIVOT TABLE - BASICS
- Lecture 59 :
- 59. Create_a_Pivot Chart_from_Table_&_Pivot_Table
- Lecture 60 :
- 61. Sales Register Maintenance
- Lecture 61 :
- 62. commission calculation
- Lecture 62 :
- 63. Attendance Sheet Preparation
- Lecture 63 :
- 64. Salary Calculation
- Lecture 64 :
- 65. Creating_Professional_Invoice_in_Excel
- Lecture 65 :
- 60. Pivot_Table_-_Use_slicers_to_filter_data
Our learners work at
Frequently Asked Questions
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?
Instructor
8660 Course Views
1 Courses