VBA Gyan
VBA Gyan
  • 83
  • 65 649
Proper Use of Excel Formulas Part 9 || PMT,PPMT & IPMT Formulas in Excel
In this video, we provide a step-by-step guide to using Excel's financial formulas, including PPMT, IPMT, and PMT. Learn how to calculate your loan EMI and understand the breakdown of principal and interest for each payment. This tutorial is ideal for students, professionals, and anyone interested in mastering financial calculations in Excel.
#finance #emicalculator #excel #excelformulas #exceltutorial
======================
Loan Installment and Interest Calculation in Excel
ua-cam.com/video/uNeq9yj-p-E/v-deo.html
Recuring Deposit Interest Calculation in Excel
ua-cam.com/video/bkF_8GIE6Nk/v-deo.html
Переглядів: 34

Відео

How To Make a Perfect Software in Excel VBA
Переглядів 11114 днів тому
Join us in this engaging video as we explore how to create the perfect software using Excel VBA. Our discussion is guided by a well-prepared PowerPoint presentation that highlights essential topics and strategies for successful software development. Whether you're just starting or seeking to refine your expertise, this video offers a wealth of knowledge to help you master Excel VBA. Tune in and...
Loan Installment and Interest Calculation in Excel
Переглядів 9514 днів тому
Discover how to effectively calculate loan installments and interest in Excel with our step-by-step guide. This video is designed for anyone looking to enhance their financial skills, whether for personal use or professional applications. We will cover key Excel functions that make these calculations straightforward and efficient. Don't miss out on mastering this valuable skill! #excel #excel #...
How To Create Co Operative Housing Society Software in Excel VBA Part 4
Переглядів 52228 днів тому
In this video, we continue our journey into developing cooperative housing society software using Excel VBA, focusing on cash management tools. Part 4 introduces the creation of cash vouchers and cash receipts, essential for maintaining accurate financial records. Follow along as we provide detailed instructions and coding examples to empower you in building a robust software solution for your ...
How To Create Co Operative Housing Society Software in Excel VBA Part 3
Переглядів 247Місяць тому
In this Third part of our series, we teach you how to create cooperative housing society software using Excel VBA. This video covers the Macros or SubProcedures for Fresh Ownership List and Ownership Transfer. Perfect for anyone looking to improve their housing society management through technology.Press Bell Button If You Like This Video.Please watch full video and support me. #excel #exceltut...
How To Create Co Operative Housing Society Software in Excel VBA Part 2
Переглядів 272Місяць тому
In this Second part of our series, we explore how to create cooperative housing society software using Excel VBA. This video covers the initial Macros or SubProcedures when Workbook Open. Perfect for anyone looking to improve their housing society management through technology.Press Bell Button If You Like This Video.Please watch full video and support me. #excel #exceltutorial #vba #excelvba #...
How To Create Co Operative Housing Society Software in Excel VBA Part 1
Переглядів 389Місяць тому
In this first part of our series, we explore how to create cooperative housing society software using Excel VBA. This video covers the initial steps, including setting up your environment and designing necessary Sheets for this software. Perfect for anyone looking to improve their housing society management through technology.Press Bell Button If You Like This Video.Please watch full video and ...
Create A Multi User Login Form with Login Record In Excel VBA
Переглядів 539Місяць тому
With our latest tutorial Create A Multi User Login Form with Login Record In Excel VBA This Tutorial Completes project of multi user login form ,In Which Admin and Users Panel are Seperate. Perfect for beginners and seasoned Excel enthusiasts alike, these tutorials manage Admin or user access to enhance your Excel experience This Video Tutorial is packed with All information about this topic! D...
Proper Use of Excel Formulas Part 8 || Use Of HyperLink in Excel
Переглядів 2552 місяці тому
Discover the versatility of hyperlinks in Excel in this comprehensive tutorial. We will demonstrate how to effectively use hyperlinks to connect your data with external resources, navigate between sheets, and improve the overall functionality of your spreadsheets. This video is perfect for beginners and experienced users alike, providing practical tips and tricks to enhance your Excel skills. D...
Proper Use of Excel Formulas Part 7 || Name Range ,Dynamic Name Range ,Table
Переглядів 1402 місяці тому
Fully Loaded with Ideas of Excel with our latest video, “Proper Use of Excel Formulas: Name Range, Dynamic Name Range, and Table”! 🚀 Whether you're a beginner or looking to refine your skills, this tutorial will guide you step-by-step through Excel's powerful formulas to make your data management seamless and efficient. Learn how to create and use Named Ranges,Dynamic Named Range, and Table💡 Sa...
Proper Use of Excel Formulas Part 6 || Round,RoundUp,RoundDown
Переглядів 612 місяці тому
With our in-depth tutorial on mastering the essential Excel formulas: Round, RoundUp, and RoundDown! Whether you’re a beginner or looking to brush up on your skills, this video will guide you through handy tips and tricks to maintain precision in your data entries. Say goodbye to confusion and hello to efficiency! Join our engaging Excel tutorials as we dive step-by-step into these powerful fun...
Learn VBA Code Part 20 || How to Create Reports in Excel VBA
Переглядів 2682 місяці тому
Elevate your Excel skills by mastering report creation through VBA in this detailed video. We explore various methods that will enable you to automate and customize your reports effectively. Perfect for professionals looking to enhance their data management capabilities, this tutorial provides practical examples and tips to get you started.
Advance Filter for Multiple Criteria in Excel VBA
Переглядів 3033 місяці тому
Join us in this detailed video as we explore the advanced filter feature in Excel VBA, specifically focusing on the application of multiple criteria. This tutorial is designed to equip you with the knowledge to filter your data sets effectively, making your analysis more robust and insightful. Perfect for users at all levels.In this video, we explore the powerful capabilities of Excel VBA by de...
Learn VBA Code Part 19 || How To Use Frames Like a Multipage in Excel VBA
Переглядів 1,1 тис.3 місяці тому
In this video, we explore the innovative technique of using frames to create a multipage experience. Learn how to effectively implement frames in your projects to enhance user engagement and streamline navigation. Whether you're a beginner or an experienced designer, this tutorial will provide you with valuable insights and practical tips to elevate your work. Join us as we dive into the world ...
How To Solve Date Format Issue in Excel VBA
Переглядів 4613 місяці тому
Tired of dealing with date format issues in Excel VBA? You're not alone ,Many Excel VBA Users Suffers from This Headache.Don't Worry Now You're in the right place! In this step-by-step tutorial, we'll unravel the mystery of how to efficiently handle and convert date formats within your Excel VBA projects. Perfect for beginners and pros alike, you'll learn essential techniques that Grows your sp...
How To Create A Multi User Login Form In Excel VBA || Part 2
Переглядів 1,7 тис.3 місяці тому
How To Create A Multi User Login Form In Excel VBA || Part 2
How To Create A MultiUser Login Form In Excel VBA || Part 1
Переглядів 3,9 тис.3 місяці тому
How To Create A MultiUser Login Form In Excel VBA || Part 1
Learn VBA Code Part 18 || Use of InputBox in Excel VBA
Переглядів 2584 місяці тому
Learn VBA Code Part 18 || Use of InputBox in Excel VBA
Learn VBA Code Part 17 || Types of MessageBox in Excel VBA
Переглядів 2124 місяці тому
Learn VBA Code Part 17 || Types of MessageBox in Excel VBA
Recuring Deposit Interest Calculation in Excel
Переглядів 1364 місяці тому
Recuring Deposit Interest Calculation in Excel
How to Create A Simple Login Userform || Excel VBA
Переглядів 3174 місяці тому
How to Create A Simple Login Userform || Excel VBA
Fully Automatic GST invoice with Inventory Management
Переглядів 2465 місяців тому
Fully Automatic GST invoice with Inventory Management
Learn VBA Code Part 16 || How To Use Frame in UserForm
Переглядів 1 тис.5 місяців тому
Learn VBA Code Part 16 || How To Use Frame in UserForm
Proper Use of Excel Formulas Part 5 || VLookup and Index + Match
Переглядів 745 місяців тому
Proper Use of Excel Formulas Part 5 || VLookup and Index Match
Proper Use of Excel Formulas Part 4 || Index, Match, Offset
Переглядів 945 місяців тому
Proper Use of Excel Formulas Part 4 || Index, Match, Offset
Proper Use of Excel Formulas Part 3 || SumIf and SumIfs
Переглядів 765 місяців тому
Proper Use of Excel Formulas Part 3 || SumIf and SumIfs
Proper Use of Excel Formulas Part 2 || CountIf and CountIfs
Переглядів 1416 місяців тому
Proper Use of Excel Formulas Part 2 || CountIf and CountIfs
Proper Use of Excel Formulas
Переглядів 756 місяців тому
Proper Use of Excel Formulas
Conditional Formatting in Excel Part 2
Переглядів 2096 місяців тому
Conditional Formatting in Excel Part 2
Conditional Formatting in Excel
Переглядів 7816 місяців тому
Conditional Formatting in Excel

