I bought some of her courses on udemy (which are absolutely amazing btw,) and she's also now killing it on linked learning, she is unquestionably the most knowledgeable and highly skilled excel user and teacher that has ever existed. Period.
Definitely one of the best. If I need a tutorial, I search for EXCEL and one or more key words. Some of the video creators do not put the necessary key words in the Title, meaning I would not find their video.
How to install Add-ins 0:56 1. QR4Office 1:45 2. Web Video Player 2:46 3. Visio Data Visualisazer 3:41 4. People Graph 7:16 5. Mini Calendar and Date Picker 9:14 6. Bing Maps 10:48 Create an API (Application Programming Interface) 13:17
I love your videos and courses. I am learning so much! The one problem I have is i inevitably fall down a UA-cam rabbit hole and watch your videos for hours 😅. Youre an amazing Teacher and an inspiration, thank you!
Hi Leila, I purchased all your 8 courses at once on Udemy once I saw it, following you continuously, please keep feeding us with more scope. Power BI is really getting favourite and I would like to listen from your tutorials as well soon if possible. Thanks.
Mme Leila ... Thank you with all my heart for your presentation in all of your videos. They are very useful to me. Your explanation is very great. this is not a complement to you but this true, your excellent professor.
Number 2 ........ VOILà !!!!!! that´s awesome! Adding an embedded video with instrucctions to "how to analyze this report" is going to lead to good UX for your users, thanks Leila !!!
That date picker was so needed :-) Combining it with a line of vba code and it makes the parameter selections sooo much easier. Thank you, Leila! It was very informative and helpful.
Wow Leila, you are the Pope in excell. From the little I saw, you are also an expert in development and programming. I also want to say that your English is easy to understand for foreigners and your teaching skills are excellent !!! Congratulations and thanks for sharing!
@@LeilaGharani You really should check out ASAP -Utilities - they are not in the Microsoft store but are incredibly comprehensive and used by all major companies including Microsoft. They are free for home and student and only $49 for Business use.
AWESOME video!! I especially like the date picker and bing maps add ins. A few questions about the date picker add in... what is the name of the add in? Does everyone who’s going to use the workbook need to install the add in? Can the date picker be automatically displayed either by settings or by VBA when a specific cell is selected?
The date picker is just a shape, so this sort of VBA works: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim shpC as Shape Set shpC = Me.Shapes("shpCalendar") 'I renamed the shape as shpCalendar If Not Application.Intersect(Target, Range("B2")) is nothing Then With shpC .Top = Target.Top .Left = Target.Offset.(0,1).Left .Visible = msoTrue End With Else shpC.Visible = msoFalse End if End Sub
Just tested, sending from my work to my home office, where I don't/didn't have the add-in installed, and when I select B2 (where the date picker is shown via the previous code), a box appears and inside, a message saying that a new addin is being used, and you simply click a "Trust" (or accept, or something!) box for it to begin working. Really simple. I like it.
I love your videos! Being a language instructor, I am amazed by your English pronunciation. To make it flawless, search on how to pronounce these words: education, module. I am a fan who respects your work!
I knew about only one of those. All very cool. I am not much of a bing maps user, but this add-in is so cool, I may need to rethink that decision. Thanks for a great video & list of add-ins.
Thank you for another great video, Leila! I have a question: when using Bing maps, can you use something different than country names? Let’s say a company has 13 offices spread around the country and I would like to have data about their sales plotted on a map. Is it possible to do so by telling Bing maps where these offices are? (Maybe adding another column with their coordinates).
Just started with add-in: Advanced Formula Environment This is an Editor for Name Manager but so much more for experts using LAMBDA. It can also read URLs from Github to load shared programming of functions. Pretty radical.
Great as always. I didn't have a positive thought toward Add-ins as I hadn't been able to install and use one. By watching this video I am attracted again toward Add-ins and I will give it a try. Hopefully they work this time.
Hmmm, can't use these due to organizational policy! :-( but great video as usual! Every Thursday is the day of Excel Enlightenment for me! :-) Long Live Leila!
Although its been 2 days since i am watching your videos partially, but this indeed is great knowledge you're sharing linking to my data reporting requirements.... Thank you.
your sweet voice makes me understand very easily leila thank you so much .............. good job and i;m still learning a lot from you about microsoft teams ......... keep on doing more videos like this .... keep it up 👍👍👍
Grab the file I used in the video from here 👉 pages.xelplus.com/excel-addins-file
I bought some of her courses on udemy (which are absolutely amazing btw,) and she's also now killing it on linked learning, she is unquestionably the most knowledgeable and highly skilled excel user and teacher that has ever existed. Period.
^^^TRUTH^^^
👍
Her videos are very good but there are many Excel MVPs on youtube; some have got that MVP award since 2009.
@@bunchie123
What does MVP stand for ?
Definitely one of the best. If I need a tutorial, I search for EXCEL and one or more key words. Some of the video creators do not put the necessary key words in the Title, meaning I would not find their video.
I started watching for quick tips but it has evolved into a fascination borderline entertainment. Keep the videos coming outstanding job!
How to install Add-ins 0:56
1. QR4Office 1:45
2. Web Video Player 2:46
3. Visio Data Visualisazer 3:41
4. People Graph 7:16
5. Mini Calendar and Date Picker 9:14
6. Bing Maps 10:48
Create an API (Application Programming Interface) 13:17
Thank you!
Thanx. This is useful!
I love your videos and courses. I am learning so much! The one problem I have is i inevitably fall down a UA-cam rabbit hole and watch your videos for hours 😅.
Youre an amazing Teacher and an inspiration, thank you!
Visio data visualizer is gonna change my life. Thank you!
Hi Leila, I purchased all your 8 courses at once on Udemy once I saw it, following you continuously, please keep feeding us with more scope. Power BI is really getting favourite and I would like to listen from your tutorials as well soon if possible. Thanks.
When I see videos like this, I like to write down the choices and try them out. I can usually find something I can use! Thank you for posting these!
Omg hands down best video for me. I need this for my data visualizations for work! Thank you Leila
Very useful. Thank you
I like the Excel Solver - for purposes of being able to find what combination of numbers add up to a certain total.
I wish that I had a teacher like you at school. Very fluent and clear enough.
I started looking for some tips on this channel, now I am obsessed with watching every single video. Thanks for creating such valuable content!!
Glad you like them!
Very good video. I Always learn something new rom your clear, concise, and well produced tutorials. Thanks Leila.
Glad to hear that, Andy!
Another gift from the goddess of Excel to XLSkind, thank you!
You're very welcome, Michael 😊
Great 👍
Mme Leila ... Thank you with all my heart for your presentation in all of your videos. They are very useful to me. Your explanation is very great. this is not a complement to you but this true, your excellent professor.
The more I learn..the more I realize how much I don't know..
Same here
I thought I was good at Excel ... I thought...
Amen brother!
It's called the Dunning-Kruger effect. Welcome to the club.
Goodness. Me too! Hahaha
You are an excel goddess. Few more tools in my arsenal. Thanks much for making this video.
I teach advanced Excel skills and am continually blow away, keep up the great work. AJ Sydney Australia
Even if the topic is complex, your videos and teaching style are extremely nice and easy to understand.
Thanks!
Thank you!
Your just so kind. Thanks for the knowledge.
Number 2 ........ VOILà !!!!!! that´s awesome! Adding an embedded video with instrucctions to "how to analyze this report" is going to lead to good UX for your users, thanks Leila !!!
Love that chair and the wall paper. Thanks for the great tips.
Great wall. Any idea if that is a virtual wall, or a real wall?
Some awesome add ins. My favorite Add in is the built in Solver - a must learn for any worth while manager.
It really is! Thanks for sharing.
@@LeilaGharani support.microsoft.com/en-gb/office/using-solver-to-schedule-your-workforce-7ae8dd69-7582-4f41-83f1-ea3543398b46
Excellent . Keep it up. I keep watching your videos . Very easily explained
very good you are wonderful
I really admire the way of explaining
Loved the QR one!
wow!! i learned about whole new way of using excel today. Thanks alot Leila for making this video :)
This was very useful, thanks Leila.
Thank you for your always informative informational videos. I watch one a day, and learn something new everyday!
My favorite Excel add-in Mini Calendar and Date Picker
Glad you found something useful.
Wow! Princess Leila on the white throne!😍
That date picker was so needed :-) Combining it with a line of vba code and it makes the parameter selections sooo much easier. Thank you, Leila! It was very informative and helpful.
Great to hear!
Could you share the example in which you combined the add-in with VBA?
Thank you for your videos. I now know my MS Excel better.
Wow Leila, you are the Pope in excell. From the little I saw, you are also an expert in development and programming. I also want to say that your English is easy to understand for foreigners and your teaching skills are excellent !!! Congratulations and thanks for sharing!
Wow, thank you!
Excellent. All the Add-on are nicely presented. Appreciate. Good luck
Thanks a lot
this video is deserved to get millions of likes 👍
Amazing feature from the best teacher
Seguo i tuoi tutorial con grande interesse. Sono molto ben fatti e compresi da tutti. Molte grazie, dalla Romania.
wow... the more you know about Excel... the more there is to know about it. Amazing
So true! There is always more to learn :)
Hi Leila. Great list of add-ins. Thanks for sharing them. Thumbs up!
Thanks Wayne. I hope they'll come in handy for you.
Thank you! Especially that handy mini calendar and Bing Map. I spent quite some time looking up addresses to use it, it's fun.
Leila thanks for your amazing tips!
Great List...Will get these immediately..Thanks.. For data management i like ASAP Utilities and RDB Merge.....
Thanks for your suggestions!
@@LeilaGharani You really should check out ASAP -Utilities - they are not in the Microsoft store but are incredibly comprehensive and used by all major companies including Microsoft. They are free for home and student and only $49 for Business use.
@@BBA1994 always wondered why Microsoft has not bought ASAP-Utilities off. .. ASAP-Utilities Rocks!!
As usual you do not disappoint. I cannot t wait to use these addin functions
As always , great video
All add-ins are wonderful with different use. Thanks for sharing :)
Thanks for watching Sachin!
AWESOME video!! I especially like the date picker and bing maps add ins. A few questions about the date picker add in... what is the name of the add in? Does everyone who’s going to use the workbook need to install the add in? Can the date picker be automatically displayed either by settings or by VBA when a specific cell is selected?
The date picker is just a shape, so this sort of VBA works:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim shpC as Shape
Set shpC = Me.Shapes("shpCalendar") 'I renamed the shape as shpCalendar
If Not Application.Intersect(Target, Range("B2")) is nothing Then
With shpC
.Top = Target.Top
.Left = Target.Offset.(0,1).Left
.Visible = msoTrue
End With
Else
shpC.Visible = msoFalse
End if
End Sub
Just tested, sending from my work to my home office, where I don't/didn't have the add-in installed, and when I select B2 (where the date picker is shown via the previous code), a box appears and inside, a message saying that a new addin is being used, and you simply click a "Trust" (or accept, or something!) box for it to begin working. Really simple. I like it.
I love your videos! Being a language instructor, I am amazed by your English pronunciation. To make it flawless, search on how to pronounce these words: education, module. I am a fan who respects your work!
Thanks Leila for sharing video on Add ins and it is very informative.
Lelia, brilliant short video. Thanks. Declan
Glad you liked it!
Nice one Leila. Can you do a definitive Maps video, esp with custom outlines to show how to display information/ data spatially?
Thanks in advance!
I knew about only one of those. All very cool. I am not much of a bing maps user, but this add-in is so cool, I may need to rethink that decision. Thanks for a great video & list of add-ins.
Excellent video presentation. Very useful Add-Ins. Thank you.
Thank you for another great video, Leila!
I have a question: when using Bing maps, can you use something different than country names? Let’s say a company has 13 offices spread around the country and I would like to have data about their sales plotted on a map. Is it possible to do so by telling Bing maps where these offices are? (Maybe adding another column with their coordinates).
Had same exact question!!
Hi, you can insert another column and add city name. Bing maps will point out those cities in the map.
Hope this helps.
@@ashuipmg I will try that. Thanks for helping me!
Absolutely amazing !!! It’s great learning from you.
Thank you! Cheers!
Thanks for the Add-Ins, I can now expand my Excel capabilities.
Thank You Mam. Your Videos are really very helpful.
Great video Thanks Mrs. Leila
Just started with add-in: Advanced Formula Environment This is an Editor for Name Manager but so much more for experts using LAMBDA. It can also read URLs from Github to load shared programming of functions. Pretty radical.
Great as always. I didn't have a positive thought toward Add-ins as I hadn't been able to install and use one. By watching this video I am attracted again toward Add-ins and I will give it a try. Hopefully they work this time.
Let us know if you found any of them useful.
Wow Leila , पहले क्यूं नहीं बताया , Help full tricks .Thanks
Hi, nice collection. What happens if I send a file with an add-in element to someone else? Like a bing map based chart. Will it work?
Really great add ins video.
God bless you 🙏 , and all your family
Very useful information Mam. Thank you very much
Awesome as always Leila. I should really start using more of these. Thanks for the upload. 👍
Glad you like it. Let us know what you found useful.
FREE ADD-INS! Valuable tips👍
incredibile how many new info i got from this channel... tnx
Our pleasure!
Thanks so much, Leila!
Hmmm, can't use these due to organizational policy! :-( but great video as usual! Every Thursday is the day of Excel Enlightenment for me! :-) Long Live Leila!
Thank you as usual, Leila. Thumbs up...
Thank you! Cheers!
thank you. I keep coming back to your videos and very informative.
Glad to hear that, Louis :)
Excellent tips and tools
Very useful information. Great Leila...
Tutorialnya bagus .senang sekali dan membabtu kerjaan saya.
I saw your video for the first time today, your way of explaining is very simple, I like your videos. Mahesh (India)
Thanks and welcome!
Wow! This is going to save me so much time and also be more professional.
Although its been 2 days since i am watching your videos partially, but this indeed is great knowledge you're sharing linking to my data reporting requirements.... Thank you.
Thanks. Fuzzy lookup is also an add-in worth trying
Thanks for the suggestion!
your sweet voice makes me understand very easily leila thank you so much .............. good job and i;m still learning a lot from you about microsoft teams ......... keep on doing more videos like this .... keep it up 👍👍👍
Quick question on the "Web Video Player" addin: Does the recipient of the file need the adding to view the video?
Yes, if the recipient does not have it they'll get a message if they trust the new add-in. Once agreed it will install the add-in automatically.
Good observation! thanks for pointing it out Kostas ! and thanks Leila, for answering it!
Many thanks! Your an Angel in disguise!
Nice overview of the add-ons!
I like the mini calendar and date add-on. Thanks.
👍
really loved it! thanks
You are Excel Goddess!
I thought i was some 'poweruser' ... until i visited this channel ...
jamc666 you and me both.
Me as well
Beautiful, attractive Leila. Very good video well explained and extremely useful add - ins.
I love it, thank you very much for this content !!
Date picker is best one ...time saver add ins
Thanks a lot! This is so useful.
Hi Leila, hope you are doing well. Thanks for sharing this immense helpful video.
You're so welcome!
Thank you Leila. well appreciated your videos.
Glad you like them!
Awesome and very useful
thanks ..only if i knew you earlier ...would have benefitted alot
great video
Thank you very much Leila gharani... Really you are superb...
My pleasure 😊
Love this video - thanks Leila!!
You're so welcome!
Thanks Leila. I can see some very practical uses in my business for a few of these add ins.
Glad you like it, Matt. Let us know which ones you found useful for your business.