FREE Excel Add-in to Boost Your Productivity

Рет қаралды 19,339

Күн бұрын

🚨 PLEASE NOTE: Creating a Pandas Dataframe based on your Excel selection is only available in the PRO-Version (NOT FREE) 🚨
If you're looking for a way to increase your productivity, then this video is perfect for you. I'm going to show you how to use the FREE excel add-in 'My Tool Belt' to automate and save lots of time when working on your spreadsheets. You don't need programming knowledge as it's straightforward to use, and the results are instant. 'My Tool Belt' will help you to automate some of the most tedious tasks in Microsoft Excel.
Below are some of the features 'My Tool Belt' has to offer:
- Insert images to comments
- Transform text to checkboxes
- Apply easily conditional formatting to cells
- Create Drop Down lists with one click
- Clean up text cells (remove empty/blank spaces)
- Replace specific formulas with values
- Generate Python files directly from Excel
- … and much more
𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗘 𝗙𝗥𝗘𝗘 𝗔𝗗𝗗-𝗜𝗡 𝗛𝗘𝗥𝗘:
► pythonandvba.com/mytoolbelt
✅ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 | Intro
00:35 | Installation
01:35 | Increase Tint & Shade
02:03 | Border With Color
02:20 | Dotted Border
02:34 | True-False Formatting
03:14 | User Input Formatting
03:43 | Trim Selected Text
04:11 | Insert Check Boxes
04:33 | Create Name Range
05:02 | Insert Drop Down List
05:23 | Divide By Number
05:45 | Multiply By Number
05:56 | Cell Value To Comment
06:07 | Comment To Cell Value
06:18 | If Error 0 / If Error Blank
07:06 | Replace Formulas By Values
07:46 | Pic In Comment
08:40 | Create Xlwings Template (Python)
10:11 | Create Pandas Dataframe (Python)
11:39 | Add-in Info
11:59 | Wrap Up
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website: pythonandvba.com
📝 GitHub: github.com/Sven-Bo
⭐ Discord: pythonandvba.com/discord
▶️ Subscribe: kzfaq.info?sub...
📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: pythonandvba.com/resources
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
pythonandvba.com/coffee-donation

Пікірлер: 119

@awmsnipez4716 2 жыл бұрын

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...

@CodingIsFun 2 жыл бұрын

*I am glad to hear you are enjoying them; thanks for watching and for the comment!* 😀

@ricardo.alves.campos 2 жыл бұрын

Excellent as always!!!

@CodingIsFun 2 жыл бұрын

Thank you! Glad you like it!

@cenkulukaya 2 жыл бұрын

This is awesome. And I can't believe it's free. Thank you so much.

@CodingIsFun 2 жыл бұрын

Thank you! I am glad you like the Add-in 😃

@fillipusanton4109 2 жыл бұрын

Cool and Awesome. Good job Sven. You are my inspiration to be Data Analyst.

@CodingIsFun 2 жыл бұрын

Wow, thanks! Happy to hear that 😃

@sureshpatil553 2 жыл бұрын

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!!!!!

@CodingIsFun 2 жыл бұрын

Aww, thank you for believing in me & your wishes. Thrilled to hear that you see some value in the videos & solutions I am providing.

@haninawaya9967 2 жыл бұрын

Great, many thanks

@CodingIsFun 2 жыл бұрын

Thanks for watching. Hope you find the add-in useful :)

@BrianLiew 2 жыл бұрын

Thanks for this nice tool.

@CodingIsFun 2 жыл бұрын

A pleasure! Thanks for watching the video :)

@vsddkkjjhgrreertyfdserrftyh Жыл бұрын

Best tool developed by you 👍

@CodingIsFun Жыл бұрын

Thank you very much! :)

@kabirhussain1725 2 жыл бұрын

Sir you are genius.. Soon you will see millions of subscribers on your channel. thanks

@CodingIsFun 2 жыл бұрын

Thank you so much 😀