КОМЕНТАРІ

  • @saurabhkumbhkar8668
    @saurabhkumbhkar8668 День тому

    I want this software

  • @niceacademy-ou4jl
    @niceacademy-ou4jl 7 днів тому

    HOW TO DOWNLOAD

    • @VBAGYAN
      @VBAGYAN 6 днів тому

      Sir No Download I will upload this series Next Month

  • @jashumatipatel5553
    @jashumatipatel5553 8 днів тому

    Very Nice teaching

  • @KavyaPatel-q8e
    @KavyaPatel-q8e 8 днів тому

    Very good

    • @VBAGYAN
      @VBAGYAN 7 днів тому

      Thank you Keep watching

  • @CPIMCT
    @CPIMCT 10 днів тому

    Share this excel file please

    • @VBAGYAN
      @VBAGYAN 9 днів тому

      Sorry Sir I can't do it because most of subscribers and viewers can't watch Full videos and as result ,my channel's targets not met. Please watch Full video and make your own. It's very easy.

  • @prajapatiprakash198
    @prajapatiprakash198 10 днів тому

    Sir Very nice video

    • @VBAGYAN
      @VBAGYAN 10 днів тому

      Thanks and welcome

  • @prajapatiprakash198
    @prajapatiprakash198 10 днів тому

    Sir Ek pura video bhi banana

    • @VBAGYAN
      @VBAGYAN 10 днів тому

      Sure Thank you

  • @rajeshbhaivasava7322
    @rajeshbhaivasava7322 11 днів тому

    Credit co.op socity Softwer ke upar video banao

    • @VBAGYAN
      @VBAGYAN 11 днів тому

      Sir This month is marriage season I will surely upload this series next month

  • @s.k.vyas.2503
    @s.k.vyas.2503 11 днів тому

    Always show enlarged view at the time of explanation for better communication.

    • @VBAGYAN
      @VBAGYAN 11 днів тому

      Thank you for your valuable feedback I will keep in mind

  • @prasadgaonkar5815
    @prasadgaonkar5815 13 днів тому

    File upload karke data kais save hota he uska video create karke do ap no software banavoge usme ready made sheet upload karke mujhe dikho

    • @VBAGYAN
      @VBAGYAN 13 днів тому

      Sir I do not understand what you exactly said.Please watch full video then ask me your query.Thank you

  • @towfeeqallie3654
    @towfeeqallie3654 14 днів тому

    Sir ye toh dekhaya he nahi ki kaise banate hai

    • @VBAGYAN
      @VBAGYAN 13 днів тому

      Sir It's only demo project Once I will complete my youtube channel's target then I will upload. Thank you for watching. Keep watching and support me.

  • @prasadgaonkar5815
    @prasadgaonkar5815 15 днів тому

    Superb software kaise banaya ahe apne ye and kaise kiya he wo batao

    • @VBAGYAN
      @VBAGYAN 15 днів тому

      Thank you for your valuable comment In Next Series I will Teach this software

    • @prasadgaonkar5815
      @prasadgaonkar5815 15 днів тому

      @@VBAGYAN sir iska file share kar sakte ho kya iska koi cost he kya

    • @VBAGYAN
      @VBAGYAN 14 днів тому

      Sir I will teach this software in a simple way.

  • @dilipchaudhari359
    @dilipchaudhari359 17 днів тому

    Sir I will make for study purpose 👍👍👍👍👍

  • @jashumatipatel5553
    @jashumatipatel5553 18 днів тому

    Superb 👍👍

  • @jashumatipatel5553
    @jashumatipatel5553 18 днів тому

    Sir Very Good Informative video 👍👍👍👍👍

    • @VBAGYAN
      @VBAGYAN 17 днів тому

      Thanks for your valuable comment

  • @NareshChaudhari-z1k
    @NareshChaudhari-z1k 19 днів тому

    Wow It's like a magic I will try to make this software Sir I request you to make this software in user form

    • @VBAGYAN
      @VBAGYAN 19 днів тому

      Thank you I will make this software in userforms next month

  • @KavyaPatel-q8e
    @KavyaPatel-q8e 19 днів тому

    Wow So simple Calculation

  • @TraversEvelina
    @TraversEvelina 19 днів тому

    Thanks for the analysis! I need some advice: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?

    • @VBAGYAN
      @VBAGYAN 19 днів тому

      Hey I don't Understand what you said exactly Please explain in detail

  • @mukeshkumarsharma6682
    @mukeshkumarsharma6682 20 днів тому

    Ye automatic kese attendance sheet banaye plz upload video

    • @VBAGYAN
      @VBAGYAN 20 днів тому

      Sir This is the Result of my hard work of many months.If the viewers only want ReadyMade projects then what is the Result of my Hard work?As a Result of my hard work I Expect from all of you viewers that you all watch all my videos completely and support me to complete my targets.As my channel's targets are met,I will keep uploading videos of all my unique projects one after the other. Thank you for liking my video.Apart from this ,I have uploaded many Unique project videos on my channel.Please Check them out and watch full videos.

  • @manishnigam1831
    @manishnigam1831 22 дні тому

    Sir School Management Program Ki Coding Bataye

    • @VBAGYAN
      @VBAGYAN 22 дні тому

      Sir First of all you decide how many sheets in your project than it's designing After that you write code

  • @jashumatipatel5553
    @jashumatipatel5553 23 дні тому

    Sir I saw all videos of your channel and I really learn VBA what I needed Thank you very much

  • @prasadgaonkar5815
    @prasadgaonkar5815 29 днів тому

    Ye software provider kar sakte he kya

    • @VBAGYAN
      @VBAGYAN 28 днів тому

      Sorry Sir Watch 1 to 4 part of this series and make your own It's so easy, Try to make

  • @fahadshek8259
    @fahadshek8259 Місяць тому

    Sir full project video dalo. Coding se design tak.sab kuch

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Abhi bhi ek part baki hai aur wo bahut hi interesting hai

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Viewers part wali videos bhi pura nahi dekhte hai to ek dedh ghante ka full videos kitna dekhenge?

    • @fahadshek8259
      @fahadshek8259 Місяць тому

      @@VBAGYAN sir i want to develop vba tools that's why your videos are helpful for me if you published full stuffs with conding & design with explanation. its fully help for me also others vba developer's. Your views and followers low for your contants i mean vba developer's community small so never expects of huge views in this topics. But this topics is needy for officals employees & others corporates with developers.

    • @VBAGYAN
      @VBAGYAN Місяць тому

      @@fahadshek8259 Sir Thank you for appreciation I will try to make full videos of this software next month

  • @KavyaPatel-q8e
    @KavyaPatel-q8e Місяць тому

    Sir Really thanks to you for this video series

    • @VBAGYAN
      @VBAGYAN 25 днів тому

      Keep Watching and Support me

  • @KavyaPatel-q8e
    @KavyaPatel-q8e Місяць тому

    Sir Nice video You made a mistake in code Application.screenupdating=False hota hai or end sub se pahle Application.screenupdating=True hota hai Am I right or wrong?

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Yes You are right Thank you

  • @Shreyasi2015
    @Shreyasi2015 Місяць тому

    App kisi ko sikhate nahi ho. App ka knowledge app ke pass e rakhte ho. E app ka ahankaar hai. App ko ahta hai

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Ye sikhane ka video hi to banaya hai

  • @NareshGoswami-w5t
    @NareshGoswami-w5t Місяць тому

    Sir Very useful software for Housing society secretary Thank you

  • @retrusecharmconventschool8420
    @retrusecharmconventschool8420 Місяць тому

    सर, यूजर फॉर्म से एक्सेल शीट में डेट ट्रांसफर होने पर महीना और दिन बदल जाते हैं इसका समाधान बताएं। 🙏🙏🙏🙏

    • @VBAGYAN
      @VBAGYAN Місяць тому

      आप हमारे विडियो पूरे देखीये आपका प्रॉब्लम सत प्रतिशत सॉल्व हो जाएगा

    • @retrusecharmconventschool8420
      @retrusecharmconventschool8420 Місяць тому

      @@VBAGYAN thank u very much sir ,I have entered wrong pattern, now it has solved Thank you very much again

  • @nicejob6950
    @nicejob6950 Місяць тому

    Sir User form se Sheet me date transfer karne par Excel me dd-mm-yy se Mm-dd-yy ho jata hai. Please solve this problem

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Sir See full videos and follow steps Your problem will solve 100 percent

    • @VBAGYAN
      @VBAGYAN Місяць тому

      I think you don't see my another video How to solve date format issue in excel VBA

    • @nicejob6950
      @nicejob6950 Місяць тому

      Thank you very much sir I have watched that video and resolved my problem You are genius sir 🙏🙏🙏🙏🙏

    • @VBAGYAN
      @VBAGYAN Місяць тому

      It's my pleasure Watch all videos of Learn VBA Code Series and make your software in easiest way. Please Recommend to your friends who wants to learn Excel VBA

  • @jashumatipatel5553
    @jashumatipatel5553 Місяць тому

    Sir I definitely make it 👍👍👍👍👍

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Thank You and Keep Watching

  • @PankajPatel-ru2ch
    @PankajPatel-ru2ch Місяць тому

    Sir I am waiting for coding part and I am exited to make this project 👌👌👌👌👌

  • @vinodmaurya82
    @vinodmaurya82 Місяць тому

    Good

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Thanks and Keep Watching

  • @retrusecharmconventschool8420
    @retrusecharmconventschool8420 Місяць тому

    Thanks it was the biggest problem for me ❤

  • @rajeshbhaivasava7322
    @rajeshbhaivasava7322 Місяць тому

    Esh credit socity ka video banaye

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Okay but keep Patience

  • @retrusecharmconventschool8420
    @retrusecharmconventschool8420 Місяць тому

  • @jitendramahapatra1239
    @jitendramahapatra1239 Місяць тому

    Nice explanation sir Sir har 2-3 din ke baad ek vba series ka video upload kijiye na .. please

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Sir I appreciate your eagerness But I am a working in private field as an engineer so I record video during weekends.

    • @jitendramahapatra1239
      @jitendramahapatra1239 Місяць тому

      @VBAGYAN thik hai sir Koi baat nahi....

  • @aponbahana
    @aponbahana Місяць тому

    need project file, please

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Which Project File? Because I didn't provide any project file in any video

    • @aponbahana
      @aponbahana Місяць тому

      @VBAGYAN i know you didn’t share any project file for this i want this excel project file for exercise

  • @rajeshbhaivasava7322
    @rajeshbhaivasava7322 Місяць тому

    Nice sir. Credit socity ka bhi video bana o sir.

    • @VBAGYAN
      @VBAGYAN Місяць тому

      Next video

  • @rajeshbhaivasava7322
    @rajeshbhaivasava7322 2 місяці тому

    Credit SOCITY ka video bana ke dalo sir ji 🙏🙏

    • @VBAGYAN
      @VBAGYAN 2 місяці тому

      Next Month Pakka

  • @SPK_kaushik
    @SPK_kaushik 2 місяці тому

    in time, out time aur late by, total late saara karna hai

    • @VBAGYAN
      @VBAGYAN 2 місяці тому

      Sir Your thoughts are unique and i will try to make project on this. I think It is possible in excel VBA.

  • @jashumatipatel5553
    @jashumatipatel5553 2 місяці тому

    Excellent Information

  • @jagendrasolanki5621
    @jagendrasolanki5621 2 місяці тому

    How create not explain

    • @VBAGYAN
      @VBAGYAN 2 місяці тому

      i will upload video of making of this Project next month

  • @jagendrasolanki5621
    @jagendrasolanki5621 2 місяці тому

    How create not explain

    • @VBAGYAN
      @VBAGYAN 2 місяці тому

      Sir It's Demo Project I will Upload video of making of this project soon Please keep watching and support me Thank you for your response

  • @PankajPatel-ru2ch
    @PankajPatel-ru2ch 2 місяці тому

    Very good explanations

  • @MdShamim-up3hv
    @MdShamim-up3hv 2 місяці тому

    Thanks

    • @VBAGYAN
      @VBAGYAN 8 днів тому

      You are welcome!

  • @KavyaPatel-q8e
    @KavyaPatel-q8e 2 місяці тому

    Good

  • @PankajPatel-ru2ch
    @PankajPatel-ru2ch 2 місяці тому

    👌👌👌👌👌