Hi Sven, from so many days i am waiting for this video, Excel Add-in to Boost Your Productivity. thank you i got and very clean and easily understandable videos.. thank you...
@CodingIsFun3 жыл бұрын
*I am glad to hear you are enjoying them; thanks for watching and for the comment!* 😀
@cenkulukaya3 жыл бұрын
This is awesome. And I can't believe it's free. Thank you so much.
@CodingIsFun3 жыл бұрын
Thank you! I am glad you like the Add-in 😃
@sureshpatil5533 жыл бұрын
One day "Coding is Fun" will become one of the most successful youtube channel and "Sven" will become most successful youtuber as he is doing problem solving things. All the very best for your journey!!!!!
@CodingIsFun3 жыл бұрын
Aww, thank you for believing in me & your wishes. Thrilled to hear that you see some value in the videos & solutions I am providing.
@CodingIsFun3 жыл бұрын
🚨🚨🚨 *PLEASE NOTE: Creating a Pandas Dataframe based on your Excel selection is only available in the PRO-Version (NOT FREE)* 🚨🚨🚨
@nivasmptc3 жыл бұрын
Remove empty cells and that true are false options
@forbidenfox34533 жыл бұрын
Make the same format as the example cell above it automatically
@forbidenfox34533 жыл бұрын
Hmmmm maybe print sales report or make invoice idk
@forbidenfox34533 жыл бұрын
Maybe u need to sell it or premium access on some feature
@kuuuyajim3 жыл бұрын
Favorites: Trim Selected Text, Insert Dropdown List, Pic in Comment Suggestion: Use Input Formatting to work on numbers and symbols Thank you, Sven! 😉
@fillipusanton41093 жыл бұрын
Cool and Awesome. Good job Sven. You are my inspiration to be Data Analyst.
@CodingIsFun3 жыл бұрын
Wow, thanks! Happy to hear that 😃
@kabirhussain17253 жыл бұрын
Sir you are genius.. Soon you will see millions of subscribers on your channel. thanks
@CodingIsFun3 жыл бұрын
Thank you so much 😀
@ricardo.alves.campos3 жыл бұрын
Excellent as always!!!
@CodingIsFun3 жыл бұрын
Thank you! Glad you like it!
@socialmedia.villagers7 ай бұрын
Hi Sven..Thanks for your wonderful tutorials....it's very useful and easy to do at low cost. I could not understand the excel access token etc. Can you please help me to understand how can i design the template as your is.
@CodingIsFun7 ай бұрын
Thanks for watching and for your kind words. I'm sorry, but I'm not quite sure what you mean by "access token". Cheers, Sven ✌️
@Maylali12 жыл бұрын
Thank you very much, its awsome! For some reason, I cant install it in my excel as an add-in, is there any other way to add it to my excel?
@CodingIsFun2 жыл бұрын
Thanks for watching. I have seen your email. I will reply via email.
@haninawaya99673 жыл бұрын
Great, many thanks
@CodingIsFun3 жыл бұрын
Thanks for watching. Hope you find the add-in useful :)
@wuhanite2 жыл бұрын
Thanks for this nice tool.
@CodingIsFun2 жыл бұрын
A pleasure! Thanks for watching the video :)
@gaganrastogi96243 жыл бұрын
I recently found your channel and your content is full of quality. I am beginner in VBA, I want to learn and understand this tool's codes. Please can you share the password of this project.
@CodingIsFun3 жыл бұрын
Glad to hear, that you find the videos helpful. 😃 Feel free to shoot me an email at: contact@pythonandvba.com Cheers!
@vsddkkjjhgrreertyfdserrftyh2 жыл бұрын
Best tool developed by you 👍
@CodingIsFun2 жыл бұрын
Thank you very much! :)
@Fernando-hr1ix2 жыл бұрын
Hi Sven, the plugin is fascinating. I think that a facilitating feature would be the fact of having a button that executes jupyter notebooks
@CodingIsFun2 жыл бұрын
Hi Fernando, Thanks for the suggestion. I was thinking of implementing a button to execute Python or Jupyter Notebooks. However, with the xlwings add-in, you could already execute Python scripts. I would need more time. The tricky part is determining your Python executable path and in which environment you want to run your Python code. That said, in the next version of the toolbelt, you will be able to create a Jupyter Notebook based on your Excel selection. Meaning, you just need to highlight a cell range, and the toolbelt will create a Jupyter notebook file for you that includes a pandas dataframe based on your selection.
@Fernando-hr1ix2 жыл бұрын
@@CodingIsFun Sven thanks for considering it since as you mention it has another level of complexity in terms of developing it. This would make it easier for intermediate and advanced Excel users in every way. I understand that the tool belt has 2 audiences or covers the needs of not so technical and advanced analysts and the xlwings add-in is also great but it is for the second group. An advanced user can eventually do more with the Python section and a curious intermediate user can explore new resources in a more advanced sense without leaving the toolbelt environment. So I see a very good opportunity to continue to provide benefits in both directions and the Jupyter Notebook as a 3rd option would be a spectacular all-in-one that would continue to expand the belt with more accessories. Which in turn would prevent users from cluttering the Excel ribbon with more add-ins.
@CodingIsFun2 жыл бұрын
@@Fernando-hr1ix Thanks. I appreciate your valuable input. I am thinking about integrating a user menu setting into the toolbelt to get things started. The user would need to input the Python interpreter path they would like to use. Of course, this path would be saved as a user setting. It would be an initial effort to set up the Python path. Is there any chance to connect with you? My email is as follows: contact@pythonandvba.com. Once I have the first version, I would like to share it with you. Once again, thanks for your thoughts.
@evolutionclouds2 жыл бұрын
Hi Sven, This is fantastic! Is this one of the things you do in your work? Create custom excel add-ins? If you do I may be interested in doing some work for my little bookkeeping company
@CodingIsFun2 жыл бұрын
Hi there, I could also create a custom add-in for your bookkeeping company. Feel free to reach out to me via email: contact@pythonandvba.com.
@mahesh197112 жыл бұрын
Very handy Tool Box . Request to add function for converting currency value to words. e.g 1,025 = One Thousand Twenty five only
@CodingIsFun2 жыл бұрын
Glad you like the add-in! Thank you very much for your suggestion! 👍
@kadichidu41712 жыл бұрын
Please make more add ins for excel..love from India
@CodingIsFun2 жыл бұрын
Thank you for your suggestion :)
@hansensudarma44463 жыл бұрын
Thank you soo much.
@CodingIsFun3 жыл бұрын
A pleasure! Thank you for watching the video :)
@ngangueepallehenrijoel89002 жыл бұрын
sooooo cool, i like it 🦾🦾🦾 unfortunately i can't download the add-in 😢 message: The firewall on this server is blocking your connection can i have another link please ? 😭😭😭
@CodingIsFun2 жыл бұрын
Thanks. I would need to check the issue with my hosting provider
@ngangueepallehenrijoel89002 жыл бұрын
@@CodingIsFun OK, thanks a lot
@CodingIsFun2 жыл бұрын
@@ngangueepallehenrijoel8900 Could you please try again? I think it should work now.
@ngangueepallehenrijoel89002 жыл бұрын
@@CodingIsFun It's OK, thks 🙏🙏🙏🙏🙏
@TheMaxKids2 жыл бұрын
I am using Excel for MAC VERSION 16.62. I'm having trouble finding the add-ins area to do the drop. Can you help?
@CodingIsFun2 жыл бұрын
Thanks, but this add-in only works in Windows.
@TheMaxKids2 жыл бұрын
Just saw that - thank you. Looks great.
@adityasharma01013 жыл бұрын
Its all very good..and it is very nice of you to share this for free. Thanks. Just one point. You mentioned somewhere that "usually you can not insert image to comment". This aint true mate. We can do that. Although the process is far more longer than your add in that I agree.
@CodingIsFun3 жыл бұрын
Ah, thank you very much for the hint 👍 I was mistaken - sorry! You can actually do that by setting up the comment 'Fill Color' to a picture.
@TrenkMikeH Жыл бұрын
I would like a button to connect an Excel range to a database (SQLite, Postgres, etc) for live 2-way updating and querying.
@CodingIsFun Жыл бұрын
Thanks for watching and your suggestion.
@nerenlakhraj5252Ай бұрын
Hi ... I have tried 3 times requesting this Add-in to no avail. Even checked my spam folder. Please advise how can I get it
@CodingIsFunАй бұрын
Please write me an email and I'll send it to you: sven@pythonandvba.com
@SugengWahyudi3 жыл бұрын
Need Video tutorial web scraping that show result to excel
@MrDhunpagla Жыл бұрын
Wow nice ☺️👍
@CodingIsFun Жыл бұрын
Glad you liked it. Thanks for watching and taking the time to leave a comment!
@sakulwatwatthanakul3 жыл бұрын
Excellent
@CodingIsFun3 жыл бұрын
Thank you!
@NickWindham Жыл бұрын
Awesome
@CodingIsFun Жыл бұрын
Thanks! :)
@jawadmansoor60643 жыл бұрын
It's a good thing I can create my own. :) (skipping video now XD)
@CodingIsFun3 жыл бұрын
That's cool! Happy Coding! 😃
@riteshzope3672 Жыл бұрын
Ctrl+z not works after using My Tool Belt add in ..? Is it correct ..?
@CodingIsFun Жыл бұрын
Yes, that is correct
@viper14242 жыл бұрын
Can you make a video on how you made this please
@CodingIsFun2 жыл бұрын
Thanks for the suggestion. I might make a tutorial on creating your own Excel add-in in the future.
@robwin00722 жыл бұрын
Can your addin convert excel to LaTeX code? If so, how?
@CodingIsFun2 жыл бұрын
No, it cannot do that
@BenBezuidenhout3 жыл бұрын
Thanks
@CodingIsFun3 жыл бұрын
A pleasure! Thanks for watching (& using the ToolBelt)
@משהדזיין2 жыл бұрын
next step- plotting graphs on chosen data-set utomatically- using R next step- unpivot selected table and make it from wide dataset to long dataset next step is to make xlookup available to non-users office 365
@CodingIsFun2 жыл бұрын
Those are all great features - Thanks! I will see what I can do.
@משהדזיין2 жыл бұрын
filter() and averageifs() make a one cell contain a list saperated commas pls make a "donate" or.... botton and open the all features
@ravapurnomo94302 жыл бұрын
I can't use the 'Create Pandas Dataframe" feature because it is not literally free. It requires you to buy the license. So that, I can't continue following your tutorial that requires all of that above.
@CodingIsFun2 жыл бұрын
The initial release was free. Still, all features from the video are free to use, except for creating the Pandas Dataframe. You do not need this add-in to follow any of my tutorials. It is just a convenient time saver.
@TheInayat0073 жыл бұрын
Hi can you help with email automation so i can send email with different names to different reception
@CodingIsFun3 жыл бұрын
Thanks for watching the video. How about this solution? kzbin.info/www/bejne/h2W1ioSslJqijpI
@ramzifly96403 жыл бұрын
Hi Sven; there is a problem with the zip file, error message "it does not appear to be a valid archive"
@CodingIsFun3 жыл бұрын
Hi there. I just checked it - I had no trouble downloading and extracting the archive. Feel free to shoot me an email at 'contact@pythonandvba.com'. I will send it to you via mail. Thanks!
@naimatcreativestudio2571 Жыл бұрын
@@CodingIsFun please share
@CodingIsFun Жыл бұрын
@@naimatcreativestudio2571 Links are in the description
@ytfan7153 Жыл бұрын
i can't undo anything after using "my tool belt" options. 🤔
@CodingIsFun Жыл бұрын
That's correct. That is the default behaviour of VBA (in which the add-in is written)
@antonachim5224 Жыл бұрын
Impressive!
@CodingIsFun Жыл бұрын
Thanks! :)
@rickwize11823 жыл бұрын
You do incredible work. Very nice. I have sent you a potential project on your contact page.
@CodingIsFun3 жыл бұрын
Thank you! I have received your mail. Kindly allow me some time to look into your project.
@nivasmptc3 жыл бұрын
How to transfer error red value in sheet sheet
@gaytanhutchinson2 жыл бұрын
Is it still for free?
@CodingIsFun2 жыл бұрын
All features shown in the video are still free, except for the button to create Pandas Dataframes. Currently, the lifetime license costs 4 USD, and since the initial release, many new features have been added.
@tuandhtl3 жыл бұрын
Coding is Fun I have created dataframe python file bit when I run code, it show empty dataframe: C:\Users\Prince T\Desktop\Test>py test.py Empty DataFrame Columns: [] Index: []
@CodingIsFun3 жыл бұрын
Thanks for watching the video. I assume your Excel cell selection was not empty and that you did not get any error while using the ToolBelt? Additionally, did you save the Excel file before executing the Python script (to ensure that your changes in Excel are also reflected in the Pandas Dataframe). Thanks!
@tuandhtl3 жыл бұрын
@@CodingIsFun I found the error, I forgot save file before run the script.Thanks, Bro!!!!
@CodingIsFun3 жыл бұрын
@@tuandhtl Glad to hear :) (happened also to me before 😅)
@siddharthbhalsod2106 Жыл бұрын
I'm not getting any mail for mytoolbelt free version file... Please help
@CodingIsFun Жыл бұрын
Please also check your spam folder
@siddharthbhalsod2106 Жыл бұрын
@@CodingIsFun i did checked and also tried with another email as well but not getting
@CodingIsFun Жыл бұрын
@@siddharthbhalsod2106 I looked into it, and there was indeed a problem on my server. Good news though, I've fixed it! You can now resubmit the form here: pythonandvba.com/my-toolbelt-free-version/ It should work just fine now. Sorry about the hassle, and thanks for your patience!
@CodingIsFun Жыл бұрын
@@siddharthbhalsod2106 Installation guide can be found in the email
@siddharthbhalsod2106 Жыл бұрын
@@CodingIsFun yes it is working now thanks alot... I want make simple one my own please suggest step by step guide from basic to pro.
@baastech78402 жыл бұрын
u said free but its cost money if i want to add toolbelt that not honest ...
@CodingIsFun2 жыл бұрын
The initial release was free. Still, all features from the video are free to use, except for creating the Pandas Dataframe. But I agree, this might be misleading. I am currently updating the website and making a new video of the Excel Add-in with all the new features I have added after the initial release. Sorry for the confusion!
@lautarob2 жыл бұрын
He said that some parts are free and some aren't. More important, you should be aware that design tools like this takes time and effort and we should be grateful for getting it (at least partially) for free.
@mahirbadanagki2 жыл бұрын
you should have mentioned that it is not totally free and some features requires key activation (license)
@CodingIsFun2 жыл бұрын
You are right! The first version (as shown in the video) was absolutely free. Yet, that latest version (with much more features) requires a license key to unlock all features. In the follow up video I will mention this.
@AizzatAffero3 жыл бұрын
Nice, i hope the i can download your whatsapp excel before utube take down your video
@CodingIsFun3 жыл бұрын
I hope so too 😅
@AizzatAffero3 жыл бұрын
@@CodingIsFun how can i download your sample bro? I could buy u some coffee for it. Can i dm u?
@CodingIsFun3 жыл бұрын
@@AizzatAffero Feel free to shoot me an email: contact@pythonandvba.com
@МихаилТогузов2 жыл бұрын
This is a very cool thing! Thank you for doing this, and for doing it for free! At the expense of ideas - this app needs a user-friendly add-in for trading on crypto exchanges for a long time - this will kill all the designers of trading robots.
@CodingIsFun2 жыл бұрын
Thanks for watching the video & your suggestion :)