Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/ Note: Add-ins have recently moved to the "home" tab.
Thanks! so many ideas and suggestions and you hit users of all levels. and your presentations are so clear and polished. really top shelf. thank you. rw
I have a similar experience. I made the request and shared the link to this video, and they were able to provide me with most of the add-ons, however I cant seem to find them in Excel 🙂
Everything you do is useful...no kidding, I've used so many of your tactics and secrets daily in performing my job...what a great treasure you are for me and my company...I like your coffee mug...I don't give a, got one at home...haha!
Once again, Ambassador Gharani is spreading Excel knowledge that benefits Microsoft users throughout the world. IMHO, no better qualification for the Nobel Prize. 'FRED' ... 'Wikipedia' ... and 'QR Codes' were the three BIG "Oh Wow!!!" moments for me ... 🤯🤯🤯 and will be used, or at least tried, this morning. Once again, Prof Leila shines a flashlight on areas that would take me weeks to find on my own. Thank you ... thank you ... thank you ... 😍😍😍
My iPhone can read my mind I believe 😮I was thinking about improving my excel and I am recommended a video related to same, Amazing !!!😊 seems Singularity is nearer 😮
I spent several days last week wondering why my forumla wouldn't work. My Microsoft Office suite is in Finnish... First thing tomorrow I install the Functions Translator! Thanks! :D
Thanks again, Mam!.... Am an avid fan here.... I applied most of my learnings in my office work.. My Supervisors were very impressed. More power to all "Online Professors"!... It's like l've earned units in Computer Science Course...
Leila, first off all, thank you for all your valuable contributions. I am preparing a workbook with 53 worksheets. One for each week of the year and one summary. I started designing the weeks format, all of them equal, just for the information, and the summary sheet. Then I wanted to do it fast and wrote an script which copy the first week, name it week2 and try to write a formula on summary that will sum a range on the new sheet. As I am creating a new sheet I need to name it. I create a variable, 'nombre = "Week" & n, where n is the week number. Then I select the correspondent cell in summary and try the following variables to write at summary: contract = "=SUM(" & nombre & "!R16C2:R16C11)", also, contract = "=SUM(Week2!B16:K16)" and ActiveCell.FormulaR1C1 = "=SUM('Week " & Str(n) & "!R[10]C[-2]:R[10]C[7])" among others. Nothing work. I recorded a macro and then copy the result to my script. Didn't work. Please help me with this issue. THANK YOU again for all your effort, for being so nice with us sharing some of your knowledge.
Hi Lela, your videos are really awesome and practical. Love it very much! If I may suggest, can you provide video on how to speed up excel with big data (100 MB) with macros. Thanks!
@@stevehaughton360 I couldn't find it either. It's now listed as "Excel Labs". When you add it, it then calls itself "Advanced Formula Environment", lol.
Hi Leila, your latest video was once again impressive and I am grateful for the valuable insights and information you provide. I have been utilizing the Zebra BI Charts add-in and would greatly appreciate it if you could create a video tutorial on its features and how to use it effectively. Blessings.
@@ZebraBI I am truly grateful for your prompt response. The information provided on the Zebra BI Charts add-in has been extremely helpful and my CEO is immensely impressed with the dashboards I have been able to create with it.
Really useful video. I've been looking for an easy way to transfer a lot of results of Excel formulas to Word. I'm definitely going to try Excel -to-Word. I've got high hopes. Wish me luck, but in any case, thanks!!
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/
Note: Add-ins have recently moved to the "home" tab.
Thanks! so many ideas and suggestions and you hit users of all levels. and your presentations are so clear and polished. really top shelf. thank you. rw
Wow, thank you!
This is a really great video. The only downside is that most of these would be useful in work environments but my workplace has disabled add-ons
Wonderful. I was working on a project, and I learnt everything I know in excel from you.
I have a similar experience. I made the request and shared the link to this video, and they were able to provide me with most of the add-ons, however I cant seem to find them in Excel 🙂
Never even thought about addins for excel. So a big thankyou. Wikipedia is 1st for me.
Everything you do is useful...no kidding, I've used so many of your tactics and secrets daily in performing my job...what a great treasure you are for me and my company...I like your coffee mug...I don't give a, got one at home...haha!
Once again, Ambassador Gharani is spreading Excel knowledge that benefits Microsoft users throughout the world. IMHO, no better qualification for the Nobel Prize.
'FRED' ... 'Wikipedia' ... and 'QR Codes' were the three BIG "Oh Wow!!!" moments for me ... 🤯🤯🤯 and will be used, or at least tried, this morning. Once again, Prof Leila shines a flashlight on areas that would take me weeks to find on my own.
Thank you ... thank you ... thank you ... 😍😍😍
Perfect! Glad you found something you can test right away.
More suggestions for the new name:
Formulas R us
The formula Ninja
Formulas plus Leila
Very useful. Thanks for collectively contributing all addin.
Bing maps, excel to word , and Fred seems ripe for the taking 😊. Thanks Leila
Cool! Now you can type our nice Czech sentence "Příliš žluťoučký kůň úpěl ďábelské ódy" we are using as a test for Czech characters 😁
Hi, ur newbie sub here from the Philippines. Ur tutorials are very clear & concise. Ur content are very informative. Thank u for the knowledge.
OMG 😮😮😮 Excel is always blow my mind! I only knew 2 of those add-in’s 😂 thanks for this content
Phenomenally phenomenal Excel teacher!
Dear Leila in 2023 wish you all best and thank you for your effort
Thanks so much for your video .your video is very simple and very useful for any one Thanks so much again
I have channel and I want to be as you thanks
youtube.com/@primaryfriends6522
Awesome! You always explain very concisely and clearly🙂 with an example timed and synchronized. You are appreciated!!!
Thanks Leila for the great tips and tricks with the add-ins.
Agree with most people here - awesome and very useful info. I didn't even know such things existef! Thank you.
Thanks Leila, this was great. I really like FRED and Wikipedia and I'm going to use these!
Wonderful! Hope they'll come in handy.
Great production.. nice good morning video. 🙏
Thanks for sharing...
My iPhone can read my mind I believe 😮I was thinking about improving my excel and I am recommended a video related to same, Amazing !!!😊 seems Singularity is nearer 😮
That's awesome!
Leila, another great and simple yet video. Thanks 🙂🌻☘️🪻
I spent several days last week wondering why my forumla wouldn't work. My Microsoft Office suite is in Finnish... First thing tomorrow I install the Functions Translator! Thanks! :D
Great info ... Thanks a lot 😁😁😁
Thank you Leila! Wow...really useful to know and use these add-ins to make work easier in excel!
Vielen Dank!
Sehr interessant; muss jetzt alles ausprobieren
Thanks!
Thank you, Leila!
Awesome video! Thanks for sharing!
Our pleasure!
FRED and Excel together ... number nerd heaven.
Thanks for this. Lots to learn.
Thank you so much! I can use all of these add-ins.
You are the best.... thanks as always for the content
Those add-ins are great! Thanks!
Thank you for sharing with us. Just recommended your vids to my son who uses XL alot. BkBs 🙂
Glad to hear. Hope it will be helpful for him.
Thanks again, Mam!.... Am an avid fan here.... I applied most of my learnings in my office work.. My Supervisors were very impressed. More power to all "Online Professors"!... It's like l've earned units in Computer Science Course...
Very cool, specially the QRCodes and the Bing Maps Thanks for sharing !
This is really cool video , thank you !!
Thank you. well explained video.
Great add-ins and thanks for this video. My N°1 is the Translator: it makes following courses so much easier!
You are a truly excellent teacher. Your method of teaching is excellent.
Thank you! 😃
Thank you so much Leila
Out of all the Bing map addin is the best. Thanks for sharing this ❤
My pleasure, Sam!
Thanks, Leila. 🙏
Thank you
Excel to word is really interesting for automating front pages in our project documents. Updating punlish information, for instance.
Thanks for your helps!
Thank you for your nice teaching
AWESOME :)👌
Leila, first off all, thank you for all your valuable contributions. I am preparing a workbook with 53 worksheets. One for each week of the year and one summary. I started designing the weeks format, all of them equal, just for the information, and the summary sheet. Then I wanted to do it fast and wrote an script which copy the first week, name it week2 and try to write a formula on summary that will sum a range on the new sheet. As I am creating a new sheet I need to name it. I create a variable, 'nombre = "Week" & n, where n is the week number. Then I select the correspondent cell in summary and try the following variables to write at summary: contract = "=SUM(" & nombre & "!R16C2:R16C11)", also, contract = "=SUM(Week2!B16:K16)" and ActiveCell.FormulaR1C1 = "=SUM('Week " & Str(n) & "!R[10]C[-2]:R[10]C[7])" among others. Nothing work. I recorded a macro and then copy the result to my script. Didn't work. Please help me with this issue. THANK YOU again for all your effort, for being so nice with us sharing some of your knowledge.
I already solved it. Cells(r, 4).Formula = "=" & nombre & "!L16" So simple solution!
always adding value.Much appreciated
Hi Lela, your videos are really awesome and practical. Love it very much!
If I may suggest, can you provide video on how to speed up excel with big data (100 MB) with macros. Thanks!
Great!!! Thank u Leila!
Very interesting. I will install some of them. Thanks 👍
Advanced Formula Environment was awesome. Thanks a lot.😊
where did you find it? it's not listed under Add-ins
@@stevehaughton360 I couldn't find it either. It's now listed as "Excel Labs". When you add it, it then calls itself "Advanced Formula Environment", lol.
Beautiful, above intelligence
Very good!
Also throwing this one in the hat.
Download ablebits, it has a wide range of uses but my favourite was how to change Cases.
Thanks Leila. You are a good teacher.
Thank you! 😃
Hi, this is great video
thank you
Thank you Leila! Really useful to know and use these add-ins to make work easier! Love your enthusiasm and passion to teach! Keep up the great work! 😊
Thanks, Vijay! Hope the add-ins will come in handy for you.
Very useful, 👍👍👍
Asusual, amazing. Appreciations for the thought of sharing knowledge and making it beneficial to all. Thanks Leila.
Great tips. Thank you!
Madam, your videos are excellent.
Bing maps! Amazing. Like having Power BI inside Excel.
Thank you Leila..
Very excellent mem
Great Video and insights which are really helpful.
great one, thank you for sharing
Thank you maam nice video
This was FANTASTIC!!! I will definitely be using several of these add-ins with Excel. Great job!
Glad you enjoyed it!
Yes she's awesome.
Thank you Leila! very informative one, I'd love to know more about the excelto word automate addin.
Amazing mind boggling I love everything
Hi Leila, your latest video was once again impressive and I am grateful for the valuable insights and information you provide. I have been utilizing the Zebra BI Charts add-in and would greatly appreciate it if you could create a video tutorial on its features and how to use it effectively. Blessings.
We'd love to team up! 🤗 Thanks Luis for using our Charts - hopefully they've helped you uncover lots of actionable insights
@@ZebraBI I am truly grateful for your prompt response. The information provided on the Zebra BI Charts add-in has been extremely helpful and my CEO is immensely impressed with the dashboards I have been able to create with it.
I like the (commercial) big set of useful tools from Ablebits 😍
Outstanding video!
Super mam
This is a great video. Thank you, Leila!
Glad you enjoyed it!
Thanks for information
Thanks
Thanks for the video, I would highly recommend ASAP Utility add on, time saver for a huge data modification
Thank you. These types of videos are awesome. My wife says that a person could run the world through excel. The more I learn the more I agree.
Great this is very helpful, excellent as always.😎
Really useful video. I've been looking for an easy way to transfer a lot of results of Excel formulas to Word. I'm definitely going to try Excel -to-Word. I've got high hopes. Wish me luck, but in any case, thanks!!
Excel to Word and to Power Point will kill all my copy paste capabilities! Haha
Always appreciate your research to make us better.
Glad to hear it.
Thanks Leila
Thanks for sharing! Learned a lot.
Do you know any good alternative to checkboxes?
They don't looked good in some display resolutions...
Excellent!!!!
Hi, Many thanks for your effort. Just for your information unfortunately I did not find the Advanced Formula environment in add in search
Thank you Leila.Very useful stuff.
Great!! Very helpful.
Thanks!
Great video
super, thx!
Another great video! Do add-ons add to the size of the excel doc?
Very usefull, thanks Leila!
Thank you for another great video as always.
Thank you 👍🏻
You’re welcome 😊