Top 10 Excel Free Add-ins
Рет қаралды 216,063
Күн бұрынDid you know Excel for Office 365 has several add-ins? I’ve searched through thousands of them to bring you the Top 10 free add-ins available from the Microsoft Store.
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
Contents 0:00
1-Excel Colorizer 0:39
2-QR4Office 1:56
3-Mini Calendar 2:48
4-Places 3:53
5-People Graph 4:29
6-Activity Timer 5:36
7-Bing Maps 7:01
8-Remove Unwanted Characters 8:01
9-Range Calculations 9:09
10-Power Pivot 10:05
#seletraining #excel #tipsandtricks
@tenskippern1394 4 жыл бұрын
Good Job, right to the point, no yelling or screaming, thank you
@philclemmons 4 жыл бұрын
As always, great video. Thank you for being here. You have saved me many hours on each of my projects.
@StevenVega11281989 4 жыл бұрын
The more I use Excel, the more I realize how much I don't know! Thank you for simplifying this and for the great add-in tips!
@levantateyora9317 4 жыл бұрын
Me 2. I decided a few days ago to learn excel from every corner. And there is so much to learn you can even build powerful applications from excel and sell them or what ever you want.
@sriramsubramaniyan6959 4 жыл бұрын
Very much helpful to know new uncommon add ins for common day to day tasks. Thank You.
@saurabhgupta5429 4 жыл бұрын
Thanks Jason for this add-in video . Every time I see your video, I learn something new.
@SeleTraining 4 жыл бұрын
Excellent!
@phamnguyentrucgiang569 4 жыл бұрын
Thank you, this tutorial is very useful and I can use these tips into my job. Thumb up.
@marshalxu8082 4 жыл бұрын
Great video. Thanks for all the hard work!
@Carsten0712 4 жыл бұрын
wonderful, great job, thank you very much
@deepika6659 4 жыл бұрын
Thank you sir for the quality information. This video helped me a lot.
@wayneedmondson1065 4 жыл бұрын
Hi Jason.. excellent! Learned about some new and interesting options here. Thanks for sharing. Thumbs up for Sele Training!
@SeleTraining 4 жыл бұрын
Thanks Wayne
@dheerajsah 4 жыл бұрын
Sir you are a genius, i can't be more thankful to people like you. Such amazing information, you made my day. Many Thanks 😃
@donegal79 4 жыл бұрын
Thank you this is really useful
@ramdashwant2024 2 жыл бұрын
Beautifully explained 💗💖
@igorwork8908 3 жыл бұрын
As always,great video
@vijaykumar-gf4qd 4 жыл бұрын
Thank you so much
@MrSupernova111 2 жыл бұрын
Pretty cool! The first couple of add-ins here are for noobs and somewhat useless. But others such as PowerPivot, places, maps can be very useful. Thanks!
@ICTNuggets 4 жыл бұрын
Great videos man.. We learn a lot from you...keep it up.
@SeleTraining 4 жыл бұрын
Thanks, will do!
@muntadher8087 2 жыл бұрын
Thank you so Much!!
@osmanmohamed8638 4 жыл бұрын
Helpfully very much
@thanhhung6201 2 жыл бұрын
so helpful, sir. Thanks for sharing with us!
@SeleTraining 2 жыл бұрын
Most welcome!
@patricklonski 4 жыл бұрын
Exceptional video. I Subscribed, hit thumbs up and hit the notification bell
@SeleTraining 4 жыл бұрын
Excellent. Thanks.
@lijophilip2860 4 жыл бұрын
Thank you
@mohammedtouahri1106 4 жыл бұрын
Nice video and nice soothing voice :)
@SeleTraining 4 жыл бұрын
Thank you! 🙂
@hugoatencia9408 2 жыл бұрын
Muchas gracias
@Excel_Mantra 4 жыл бұрын
*Awesome Add-ins* #OntimeEdu
@t2p5g4 4 жыл бұрын
Thanks, very helpful. Power Query is another one, although it could be argued it isn't an add in. I haven't figured out the intricacies of it, but it is an easy way to convert a range of dates in text format into date format. Fill under transform makes it easy to take a general ledger listing where the account name is only listed on the first line and have it on every line. It can even bring in a listing of a folder's contents. The new Visio addin looks good as well.
@SeleTraining 4 жыл бұрын
Good info. I looked at the Visio addin and it has additional purchases but it still has several basic options in the free version.
@MrSupernova111 2 жыл бұрын
I recently used Power Query to append, merge, and transform multiple data sources to migrate it as a single data table from one system to another. Over 500k rows of data in total. Power Query is possibly the single greatest tool in Excel!
@ivorynd 4 жыл бұрын
Thank you for the Tip! FYI
@SeleTraining 4 жыл бұрын
No problem!
@MrEms333 4 жыл бұрын
Nice Nice
@Prasannasubramaniankaushik 4 жыл бұрын
Best thing to happen today
@onuraydn9901 4 жыл бұрын
Yessssss!!!!
@studychannel8045 3 жыл бұрын
remove unwanted character, nice.
@venkateshlakshmipathy989 Жыл бұрын
Hi @sele training Thank you for sharing this. I have added all these add-ins, however, the Range calculations and Remove unwanted characters are not working. Could you please let me know if there is any way to rectify it? I've tried it on both my personal and company laptops.
@SeleTraining Жыл бұрын
There have been changes to the addins since this video
@venkateshlakshmipathy989 Жыл бұрын
@@SeleTraining thank you for your prompt response, is there any solution which you can suggest?
@mahmoudharhash2973 4 жыл бұрын
many thanks for a valuable content
@carlsam7451 3 жыл бұрын
Do you know any add-in in Excel for drawing línes, highlight, etc., while teaching or exposing some subjet????
@SeleTraining 3 жыл бұрын
You can draw lines and shapes in Excel from the Insert menu but as a teaching tool it's not a good solution. It's better to use something like Teams as a live demo or PowerPoint to create a presentation. Those tools give you pointers and highlighters to show your Excel subject. Otherwise the best option is to increase your pointer size settings in Windows so it is more visible.
@hitachitraininggroup9660 4 жыл бұрын
Great info, however... I can not seem to find Activity Timer. it doesnt show up when i search for it. any ideas why?
@SeleTraining 4 жыл бұрын
Interesting. It's not showing up so they may have removed it or it is temporarily down. I'd give it some time and see if it works again later.
@my_excel 2 жыл бұрын
❣
@shailendrakumaryadav2936 4 жыл бұрын
Is there any air pollution related addins like wind rose, correlation etc
@SeleTraining 4 жыл бұрын
Not anything that I see.
@dexterbernard2701 4 жыл бұрын
Since the recent update 'activity timer' is no longer available. What would be complimentary app?
@SeleTraining 4 жыл бұрын
Yes, it's a bummer that it was disabled shortly after making the video. I don't see any other add-in that does the same thing. Let's hope they bring it back.
@dexterbernard2701 4 жыл бұрын
@@SeleTraining thank you for your expeditious reply. I hope so too.
@wolfgangley2598 Жыл бұрын
Activity Timer by Mzamose Holdings is not listed (Sept 2022)
@mbc1557 3 жыл бұрын
Is there any addin for searchable dropdown list available
@SeleTraining 3 жыл бұрын
There is a way. Here is a video: kzfaq.info/get/bejne/kJOYZbh2t5nGj2Q.html
@brettknoss486 4 жыл бұрын
You said Power Pivot handles SQL, does it also handle GraphQL?
@SeleTraining 4 жыл бұрын
If you are able to create an ODBC connection then you can make it work with Power Pivot.
@brettknoss486 4 жыл бұрын
@@SeleTraining ok thanks.
@alexblackie2616 3 жыл бұрын
Am using office 2019 but my excel does not have ideas in the ribbon bar, how can i fix that
@SeleTraining 3 жыл бұрын
It is available in the Microsoft 365 version of Excel and has been renamed to Analyze Data in the latest version.
@hsanmyintoo7252 3 жыл бұрын
There appears "Add-in Error" like this, "we can't load this Add-in because we couldn't connect to the catalog". Please tell me why!
@SeleTraining 3 жыл бұрын
Which add-in or any of them? It appears something is blocking the catalog. If you have an enterprise license in an office environment it could be that your administrator is blocking access to add-ins. www.11trees.com/live/we-cant-load-this-add-in-because-we-couldnt-connect-to-the-catalog-message-from-microsoft-word/
@Mr-J... 4 жыл бұрын
Everything in "Range Calculations" can be done via Paste Special...
@Dexter101x 4 жыл бұрын
I didn't get the Activity timer add in as it is unavailable
@SeleTraining 4 жыл бұрын
Yes, it looks like they cancelled that add-in shortly after I created the video. I've been waiting to see if it came back but it hasn't yet.
@cyw2181 4 жыл бұрын
remove unwanted charactors,it always shows "Sorry,the operation failed,the supplied object data will overwrite or shift data",do you know why,sir?
@SeleTraining 4 жыл бұрын
It is working for me. Are you picking a range too large?
@galluschannelhalvid7426 4 жыл бұрын
how to get it, sir!
@SeleTraining 4 жыл бұрын
The free add-ins are available in Office 365 Excel.
@brettknoss486 4 жыл бұрын
Is there a Google Maps add in?
@SeleTraining 4 жыл бұрын
There is no add-in for Google Maps that I have seen.
@brettknoss486 4 жыл бұрын
@@SeleTraining probably fine, looks like it's not doing interactive stuff anyways.
@premveerjaat6088 3 жыл бұрын
How to add piper plot
@SeleTraining 3 жыл бұрын
There is no option in Excel for a piper plot diagram. That would be a good add-in for someone to create.
@vishaljhaveri7565 Жыл бұрын
Activity Timer is not working for me. Error 403 - This web app is stopped
@vishaljhaveri7565 Жыл бұрын
Remove Unwanted character is not working as of 27-05-2023
@pickleball_dereck 4 жыл бұрын
Couldn't find Activity Timer.
@SeleTraining 4 жыл бұрын
Activity Timer was removed shortly after this video for some reason. I don't know if it will be back or if it is a permanent removal.
@pickleball_dereck 4 жыл бұрын
@@SeleTraining Thanks.
@dema-3000 3 жыл бұрын
I cannot find Activity Timer :(
@SeleTraining 3 жыл бұрын
Yes, it looks like that one has been removed. There is a new one called daily time tracker that may work.
@dema-3000 3 жыл бұрын
@@SeleTraining This one gives an error "A problem occured while trying to use this add-in.
@LueckenfuellerVideo 3 жыл бұрын
@@dema-3000 does not work in my excel, too
@k_bv 4 жыл бұрын
Top 10 add ins for Excel without PowerQuery?! Instead you put some coloring and calendar?! This "Top 10" is not from my universe.
Meowtropolis
Рет қаралды 12 МЛН
10 News First
Рет қаралды 49 МЛН
notebook-31
Рет қаралды 76 М.