@hansensudarma4446 2 жыл бұрын

Thank you soo much.

@CodingIsFun 2 жыл бұрын

A pleasure! Thank you for watching the video :)

@socialmedia.villagers 3 ай бұрын

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.

@CodingIsFun 3 ай бұрын

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 ✌️

@Fernando-hr1ix 2 жыл бұрын

Hi Sven, the plugin is fascinating. I think that a facilitating feature would be the fact of having a button that executes jupyter notebooks

@CodingIsFun 2 жыл бұрын

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-hr1ix 2 жыл бұрын

@@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.

@CodingIsFun 2 жыл бұрын

@@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.

@sakulwatwatthanakul 2 жыл бұрын

Excellent

@CodingIsFun 2 жыл бұрын

Thank you!

@NickWindham Жыл бұрын

Awesome

@CodingIsFun Жыл бұрын

Thanks! :)

@MrDhunpagla Жыл бұрын

Wow nice ☺️👍

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching and taking the time to leave a comment!

@BenBezuidenhout 2 жыл бұрын

Thanks

@CodingIsFun 2 жыл бұрын

A pleasure! Thanks for watching (& using the ToolBelt)

@kadichidu4171 2 жыл бұрын

Please make more add ins for excel..love from India

@CodingIsFun 2 жыл бұрын

Thank you for your suggestion :)

@Maylali1 Жыл бұрын

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?

@CodingIsFun Жыл бұрын

Thanks for watching. I have seen your email. I will reply via email.

@adityasharma0101 2 жыл бұрын

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.

@CodingIsFun 2 жыл бұрын

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.

@gaganrastogi9624 2 жыл бұрын

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.

@CodingIsFun 2 жыл бұрын

Glad to hear, that you find the videos helpful. 😃 Feel free to shoot me an email at: contact@pythonandvba.com Cheers!

@mahesh19711 Жыл бұрын

Very handy Tool Box . Request to add function for converting currency value to words. e.g 1,025 = One Thousand Twenty five only

@CodingIsFun Жыл бұрын

Glad you like the add-in! Thank you very much for your suggestion! 👍

@evolutionclouds 2 жыл бұрын

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

@CodingIsFun 2 жыл бұрын

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.

@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.

@CodingIsFun 2 жыл бұрын

🚨🚨🚨 *PLEASE NOTE: Creating a Pandas Dataframe based on your Excel selection is only available in the PRO-Version (NOT FREE)* 🚨🚨🚨

@nivasmptc 2 жыл бұрын

Remove empty cells and that true are false options

@forbidenfox3453 2 жыл бұрын

Make the same format as the example cell above it automatically

@forbidenfox3453 2 жыл бұрын

Hmmmm maybe print sales report or make invoice idk

@forbidenfox3453 2 жыл бұрын

Maybe u need to sell it or premium access on some feature

@kuuuyajim 2 жыл бұрын

Favorites: Trim Selected Text, Insert Dropdown List, Pic in Comment Suggestion: Use Input Formatting to work on numbers and symbols Thank you, Sven! 😉

@SugengWahyudi 2 жыл бұрын

Need Video tutorial web scraping that show result to excel

@jawadmansoor6064 2 жыл бұрын

It's a good thing I can create my own. :) (skipping video now XD)

@CodingIsFun 2 жыл бұрын

That's cool! Happy Coding! 😃

@antonachim5224 9 ай бұрын

Impressive!

@CodingIsFun 9 ай бұрын

Thanks! :)

@riteshzope3672 Жыл бұрын

Ctrl+z not works after using My Tool Belt add in ..? Is it correct ..?

@CodingIsFun Жыл бұрын

Yes, that is correct

@viper1424 2 жыл бұрын

Can you make a video on how you made this please

@CodingIsFun 2 жыл бұрын

Thanks for the suggestion. I might make a tutorial on creating your own Excel add-in in the future.

@TheMaxKids Жыл бұрын

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?

