About Course
A Compulsion Course for Accounting, Financial, MIS, Data Analysis, Tax Professional, Auditors & Business Management sectors
What Will You Learn?
- Basics of Accounting
- TallyPrime
- Accounting Management
- Inventory Management
- GST
- Payroll Management
- TDS, TCS Management
- Income Tax
- MS Excel
- *You will earn a Certificate of Completion with QR Code, Sharable Link, Downloads in PDF, JPEG
Course Content
Free Sample Videos
-
01:32
-
04:58
-
36:03
-
05:52
-
10:07
-
26:50
S1: Basics of Commerce, Accounting
-
S1.1 What is Commerce
01:32 -
S1.2 What is Accounting, Why do we need it
02:49 -
S1.3 Double Entry Accounting System Steps, Structure
08:15 -
S1.4 Golden Rules of Accounts
03:20 -
S1.5 Rules of Accounts with Journals
10:54 -
S1.6 Fundamentals of Accounts
12:08
S2. Course Tips, Download Materials and Practice Notes
-
S2.2 Tally Certification awareness video
06:03 -
S2.1 Download Material Here
00:00
S3. TallyPrime Basics
-
S3.1 Tally Overview – History, Advantages
04:58 -
S3.2 Tally Prime – License Modules and Pricing
04:13 -
S3.3 Tally Rental License Request
02:18 -
S3.4 Download and Installation, Update TallyPrime
05:53 -
S3.5 Launching TallyPrime – Education Mode & Activating License
02:53 -
S3.6 Creating New Company, Alteration, Deletion and Change default data saving path
10:46 -
S3.7 TallyPrime Pre-defined Vouchers-Introduction
02:27 -
S3.8 Recording Purchases and sales
17:07 -
S3.9 Recording Contra, Receipt and Payment Vouchers
14:37 -
S3.10 Recording Journals in TallyPrime
07:17 -
S3.11 How to update Opening balance for Ledgers, Opening Stock for Items
07:21 -
S3.12 Group Company Creation in TallyPrime
09:25 -
S3.13 Tally Data Recording Methods
08:55
S4. Billing in TallyPrime with GST
-
S4.1 What is GST-a short Introduction to GST
04:03 -
S4.2 GST Classifications and Place of Supply
02:42 -
S4.3 Recording GST Purchases & Sales – Traditional Method
36:03 -
S4.4 Recording GST with Auto Billing , Exclusive GST Ledgers for Input and Output
06:36 -
S4.5 Billing Configuration – Company Logo
03:15 -
S4.6 Billing Configuration – Additional Description for Stock items & Ledgers
02:58 -
S4.7 Billing Configuration – Enable Rate Inclusive of Taxes column
02:49 -
S4.8 Billing Configuration – Update Sales Voucher Numbering
02:47 -
S4.9 Printing Preferences-Cust Seal and Signature, Jurisdiction, Bank Details, Invoice Status
04:51 -
S4.10 Optimize Printing Paper Size
04:01 -
S4.11 Recording GST Services I Sales and Purchases of Services in TallyPrime
09:03 -
S4.12 Recording GST Expenses Claimable and Non-claimable
10:13 -
S4.13 Recording GST Assets – claimable and non-claimable
08:36
S5. GST Filing, E-Invoice & E-waybill generations
-
S5.1 Understanding GST Returns & Types
10:03 -
S5.2 GST Tax Computation and Adjustments
06:20 -
S5.3 Learn GSTR-1 Tables
10:54 -
S5.4 GSTR-1 Filing using TallyPrime
12:33 -
S5.5 Filing Nil-GSTR-1 I when ther is no Sales
01:37 -
S5.6 GSTR-1 Amendments I Modify Previous Months Invoices
03:16 -
S5.7 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods
21:54 -
S5.8 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary – Adjustments
07:43 -
S5.9 E-Way Bill-Registration
03:30 -
S5.10 E-WAYBILL Generation, Cancellation, Update and more
06:56 -
S5.11 E Invoice Introduction
02:13 -
S5.12 E-Invoice – GSTIN Registration of E Invoice Portal
01:02 -
S5.13 E-Invoice Enablement for GSTIN on E Invoice Portal
02:31 -
S5.14 E-Invoice – API User Creation for Your Accounting Software
03:38 -
S5.15 Generate E-Invoice using Tally – Generate and E-Invoice ,Print within Tally using API Logins
05:06 -
S5.16 E – Invoice Cancellation in Tally as well as E-invoice Portal
02:36 -
S5.17 E-Invoice Generation – Tally to JSON , JSON Manual Upload on E Invoice Portal _ if API logins are not created
04:09 -
S5.18 E-Invoice Generation Using Official Excel kit – Excel to JSON, JSON upload on E-Invoice Portal
02:40 -
S5.19 GST Composition scheme introduction, Slabs, Eligibility
09:00 -
S5.20 GST CMP-08 Filing – Composition GST Return Filing
07:17
S6. Inventory Management
-
S6.1 Inventory Management – Introduction, Importance, Advantages
04:21 -
S6.2 Creation of Unit of Measurement
02:32 -
S6.3 Stock Group – Creation and Alteration’
02:51 -
S6.4 Stock Category – Creation and Alteration
01:58 -
S6.5 Stock Items – Creation and Alteration
03:35 -
S6.6 Activation of Batches for Stock Item
02:36 -
S6.7 allocation of batch details in purchase invoice
06:43 -
S6.8 selling of stock items from batch and identifying of expired batch in sales invoice, printing batch info
07:07 -
S6.9 Returning of Expired Batch Stock Item
03:44 -
S6.10 Activating Price Levels
01:47 -
S6.11 defining price levels, creating price list, usage of price list in sale voucher
07:17 -
S6.12 Revise Price List
01:49 -
S6.13 Different Types of Inventory Valuations
02:57 -
S6.14 Activation of Purchase Order and Sales Order
02:58 -
S6.15 Activation of Delivery & Receipt Notes
04:36 -
S6.16 Activation of Debit & Credit Note
01:44 -
S6.17 purchases management – purchase order, receipt note, purchase, purchase returns
17:08 -
S6.18 Sales Management – Sales Order, Delivery Note, Sales, Sales Return
08:45 -
S6.19 Creation of Godown
01:35 -
S6.20 How to Create and Manage Multiple Godowns in TallyPrime
05:33
S7. Bill-wise Accounts I Bills Receivables and Payables Management
-
S7.1 Billwise Accounts – An Introduction
05:23 -
S7.2 Bill-wise Accounts – Purchases
12:29 -
S7.3 Bill-wise Accounts – Sales
06:00 -
S7.4 Bill-wise Accounts – Tracking Overdue Supplies
04:39 -
S7.5 Bill-wise Accounts – Advances Management
06:06 -
S7.6 How to view and analyse bills outstanding reports in tallyprime
04:34
S8. TallyPrime with Banking
-
S8.1 Cheque book configuration in tallyprime
10:46 -
S8.2 Cheque Printing in TallyPrime
05:13 -
S8.3 Enabling All Banking Transaction Types
02:50 -
S8.4 An introduction to post dated cheques management
06:06 -
S8.5 Post dated cheques management in tallyprime
16:19 -
S8.6 Applying for TallyPrime License
01:44 -
S8.7 Introduction to bank reconciliation process in tallyprime
05:41 -
S8.8 Bank reconciliation in tallyprime
22:03 -
S8.9 How To Do Auto-Bank Reconciliation
04:38
S9: Tally Updates, New Releases, Enhancements
-
S9.1 Calculator Usage in TallyPrime
04:07 -
S9.2 Alternative unit of Measurement
04:09 -
S9.3 Part Numbers in TallyPrime
02:34 -
S9.4 Standard Rate Setups in Tallyprime
03:42 -
S9.5 Export Reports from Tally I Excel, PDF, JPEG
04:40 -
S9.6 Group Company – Creation, Alteration
09:25 -
S9.7 Release 5.0 How to Create Ledgers using GSTIN, Import GSTIN
03:37 -
S9.8 Release 5.0 How Check Party’s GST Filing Status
01:41 -
S9.9 Release 5.0 How to View ITC at Risk Balance
02:43 -
S9.10 Release 5.0 How to Enable Strip View
02:30 -
S9.11 Release 5.0 How Print and Export Multi Vouchers
06:10 -
S9.12 Release 5.0 Dashboards – Report Analysis
05:47 -
S9.13 Release 5.0 How to Download GST Returns Data
05:20 -
S9.14 Release 5.0 GSTR-1 Filing within Tally
02:57 -
S9.15 Release 5.0 Download & Installation of Edit Log
05:01 -
S9.16 Release 5.0 Tracking data Alterations using Edit Log – for Ledgers, Items and Vouchers
12:20 -
S9.17 User Management – Admin Creation, Edit Log, Audit Features
07:04 -
S9.18 User Management – User Creation, Edit Log, Audit Features
04:46 -
S9.19 User Management – User Roles
05:56 -
S9.20 User Management – Password Policy
05:14 -
S9.21 Access Tally Data on Cloud – Browser Access
02:50
S10. TallyPrime Closing
-
S10.1 Golden Rules of Accounts, Treatment Statements
03:47 -
S10.2 Capital and Drawings Related Adjustments
20:18 -
S10.3 Party Related Adjustments – Settlement Discounts, Bad debts, Reserve for Baddebts
21:08 -
S10.4 Appreciation and Depreciation related adjustments
09:18 -
S10.5 Prepaid and Outstanding related adjustments
08:50 -
S10.6 TallyPrime Closing – Backup, Split Company, Setup New FY
12:48
S11. Case Studies & Assignments
-
S11. 1 Tally Comprehensive Case – Test Paper-1
02:26:07
S12. GST Portal + E Invoice Portal + E Way Bill Portal Concepts
-
S12.1 What is GST-a short Introduction to GST
04:03 -
S12.2 GST Classifications and Place of Supply
02:42 -
S12.3 Understand GST Number
04:28 -
S12.4 GST Registration Threshold Limits and Documents Required for GST Registration
05:50 -
S12.5 GST Registration-Proprietorship and Partnership
37:44 -
S12.6 Track Submitted Application Status
02:20 -
S12.7 GST Registration – Filing Clarifications
04:01 -
S12.8 GST Practitioner Registration
12:18 -
S12.9 How to Download GST Certificate
02:12 -
S12.10 GST Amendments- Core Fields and Non Core Fields
08:23 -
S12.11 GST – Opting Regular or Composition
06:40 -
S12.12 GST Cancellation and Revocation
06:25 -
S12.13 What is GST Returns, Types of GST Returns
10:03 -
S12.14 Learn GSTR-1 Tables
10:54 -
S12.15 GSTR-1 Filing using TallyPrime
12:33 -
S12.16 Filing Nil-GSTR-1 I when there is no Sales
01:37 -
S12.17 GSTR-1 Amendments I Modify Previous Months Invoices
03:16 -
S12.18 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods
21:54 -
S12.19 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary – Adjustments
07:43 -
S12.20 GST Composition scheme introduction, Slabs, Eligibility
08:60 -
S12.21 GST CMP-08 Filing – Composition GST Return Filing
07:17 -
S12.22 GST Refund- Compete Process
13:48 -
S12.23 How to Generate E-way bill, Registration, Print, Cancellation, Masters Creation, User Creation, 3 methods
25:14 -
S12.24 E Invoice Introduction
02:13 -
S12.25 E-Invoice – GSTIN Registration of E Invoice Portal
01:02 -
S12.26 E-Invoice Enablement for GSTIN on E Invoice Portal
02:31 -
S12.27 E-Invoice – API User Creation for Your Accounting Software
03:38 -
S12.28 Generate E-Invoice using Tally – Generate and E-Invoice ,Print within Tally using API Logins
05:06 -
S12.29 E – Invoice Cancellation in Tally as well as E-invoice Portal
02:36 -
S12.30 E-Invoice Generation – Tally to JSON , JSON Manual Upload on E Invoice Portal _ if API logins are not created
04:09 -
S12.31 E-Invoice Generation Using Official Excel kit – Excel to JSON, JSON upload on E-Invoice Portal
02:40
S13. Complete Payroll Management
-
S13.1 What is Payroll I An Introduction
02:21 -
S13.2 What is Basic Salary, methods of calculating basic salary
08:23 -
S13.3 What is DA, methods of Calculating DA
13:36 -
S13.4 What is HRA, how to Calculate HRA, Taxability and Exemption Calculation
06:54 -
S13.5 Payheads CA, TA, LTA I Conveyance Allowance I Travel AllowanceI I Leave TA
06:24 -
S13.6 EPF I Employee Provident Fund I Calculation I Employee and Employer Contributions I Taxability
20:53 -
S13.7 ESI I Employee State Insurance I Rules I Percentages I Contribution Period I
11:22 -
S13.8 What is Gratuity I Calculation of Gratuity I Taxability I Ceiling Limit
07:12 -
S13.9 Bonus Act 1965 I What is Bonus, How to Calculate, Taxability
21:40 -
S13.10 Income Tax on Salary I TDS Computation, Cess, Surcharges, Salary Increment Cases
33:43 -
S13.11 Professional Tax – Stat-wise I Applicability I Slabs
06:12 -
S13.12 CTC vs Gross Salary vs Net Salary
05:14 -
S13.13 Attendance Sheer Preparation I Present, Paid Leaves, Absents, Holidays using Countf, Countif, Sum Formulas with Data Validation
16:32 -
S13.14 Complete Payroll Processing I Basic, DA, HRA, CA, TA, LTA, Bonus, PF, ESI, PT,TDS, cess, Surcharge, Gross Salary, Net Salary
01:12:40 -
S13.15 PaySlip Generation from Paysheet in MS Excel
21:54 -
S13.16 TDS Deposit on Income Tax Portal
14:46 -
S13.17 Employer Contributions PF ESI
15:20 -
S13.18 EPF,ESI Establishment Registration
30:04 -
S13.19 Add – Exit of Employee Records on EPFO website
09:45 -
S13.20 EPF Returns Prepration, Filing
24:47 -
S13.21 EPF Nill Return Filing
02:36 -
S13.22 How to Add Employee in ESI website I generate IP Number
06:10 -
S13.23 ESI Returns Preparation and Filing
07:30 -
S13.24 Tally Prime-Step-1 Creation of a Company Enable Payroll
05:50 -
S13.25 Tally Prime Step-2 Creation of Employee Groups and Employees
08:09 -
S13.26 Tally PrimeStep-3 Creation of Attendances Types
05:21 -
S13.27 Tally Prime Step-4 Part-1 Creation of Pay Heads Basic, DA, HRA, CA, Variables, PF, ESI
44:50 -
S13.28 Tally Prime Step-4 Part-2 Creation of Pay Heads Income Tax, Cess, Sur-charge, Salary Payable
37:02 -
S13.29 Tally Prime Step-5 Define Salary Details
05:52 -
S13.30 Tally Prime Step-6 Payroll Monthly Routine – Attendance, Calculate Salary, paymen advise, Payments
18:34
S14. TDS & TCS Management
-
S14.1 Ways of Collecting Income Tax- Self Assessment Tax- Advance Tax, TDS, TCS C1
26:50 -
S14.2 Know Basic Terms used in TDS and TCS
06:20 -
S14.3 TDS Process Overview I Cycle of TDS
11:32 -
S14.4 TDS Deposits – Payment Due Dates , Penalties
02:24 -
S14.5 TDS Returns Forms Dues Dates, Penalties
09:43 -
S14.6 TDS Certificates Form 16-16a
03:15 -
S14.7 How to Apply for TAN – Form 49B
08:13 -
S14.8 VV Imp PAN and TAN Registration ON INCOME TAX PORTAL – first time users
09:42 -
S14.9 VV Imp TAN Registration on TDS Traces Portal
07:56 -
S14.10 TDS Case Study-1
48:46 -
S14.11 TDS Case Study-2
23:59 -
S14.12 TDS Case Study-3
24:09 -
S14.13 TDS Returns – Download Required Softwares, CSI File
10:07 -
S14.14 TDS Returns – Preparation and Filing 26Q
23:26 -
S14.15 How to View Submitted TDS Returns and Collect Token RRR Number on Income Tax Portal
01:36 -
S14.16 How to View TDS Return Status on TDS Traces Portal
01:29 -
S14.17 How to Download TDS Certificates Form 16A
04:30 -
S14.18 TDS on Salary – Computation
37:02 -
S14.19 TDS Deposits – Single and Multiple Employees – Challan Maintenance
21:00 -
S14.20 TDS Returns 24Q – Download Required Softwares and CSI File
05:36 -
S14.21 TDS Returns – 24Q preparation and Filing
22:43 -
S14.22 Download Form 16 on TDS Traces Portal
04:56 -
S14.23 How to Register PAN on TDS Traces Portal – Using Aaddhar Info, Deductos Info, Challan Info – C1
15:01 -
S14.24 How to Download Provisional Form 16-16A from TDS Traces Portal – C1
05:50 -
S14.25 Introduction to TCS I Cycle
06:28 -
S14.26 TCS Case Study-1 I Collection and Deposit
22:27 -
S14.27 TCS Case Study-2 I Collection and Deposit
06:57 -
S14.28 TCS Case Study-3 I Collection and Deposit
05:23 -
S14.29 TCS Returns Preparation and Filing 27EQ
15:16
S15. Income Tax Management
-
S15.1 What is Tax, History of Taxes in India
03:46 -
S15.2 Direct Taxes vs Indirect Taxes
02:45 -
S15.3 What is ITR, When to File ITR Forms
04:44 -
S15.4 Types of ITR Forms and Applicability
21:40 -
S15.5 Ways of Collecting Income Tax- Self Assessment Tax- Advance Tax, TDS, TCS
26:50 -
S15.6 Taxation Overview on Individuals, Firms, Companies, Political Parties
22:13 -
S15.7 Old vs New Slabs comparison
13:23 -
S15.8 PAN Registration on Income Tax Portal
05:17 -
S15.9 How to Check 26AS and AIS
07:03 -
S15.10 Advance Tax – Calculation and Deposit on Income Tax Portal
26:25 -
S15.11 How to Register PAN on TDS Traces Portal – Using Aaddhar Info, Deductos Info, Challan Info
15:01 -
S15.12 How to Download Provisional Form 16-16A from TDS Traces Portal
05:50 -
S15.13 ITR-1 Draft Preparation and Computation of tax-new
50:52 -
S15.14 ITR-1 Filing – Case-1 – Taxable Income but No Tax Liability
15:49 -
S15.15 ITR-1 Filing – Case-2 NO Taxable Income but TDS Deducted – Apply for Refund
11:08 -
S15.16 ITR-1 Filing – Case-3 Applying for Refund by reducing Taxable Income
10:49 -
S15.17 ITR-1 Detailed Filing with the Help of Computation
01:05:01 -
S15.18 Income Tax Computation – as per 44AD, 44ADA non Audit – for Individuals and Firms Income from Business or Profession
08:41 -
S15.19 Filing Form 10IEA I Opting Old Regime for Individuals having income from Business or Profession
04:44 -
S15.20 ITR-4 Filing for Individuals I Income from Business – Presumptive Taxation
10:04 -
S15.21 Computation – Capital Gains on Property Transfers
25:05 -
S15.22 ITR-2 Filing – Capital Gains from Property Transfer
20:51 -
S15.23 ITR-2 Filing – Capital Gains from Stocks
31:19 -
S15.24 Important Notes on ITR-3 and ITR-4 Selection
12:03 -
S15.25 ITR-3 Filing with as per Book of Accounts
45:44 -
S15.26 ITR-3 Filing Comprehensive Case Study
39:20 -
S15.27 ITR-4 Filing for Individuals and Firms – Presumptive Taxation Scheme
10:34 -
S15.28 ITR-5 Filing Over view Firms, LLPs, AOI, BOI, Co-operative society, Govt Authorities
42:54
MS EXCEL
-
E1.1 How to Open MS Excel
03:06 -
E1.2 Start Screen – Navigating MS Excel
04:28 -
E1.3 User Interface – Navigating MS Excel
08:04 -
E1.4 Home Tab Basic Editing Tools
11:25 -
E1.5 Copy and Paste I using to Multiple Tools in MS EXCEL
11:46 -
E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools
04:55 -
E2.2 Text to Column – Multiple methods
07:25 -
E2.3 Speak Cells – Data Reading Tool
04:00 -
E2.4 Comments – Add, Edit, Delete and Customize
08:23 -
E2.5 Filters in MS Excel
04:24 -
E2.6 Freeze Panes and Split Screen
04:41 -
E3.1 Fill Series – Basics
03:27 -
E3.2 Fill Series – Advanced
07:36 -
E3.3 Fill Series – Flash Fill
05:26 -
E3.4 Conditional Formatting
04:09 -
E3.5 Hyperlinks to Sheets, Webpages, Files
09:00 -
E3.6 Header and Footer Settings
08:26 -
E3.7 Printing and Paper Settings
05:49 -
E3.8 Import data from web
05:47 -
E3.9 Import data from text document with auto refresh
03:08 -
E3.10 Import-text word ppt jpeg video- pdf & more objects
08:03 -
E4.1 Characteristics of a cell
01:45 -
E4.2 Cell References – Relative Ref, Absolute Ref, Mixed Ref
13:58 -
E4.3 Custom View
04:02 -
E4.4 Sheet protection
05:37 -
E4.5 Cell Protection
04:49 -
E4.6 Compare sheets side by side I View Sheets side by side
05:15 -
E4.7 Compare sheets from Multiple Files
02:38 -
E4.8 Working with cells, rows, columns, Specific Size, Auto Fit
09:27 -
E4.9 Working with sheets rename, colour, copy, move, grouping
07:08 -
E5.1 Things to remember before starting formulas
09:41 -
E5.2 SUM
08:51 -
E5.3 SUMIF
05:51 -
E5.4 SUMIFS
08:43 -
E5.5 SUBTOTAL
04:43 -
E5.6 AGGREGATE
03:07 -
E5.7 SUMPRODUCT
03:53 -
E5.8 SUMSQ
03:25 -
E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry
08:06 -
E5.10 DSUM – DATABSE SUM
04:06 -
E5.11 IMSUM vs IMSUB – Complex Data Calculations
03:31 -
E6.1 AVERAGE
01:23 -
E6.2 AVERAGEA
02:43 -
E6.3 AVERAGEIF vs AVERAGEIFS
05:28 -
E6.4 Weighted Average with VBA Code
04:20 -
E7.1 COUNT, COUNTA, COUNTBLANK
03:05 -
E7.2 COUNTIF vs COUNTIFS
04:59 -
E8.1 LOGICAL TEST with Comparative Operators
03:39 -
E8.2 IF
06:03 -
E8.3 IF AND vs IF OR
05:04 -
E8.4 IFS vs NESTEDIF
-
E8.5 IFERROR
03:37 -
E8.6 SWITCH
05:26 -
E9.1 LEFT, RIGHT, MID and LEN
04:45 -
E9.2 FIND vs SEARCH
02:13 -
E9.3 REPLACE vs SUBSTITUTE
05:23 -
E10.1 CONCAT vs CONCATENATE
02:13 -
E10.2 TEXT
09:06 -
E10.3 UPPER, LOWER, PROPER
01:09 -
E10.4 TRIM
01:04 -
E10.5 SPELLNUMBER with VBA code
04:11 -
E10.6 TEXT-TO-NUMBER with VBA code
02:14 -
E11.1 Using TODAY, NOW
03:19 -
E11.2 DATE, DATEVALUE, TIME, TIME VALUE
08:21 -
E11.3 DATEDIF AND EXTRACT YEARS, MONTHS, DAYS, HOURS, MIN, SECONDS
07:33 -
E11.4 Calculating Future and Past Dates -EDATA, EOMONTH, WORKINGDAYS, NET WORKINGDAYS
08:24 -
E11.5 Calculate Days using – DAY, DAYS, NETWORKING DAYS
-
E11.6 Calculate Hours and Hourly Charges
04:46 -
E12.1 PMT – EMI Calculator
05:00 -
E12.2 PPMT, IPMT – Loan Statement Preparation
18:28 -
E12.3 FV – Investment Calculator
03:59 -
E13.1 VLOOKUP – Basics – Rules – Exact Match – Approx Match
11:03 -
E13.2 HLOOKUP – Basics
02:17 -
E13.3 XLOOKUP Function – with VBA Code
03:48 -
E13.4 MATCH Function vs INDEX Function
05:14 -
E13.5 VLOOKUP-Advanced-1-Applying across multiple cells at a time
02:36 -
E13.6 VLOOKUP-Advanced-2-Applying across multiple sheets
03:01 -
E13.7 VLOOKUP-Advanced-3-Applying on large data
09:44 -
E13.8 VLOOKUP-Advanced-4-Applying across multiple workbooks
09:39 -
E14.1 Pivot Table Basics
05:43 -
E14.2 Pivot Table Basics – common mistakes
06:04 -
E14.3 Pivot Tables – Advanced Tips
08:28 -
E14.4 How to Combine Multiple Sheet Data into One
07:02 -
E14.5 Pivot Table on Multiple Sheets, Workbooks
03:33 -
E15.1 MS Excel Charts – Basics – Insert, Data Control, Improve Chart, Change Series
12:21 -
E15.2 Pie Charts
03:43 -
E15.3 Charts – Doughnut Charts
04:31 -
E15.4 Bar Charts
05:47 -
E15.5 Bubble Charts
06:27 -
E15.6 3D Containers or Cylinders or Stacked column
09:45 -
E15.7 2D Map Charts-Basics
05:50 -
E15.8 2D Map Charts-Advanced
01:34 -
E15.9 3D Map Charts – Basics
06:48 -
E15.10 3D Map Charts – Sales with Time lapse, scenes creation
08:08 -
E15.11 3D Maps Charts -Population with Time lapse, scenes creation
05:37 -
E16.1 How to Enable Developer Tap
01:22 -
E16.2 Macros and VBA Basics
06:58 -
E16.3 Macros Example-1
02:11 -
E16.4 Macros Example-2
02:30 -
E16.5 VBA Example-1
02:46 -
E16.6 VBA Example-2
05:00 -
E16.7 VBA CODES
03:22 -
E16.8 VBA CIODES WITH SHORTCUT KEYS EXPLANATAION
03:13 -
E17.1 Student Mark Sheet Calculation
21:02 -
E17.2 Spark Lines
00:38 -
E17.3 Lines For User Forms
01:14 -
E17.4 Data Re-arrangement With Text To Columns
01:07 -
E17.5 Insert Check Boxes
01:06 -
E17.6 Insert Data Forms
01:12 -
E17.7 Auto Borders
01:38 -
E17.8 Wrap Rows With VBA
01:56 -
E17.9 Compare Data Easily
00:42 -
E17.10 Slicer In Excel
01:36 -
E17.11 Adjust Image In Excel
01:17 -
E17.12 Dynamic Search Bar Creation
08:12 -
E17.13 Bar code Creation In Excel
05:09 -
E17.14 Data Consolidation
01:38 -
E17.15 Copy Paste Excluding Hidden Data
00:52 -
E17.16 Delete Bank Cells
00:42 -
E17.17 Advance Selection – Min ,Max
01:05 -
E17.18 Round Roundup Mround
03:10 -
E17.19 Swap Columns Data
01:32 -
E17.20 Sheet controls
01:24 -
E18.1 MS Excel with ChatGPT – Manual Script
05:09 -
E18.2 MS Excel with ChatGPT – upload image
02:23 -
E18.3 MS Excel with ChatGPT – upload and download with formulas
02:12 -
E18.4 MS Excel with AI Tools – Ai-Aided formula Editor
02:51 -
E18.5 MS Excel – Add IN – Wiki Pedia – to collect info
02:16 -
E18.6 MS Excel – Add IN – FRED – ECONOMIC DATA
02:16 -
E18.7 MS Excel -Add IN – Mini Calendar
01:40 -
E18.8 MS Excel -Add IN – Symbols and Characters
01:48 -
E18.9 MS Excel – Chat GPT AI ASK
02:31 -
E18.10 MS Excel – Chat GPT AI FILL
01:21 -
E18.11 MS Excel – Chat GPT AI Translate
01:27 -
E18.12 MS Excel – ChatGPT AI Extract
01:44 -
E18.13 MS Excel – ChatGPT AI Table
01:50 -
E19.1 Data Validation – Basics
06:55 -
E19.2 Drop Down List – Dependent Drop Down List
14:20 -
E19.3 Data Validation – on Student Registration
21:29 -
E20.1 Automation -Student Admission Management
21:30 -
E20.2 Complete Billing Automation, Invoice Design ,Tax Collection
01:13:04 -
E20.3 comparison Table perpetual -Dashboards VS Inter acitve – Dynamic
02:08 -
E20.4 Perpetual-Static Dashboards I Part-1 I Creating KPI Key Performing Indicators
15:32 -
E20.5 Perpetual-Static Dashboards I Part-2 I KPIs to Visualization
26:07 -
E20.6 E20.6 Interactive-Dynamic Dashboards I Creating Connected KPI I Connect Dashboards
27:15 -
E20.7 Financial Reporting Dashboards Sales, Profit, Country wise, Product Wise
20:09
Student Ratings & Reviews
4.8
Total 6 Ratings
5
5 Ratings
4
1 Rating
3
0 Rating
2
0 Rating
1
1 Rating
awsome content
SUPERB MATERIALS
Worthy, really appreciate his teaching on Capital Gain, Tally, Payroll, TDs, TCs
Everyone can try this
Everyone can try this
Totally worth it.
This course was a good match for me.
Good Match for my requirements