Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/ Need a chuckle to brighten your day? Our behind-the-scenes footage is the comedy relief you didn't know you needed! th-cam.com/video/S9OsWMOqzcI/w-d-xo.html
Thanks for the video, Leila! My two cents: If you"Excel" in a corporate job and want to show off your Excel skills, talk to your Learning (HR) team and offer them in-house training. That's the most effective way to bring values to the organisation, and getting people to know your values. :)
I learned Power Query from your course and it's been transformative in my role as a consultant. Still learning and I reference the course to sharpen up. Great channel and I think you are a wonderful instructor.
Thank you for this informative video Leila. i’m a civil engineer and i use Excel about 90% of the times. I improved my skills in Excel during my 4 years of experience as an engineer and i can tell you that i got addicted to Excel 😅 your videos helped me a lot and i’m really starting to think about giving courses or helping others in Excel!
Inspiring! I learned a lot from your TH-cam channel when I first started learning excel. I didnt know how valuable this skill was - got rehired by a former big boss with a handsome salary and promotion. Now I’m looking for other ways to generate side income with these skills. Thanks for sharing what worked for you 🎉
Congrats on the rehire and promotion. There are lots of opportunities to monetize your skills. There are lots of opportunities to monetize your skills. Good luck! 🍀
Leila you have always been a top notch coach,no doubt about that. Can you please list out more of those Excel skills that can be specially deployed for value creation purpose just like Power Query,Power Pivot and DAX.
J’avais donc raison ! J’ai « grimpé » dans la hiérarchie de l’entreprise où j’ai travaillé des années durant et pu parcourir les filiales pour "distiller" mon savoir sur Excel. Aujourd’hui retraité, j’ai créé mon entreprise de consulting en outils Excel et je gagne déjà de l’argent. Depuis que je vous suis sur TH-cam, j’ai toujours senti qu’il y avait des atomes crochus entre nous… Merci Mme Leila Gharani.😀
Well, a change is always welcome, and this one video off from the usual, is surely going to help many look for opportunities to not just apply their Excel skills, but make some money too! Thank you Leila and Jordan for your most valuable inputs! Keep up the great work of enriching all with your expertise and help! 🙂
Wow this video made me thinking about myself! In my job I’m kind of the “excel guru” of the team and had me opened new inside opportunities indeed! But never thought of scaling it..! Thanks for the great info and shared experiences! ❤❤
Thank you very much, my dear teacher @LeilaGharani for your useful information, lesson that I've been learning from the channel, the guidance is super clear and easy to understand.
Everything you put out is packed with a ton of value. Thank you so much for making this excellent video. I’ve purchased your classes in the past and have never been disappointed. You are a true professional.
Ma'am I always wanted to be a pro in Excel and always tried to learn excel but couldn't because I am not able to decide whether to remember the formulas or not? Suppose I want to learn in based on job prospective what are some basic things that I should have grip on and can call myself proudly I can work with MS Excel.
Hey...!!! Your content is amazing... can you please make a video on:- 1.)How to add data types in the data tab 2.) How to integrate copilot in Ms office
Pretty cool! I'm the go-to Excel guy at my work (small team) and have built a couple of fairly impressive financial reporting templates that my entire team uses. I've been an avid Excel user for 7-8 years. I don't know as much you do but I can do about 90% of what you have in your youtube videos and I'm always trying to learn more. Maybe I can start brainstorming how I would want to market myself and which Excel skills I want to focus on. Thank you for this video and the reminder that our skills can be very marketable! Cheers!
It’s all about finding your customer type. Honestly, the best way to start marketing is by marketing to yourself. What are the things that appeal to you? They likely appeal to your ideal customer. And the more alike you are, the more in sync you become.
Yep. Agree. My tutoring income is actually pretty good (everything is relative of course!); The only thing is excel on its own doesn’t help much for tutoring, but it’s a great tool to use in a variety of courses. You got me thinking about Feb 2024 :)
My wife and I are big fans of your channel. You've saved my so much time over the past few years and I thank you for that! Do you know a workaround to specify what window view the tab opens in? I've tried Microsoft and they suggested java and the API which I'm not currently an expert at. I use multiple windows of the same workbook and the behavior of opening a selected tab to a random window is beyond problematic when I'm collecting data from one window for another and I never know which window will be replaced by my tab selection.
Thank you for sharing this. I am a novice when it comes to Excel, but this makes me want to learn more about it to develop that skillset. Awesome video and thanks for the value!
Law firms, global document specialist - subject matter expert on MS and Adobe products and coding for extra measure and skills to deal with colleagues at all levels - even IT teams come to you when they can't work it out. If you can create solutions and be the go-to person for working problems out, you will be invaluable - even when firms continue to outsource their back office teams; they still need the best people onsite for hands-on assistance.
Hello, I'm a big fan of your tutorials! Could you please consider creating a video tutorial on Odoo ? It would be immensely helpful for those of us who prefer to learn in our native language. Your explanations are always so clear, and having an Odoo tutorial in Hindi would be a game-changer for many of us. Thank you for considering this request!
Got a Google Sheets question. I'm writing it here on your most recent video post so you'll see it. Is there a way to create a drop down list with sub drop downs. Right now the only thing I can find are dependent drop downs which involve a separate column of data/choices that opens up when you make your first choice. What I'm talking about is when you hover the cursor over the drop down menu choice and you automatically get a sub-drop down list to choose from. When you make your choice from the sub-drop down list it populates your choice in the original column. Not a separate column of data to choose from.
Hi Leila, I discovered your site accidentally and love it, including your style of educating as it is helping me get better at using Excel. I have seen in your videos and others that the use of merged columns is discouraged and wanted to know how to handle this when I need to group a series of rows that collectively form a unit of transaction. e.g., if I am tracking expenses across multiple events across multiple sites, I am using a sheet where individual expenses are grouped under a single event id, which along with other event-level details are shown as a merged row (e.g., event id, event location, total expenses etc). May be you have already done a video on this and appreciate your guidance. Thanks
I am agreed with first 2 points. I laways learn and apply new excel techniques also i give training in my organization, which is positive point for me. however how to do 3 - 4 woking on it.
In new outlook, I can't find the trust center and add-ins in options(there is no options) ; I read we need to install them manually. In new outlook, I can't find office accounts, account settings, tools, and a lot of missing tools.Can you provide a video to solve these issues?
Hello mrs leila , Thank for the videos , Honestly, I have found ways to solve most of the problems on Excel because of your videos, presenting your videos and explanation of something simple. I have a problem with VBA and I have not found a solution for it yet. I use a macro in Excel and the code is for the filter. I will show it to you in the next comment, but my problem is that I did not find a solution to resist the sheet. I want to protect the sheet from any modification and only use the text box that I added from the developer. Can you help?
*note: my excel version is 2007 Private sub textbox1_change() Application.Screenupdating = false Activesheet.listobjects (“searchtable”).range. Autofilter field:=1, cirteria1:=[f3]&”*”, operator:=xlfiltervalues Application.screenunpdating = True End Sub ----------- Private sub textbox2-change() Application.Screenupdating = false Activesheet.listobjects (“searchtable”).range. Autofilter field:=2, cirteria1:=[h3]&”*”, operator:=xlfiltervalues Application.screenunpdating = True End Sub
I wish I had learned Excel skills instead of wasting my time on Python, R, and SQL. Now I’m a senior data scientist with no job prospects, while the Excel gurus are making millions with their pivot tables and VLOOKUPs. Maybe I should watch this video and start from scratch. 😂
Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/
Need a chuckle to brighten your day? Our behind-the-scenes footage is the comedy relief you didn't know you needed! th-cam.com/video/S9OsWMOqzcI/w-d-xo.html
Keep it up ... Leila ..
Thanks for the video, Leila!
My two cents: If you"Excel" in a corporate job and want to show off your Excel skills, talk to your Learning (HR) team and offer them in-house training. That's the most effective way to bring values to the organisation, and getting people to know your values. :)
Great advice! Thanks for sharing!
I did this back in 2014 - and those were among my first workshops. Great advice!
Thank you!
You are my favorite Excel teacher. Everything I have learned from your courses, I use in volunteering for a better world.
I learned Power Query from your course and it's been transformative in my role as a consultant. Still learning and I reference the course to sharpen up. Great channel and I think you are a wonderful instructor.
Awesome to hear Power Query has upped your game! Thanks for the kind words, and keep on learning! 😊
You can say that again
Thank you for this informative video Leila. i’m a civil engineer and i use Excel about 90% of the times. I improved my skills in Excel during my 4 years of experience as an engineer and i can tell you that i got addicted to Excel 😅 your videos helped me a lot and i’m really starting to think about giving courses or helping others in Excel!
Nobody with brains needs help from you, they can figure out those things on their own.
If I can be a Digital Hermit instead of a Digital Nomad, you've got me on board!
You would fit right into our team 🤓
@@LeilaGharani 😆 Fantastic! My dream is one step closer....
@@LeilaGharanican you please hire from eastern Europe? I very much like the Excel ecosystem and could definitely use the long distance job😊
@@LeilaGharanithank you very much for the useful information and guid. I really love to watch all your videos get more from them.
@@ChrisGladisqqacçxx😷
Knowledge is power ✍️, what you know can be paid for💰🙏
💯
Sure, provided that your knowledge is marketable.😉
Knowledge is power!!! only when organized and channelled toward a course!
As an Excel trainer. I find this to be one of the most insightful watch on earning from Excel.
You might have the best degree in the world.But it is your skill that really count.Thank you very much for the video
I need to write my first excel book ❤
Can you teach me Excel?
I'm still trying to understand Excel, and your channel is one of the channels for learning Excel.
Thank you for everything.
Glad to hear that!
Inspiring! I learned a lot from your TH-cam channel when I first started learning excel. I didnt know how valuable this skill was - got rehired by a former big boss with a handsome salary and promotion. Now I’m looking for other ways to generate side income with these skills. Thanks for sharing what worked for you 🎉
Congrats on the rehire and promotion. There are lots of opportunities to monetize your skills. There are lots of opportunities to monetize your skills. Good luck! 🍀
@@LeilaGharani Why you gonna type that twice? Why you gonna type that twice?
Not sure. Got carried away I guess 😊
Leila you have always been a top notch coach,no doubt about that. Can you please list out more of those Excel skills that can be specially deployed for value creation purpose just like Power Query,Power Pivot and DAX.
You have been an inspiration for me since the very start...
In the right time and the right place, I needed this advice.
Thanks, Leila.❤
You're so welcome! Many thanks for your continued support!
J’avais donc raison ! J’ai « grimpé » dans la hiérarchie de l’entreprise où j’ai travaillé des années durant et pu parcourir les filiales pour "distiller" mon savoir sur Excel.
Aujourd’hui retraité, j’ai créé mon entreprise de consulting en outils Excel et je gagne déjà de l’argent.
Depuis que je vous suis sur TH-cam, j’ai toujours senti qu’il y avait des atomes crochus entre nous…
Merci Mme Leila Gharani.😀
Well, a change is always welcome, and this one video off from the usual, is surely going to help many look for opportunities to not just apply their Excel skills, but make some money too! Thank you Leila and Jordan for your most valuable inputs! Keep up the great work of enriching all with your expertise and help! 🙂
Thank you so much, Vijay! Glad you liked our little experiment 😘
Wow this video made me thinking about myself! In my job I’m kind of the “excel guru” of the team and had me opened new inside opportunities indeed! But never thought of scaling it..! Thanks for the great info and shared experiences! ❤❤
So glad the video got you thinking about new possibilities!
Thank you very much, my dear teacher @LeilaGharani for your useful information, lesson that I've been learning from the channel, the guidance is super clear and easy to understand.
All this can go for any skill, but the first tip is a very important one for excel users
The truth that you have graduated from zero to hero is inspiring to me.
That's great, I already started the way 1, 2, and 6 plus making excel product. Keep fighting and following you masters! 😊
Love that you're diving in with multiple approaches. Keep up the awesome work, and thanks for the support! 😊
I really love the shout out for Oz! The three of you are true MVP’s 🏆
We love Oz 😊
Everything you put out is packed with a ton of value. Thank you so much for making this excellent video. I’ve purchased your classes in the past and have never been disappointed. You are a true professional.
Thank you so much for the kind words! Happy to hear you enjoyed our courses too.
Your content is really great, and one can make the most of every single minute. Thanks for all your efforts and generous sharing.
Ma'am I always wanted to be a pro in Excel and always tried to learn excel but couldn't because I am not able to decide whether to remember the formulas or not? Suppose I want to learn in based on job prospective what are some basic things that I should have grip on and can call myself proudly I can work with MS Excel.
At the 12:13 mark: " ... If you want to keep your Excel skills up to date ... you are in the right place ...".
Absolutely ... 😍😍😍
Thank you, Chris! 😘
@@LeilaGharani 😳😳😳 ... 😁
❤dear Laila,
Please make a topic about simple Macro on Excel
How about this one: th-cam.com/video/An-2Nxf_Dms/w-d-xo.html
It's an honor for me that your video is suggesting my videos at the end. Great video, I love all of this Leila!!!
Hey...!!! Your content is amazing... can you please make a video on:-
1.)How to add data types in the data tab
2.) How to integrate copilot in Ms office
Oh my, I need to do something about this. I've procrastinated for so long. You're my inspiration 👍👍
Plenty of time left, William! Now go get it done! 💪😁
There’s no better time to start than now!
@@JordanGoldmeier I'll push myself. We shall review this in a few months🙂
Great to see you toghether.
I am looking for a change in my current role, but I am not sure how to go forward. I will continue to watch and learn.
These are two geniuses who don't know they are that. Learning VB by themselves and creating that form is no joke.
OW MY ! OW MIGHT LORD!!! You’ve become Excel Superstar Celebrity!! What a great interview!! You go girl !!! Way to go! ❤❤❤congratulations!!! Muaaah!!
I got interest in excel not long ago. Im looking forward to learn more about your course
Pretty cool! I'm the go-to Excel guy at my work (small team) and have built a couple of fairly impressive financial reporting templates that my entire team uses. I've been an avid Excel user for 7-8 years. I don't know as much you do but I can do about 90% of what you have in your youtube videos and I'm always trying to learn more. Maybe I can start brainstorming how I would want to market myself and which Excel skills I want to focus on. Thank you for this video and the reminder that our skills can be very marketable! Cheers!
It’s all about finding your customer type. Honestly, the best way to start marketing is by marketing to yourself. What are the things that appeal to you? They likely appeal to your ideal customer. And the more alike you are, the more in sync you become.
@@JordanGoldmeier . Good points! Cheers!
This is very inspirational Leila, it came at a time when i really need it the most. Thank you.❤
Thanks Leila. Just what I needed and always wanted to ask you. Best wishes from South Africa.
Yep. Agree. My tutoring income is actually pretty good (everything is relative of course!); The only thing is excel on its own doesn’t help much for tutoring, but it’s a great tool to use in a variety of courses. You got me thinking about Feb 2024 :)
Hope to see you there :)
Wow so useful and honest advice, thank you!
You're so welcome!
Well told, well done!👍🌍👋
Thank you kindly
this video was sooooo helpful and inspiring!!!
Leila is a role model. I love you ❣️
Thank you, great video! Perfectly timed too as I am leaving my job and want to find a more interesting career path with my mad Excel skills ;)
Best of luck!
@@LeilaGharani Thank you! Many of these skills I learned from you on your channel btw!
@@stefaniecalistoHow long you have learned excel?
I love this video....Me too Leila! I learned myself and im the "excel guy" everywhere i go.
Love that!
My wife and I are big fans of your channel. You've saved my so much time over the past few years and I thank you for that!
Do you know a workaround to specify what window view the tab opens in? I've tried Microsoft and they suggested java and the API which I'm not currently an expert at. I use multiple windows of the same workbook and the behavior of opening a selected tab to a random window is beyond problematic when I'm collecting data from one window for another and I never know which window will be replaced by my tab selection.
Muy buena la información todo se resumen es que debemos comenzar el proyecto que tengamos y escalar paso a paso gracias
This was a fantastic, neat and precise summary!
Glad you liked it!
Strong, clear and bold message, yet friendly. I am definitely your fan Leila
Thank you for sharing this. I am a novice when it comes to Excel, but this makes me want to learn more about it to develop that skillset.
Awesome video and thanks for the value!
thank you for the video,
I love it!!
U always amplify my knowledge of excel. Great
Great tips from the Excel Goddess!
Leila, eres una genia. Cuando sea grande quiero ser como vos 😊
Madam, is it possible that I can add and carry over digits to the left in excel?
Law firms, global document specialist - subject matter expert on MS and Adobe products and coding for extra measure and skills to deal with colleagues at all levels - even IT teams come to you when they can't work it out. If you can create solutions and be the go-to person for working problems out, you will be invaluable - even when firms continue to outsource their back office teams; they still need the best people onsite for hands-on assistance.
Leilani, could you do a Macros tutorial? I want to figure out how to automate some engineering tasks.
Maybe this will get you started: th-cam.com/video/An-2Nxf_Dms/w-d-xo.html
Thank you for the advice
So in order to get started with consultation do I need to learn VBA? what do hiring people expect you to know?
Hello, I'm a big fan of your tutorials! Could you please consider creating a video tutorial on Odoo ? It would be immensely helpful for those of us who prefer to learn in our native language. Your explanations are always so clear, and having an Odoo tutorial in Hindi would be a game-changer for many of us. Thank you for considering this request!
Votre réussite est due surtout à votre persévérance, Mais l'excel est une matière que vous aimez c'est tout.
Thanks Ma'am you are always amazing as usual
Thanks for this motivational video. So uplifting.
You are so welcome!
Als eine Iranerin, sprichst du sehr gut Englisch!
Thank you so much for making this excellent video.💖
Glad you enjoyed it!
microsoft excel or sql, which would be best for accounting?
Trying to get gigs for the last 6 months, tried everything.
Got a Google Sheets question. I'm writing it here on your most recent video post so you'll see it. Is there a way to create a drop down list with sub drop downs. Right now the only thing I can find are dependent drop downs which involve a separate column of data/choices that opens up when you make your first choice. What I'm talking about is when you hover the cursor over the drop down menu choice and you automatically get a sub-drop down list to choose from. When you make your choice from the sub-drop down list it populates your choice in the original column. Not a separate column of data to choose from.
Hi Leila,
I discovered your site accidentally and love it, including your style of educating as it is helping me get better at using Excel. I have seen in your videos and others that the use of merged columns is discouraged and wanted to know how to handle this when I need to group a series of rows that collectively form a unit of transaction. e.g., if I am tracking expenses across multiple events across multiple sites, I am using a sheet where individual expenses are grouped under a single event id, which along with other event-level details are shown as a merged row (e.g., event id, event location, total expenses etc).
May be you have already done a video on this and appreciate your guidance. Thanks
Thank you for this video.
Very well said, Leila. Nice job!
Inspiring Ms. Leila. Thanks!
I am agreed with first 2 points. I laways learn and apply new excel techniques also i give training in my organization, which is positive point for me. however how to do 3 - 4 woking on it.
0:56 is this the paperless office? 😂
You are lovely and offer great advice!
Glad you think so!
Thanks!
Question is Why would someone want to buy a paid course on Excel when majority of it is available for free on YT
Because people would rather have someone physically there to talk to
Clicked because of the Thumbnail ❤
Hope the content did not disappoint :)
great video, thanks❤
In new outlook, I can't find the trust center and add-ins in options(there is no options) ; I read we need to install them manually. In new outlook, I can't find office accounts, account settings, tools, and a lot of missing tools.Can you provide a video to solve these issues?
Hello! I have not job ,what i do for job ? what skill need ?suggest me
You are very impressing.
Hello mrs leila ,
Thank for the videos , Honestly, I have found ways to solve most of the problems on Excel because of your videos, presenting your videos and explanation of something simple.
I have a problem with VBA and I have not found a solution for it yet. I use a macro in Excel and the code is for the filter. I will show it to you in the next comment, but my problem is that I did not find a solution to resist the sheet. I want to protect the sheet from any modification and only use the text box that I added from the developer.
Can you help?
*note: my excel version is 2007
Private sub textbox1_change()
Application.Screenupdating = false
Activesheet.listobjects (“searchtable”).range. Autofilter field:=1, cirteria1:=[f3]&”*”, operator:=xlfiltervalues
Application.screenunpdating = True
End Sub
-----------
Private sub textbox2-change()
Application.Screenupdating = false
Activesheet.listobjects (“searchtable”).range. Autofilter field:=2, cirteria1:=[h3]&”*”, operator:=xlfiltervalues
Application.screenunpdating = True
End Sub
Thank you so much @LeilaGharani. This is exactly what I needed. Thank you
Glad it was helpful!
Love the videos. By the way, I thought that surprise guest was Pauly Shore when I first saw the picture of him haha.
Lots of people think I’m Pauly Shore, Kenny Gee, or Weird Al but never Howard Stern.
Thank You
Excellent! Thank you Laila
Thanks for the video. Do you have any video on currency exposure management?
Thank you for this video!
Seventh way to make money with Excel : being a coach on "How to make money with Excel Skills" 😂😂😂👍👍👍
It’s true - I tried doing this for a minute but I’d rather just give the knowledge away for free so that others can use it
Thank you for this video, and all your previous video they always add value !!!
I wish I had learned Excel skills instead of wasting my time on Python, R, and SQL. Now I’m a senior data scientist with no job prospects, while the Excel gurus are making millions with their pivot tables and VLOOKUPs. Maybe I should watch this video and start from scratch. 😂
You can pivot, skillshare free trial 7 day, excel courses on there
For real.....
no wayyyyyyyy😢
Broooo 😂
Joke?
Leila on point as usual
Excellent💯💯💯
In excel which part is brain? How does improve our excel skill efficiency? What do for that
@Thank leila, I would need s freelance job
Thank you for the video
Our pleasure!
Great!
👍⭐⭐⭐
Thanks for video
Let me know how to learn the foundation of VPA