@CodingIsFun Жыл бұрын

Thanks, but this add-in only works in Windows.

@TheMaxKids Жыл бұрын

Just saw that - thank you. Looks great.

@rickwize1182 2 жыл бұрын

You do incredible work. Very nice. I have sent you a potential project on your contact page.

@CodingIsFun 2 жыл бұрын

Thank you! I have received your mail. Kindly allow me some time to look into your project.

@nivasmptc 2 жыл бұрын

How to transfer error red value in sheet sheet

@user-ow2eg6gd7d 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

@CodingIsFun 2 жыл бұрын

Those are all great features - Thanks! I will see what I can do.

@user-ow2eg6gd7d 2 жыл бұрын

filter() and averageifs() make a one cell contain a list saperated commas pls make a "donate" or.... botton and open the all features

@robwin0072 Жыл бұрын

Can your addin convert excel to LaTeX code? If so, how?

@CodingIsFun Жыл бұрын

No, it cannot do that

@TheInayat007 2 жыл бұрын

Hi can you help with email automation so i can send email with different names to different reception

@CodingIsFun 2 жыл бұрын

Thanks for watching the video. How about this solution? kzfaq.info/get/bejne/h5qCjLSnxJvTiGQ.html

@ngangueepallehenrijoel8900 2 жыл бұрын

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 ? 😭😭😭

@CodingIsFun 2 жыл бұрын

Thanks. I would need to check the issue with my hosting provider

@ngangueepallehenrijoel8900 2 жыл бұрын

@@CodingIsFun OK, thanks a lot

@CodingIsFun 2 жыл бұрын

@@ngangueepallehenrijoel8900 Could you please try again? I think it should work now.

@ngangueepallehenrijoel8900 2 жыл бұрын

@@CodingIsFun It's OK, thks 🙏🙏🙏🙏🙏

@ramzifly9640 2 жыл бұрын

Hi Sven; there is a problem with the zip file, error message "it does not appear to be a valid archive"

@CodingIsFun 2 жыл бұрын

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 9 ай бұрын

i can't undo anything after using "my tool belt" options. 🤔

@CodingIsFun 9 ай бұрын

That's correct. That is the default behaviour of VBA (in which the add-in is written)

@user-xg5yw8jf4k 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.

@CodingIsFun 2 жыл бұрын

Thanks for watching the video & your suggestion :)

@ravapurnomo9430 2 жыл бұрын

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.

@CodingIsFun 2 жыл бұрын

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.

@AizzatAffero 2 жыл бұрын

Nice, i hope the i can download your whatsapp excel before utube take down your video

@CodingIsFun 2 жыл бұрын

I hope so too 😅

@AizzatAffero 2 жыл бұрын

@@CodingIsFun how can i download your sample bro? I could buy u some coffee for it. Can i dm u?

@CodingIsFun 2 жыл бұрын

@@AizzatAffero Feel free to shoot me an email: contact@pythonandvba.com

@tuandhtl 2 жыл бұрын

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: []

@CodingIsFun 2 жыл бұрын

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!

@tuandhtl 2 жыл бұрын

@@CodingIsFun I found the error, I forgot save file before run the script.Thanks, Bro!!!!

@CodingIsFun 2 жыл бұрын

@@tuandhtl Glad to hear :) (happened also to me before 😅)

@gaytanhutchinson8904 2 жыл бұрын

Is it still for free?

@CodingIsFun 2 жыл бұрын

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.

@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.

@baastech7840 2 жыл бұрын

u said free but its cost money if i want to add toolbelt that not honest ...

@CodingIsFun 2 жыл бұрын

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!

@lautarob Жыл бұрын

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.

@nivasmptc 2 жыл бұрын

First like

@CodingIsFun 2 жыл бұрын

Awesome! Thank you!

@mahirbadanagki 2 жыл бұрын

you should have mentioned that it is not totally free and some features requires key activation (license)

@CodingIsFun 2 жыл бұрын

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.