Join over 2000 professionals in our Business Charts in Excel course 👉 link.xelplus.com/yt-c-pro-bizcharts-course
@dulceisha5 ай бұрын
Hi. the coupon is not working well. I added the other course as well but the code only applied to one item.
@dulceisha5 ай бұрын
Placed the order but could not complete the excel add-on course.
@LeilaGharani5 ай бұрын
@@dulceisha hi, the launch coupon only applies to this course. If you run into any problems please write an email to info@xelplus.com
@dulceisha5 ай бұрын
@@LeilaGharani ok. But on the page it was listed that I could get a discount without the code.
@teemad5 ай бұрын
Leila, great video as always. I have to say however, you may be one of the world's top Excel resources and no doubt you love what you do, but you are missing your true calling. Comedy! The timing first on the "woah, wait" bit and then the coffee sip was just comedic genius! 🤣
@LeilaGharani5 ай бұрын
ahhh thank you! When I first read the "but," I thought you were going to say, "but why do you have to tease IT again?" 😉 It was nice surprise. I always liked acting, but I have no talent. But everything can be learnt.
@h.esther94005 ай бұрын
I think you have acting talent - I’d watch a pro vs noob tv series!
@Meow2Kaco5 ай бұрын
I agree! When she said “woah, wait!” I thought “oh, she’s gonna cheat the 90 second limit by explaining a bunch of stuff before the timer starts, and she didn’t. And when the timer actually started, while all viewers are watching like “how is she going to do this?!” with our eyes wide open, she used up more than 10 seconds for sipping coffee 😂 That was awesome!!! Love this excel trick too. I use Power BI for reporting a lot, but there are some users who prefer excel. I love both. And I cannot wait to use this technique to make my users go “Wow!”
@teemad4 ай бұрын
@@LeilaGharani Sorry for the late reply, I don't have notifications on. I actually think you definitely have acting talent. If you have a passion for it then you should definitely explore that side of you. But please don't forget us lowly Excel and Power BI users pretty please, we still need your expertise! 😂
@ManafKAMIL5 ай бұрын
Brilliant... and I totally agree with you, the coffee sip at the start is very important 😁
@LeilaGharani5 ай бұрын
😊
@kdub6075 ай бұрын
Your presentations and demos are always flawless! I love that you can take a seemingly complex Excel format and not only make it look easy to follow and learn, but do it quickly and almost effortlessly. Thank you for sharing your knowledge set and making more of us look like spreadsheet savants! 🥰
@LeilaGharani5 ай бұрын
Thank you so much for the kind feedback! 🙏
@quiqueenrikx39925 ай бұрын
You're simply the best. Thanks!!!!
@mafp22w5 ай бұрын
What an amazing example for a young woman today.
@BORISVLEONOV5 ай бұрын
"Now I'm ready". It was perfect! 😊 Thank you for the video!
@CatharinaDavies5 ай бұрын
Thank you Leila, I have already purchased this course and can’t wait to delve in !
@LeilaGharani5 ай бұрын
Wonderful! Thanks a lot for choosing the course! I'm sure you'll find it super useful. If you run into in any questions, let us know. Enjoy!
@grtraders5 ай бұрын
I am falling in ❤ with this lady every single day. She is simply brilliant with what she has to present. Jokes apart, I think no one on this planet can teach excel better. Thank you for teaching us and making the internet worth its existence. Please keep up the good work.
@vikastiwari71345 ай бұрын
hope you got permission from your wife before post this msg😂😂
@grtraders5 ай бұрын
She is always by my side. 😊😊😂😂
@andrew75865 ай бұрын
Great video/tutorial. It shows that Excel can be for much more than complex spreadsheet applications.
@mr.gk55 ай бұрын
Hey I love your videos on Mckinsey and The Economist styles, please do more videos on this topic. Keep up the good work!
@LeilaGharani5 ай бұрын
Thank you! Will do!
@mr.gk55 ай бұрын
@@LeilaGharani thank YOU! Your videos have helped me a lot at work. I just wanna let you know you’re making a difference by helping so guys on the internet to improve his work and gain recognition
@Wio_La5 ай бұрын
Dear Leila, thank you for your great work! You are the best teacher I have ever met!
@LeilaGharani5 ай бұрын
Wow, thank you!
@chh88605 ай бұрын
A unexpected Tuesday surprise!!! ... good thing I was ready with a cup of hot coffee ... flawless presentation once again ... 😍😍😍
@LeilaGharani5 ай бұрын
Guess what? I thought about you when we decided to publish today instead of Thursday. I'm glad you and your coffee were both ready and we got you in time ☺
@chh88605 ай бұрын
@@LeilaGharani 😂🤣😂🤣😂🤣 ...😍😍
@carlos24085 ай бұрын
Well I am so glad to have a long format video back.
@LeilaGharani5 ай бұрын
So am I. I tried the shorts, but I'm a fan of long form.
@Kerbis1799Ай бұрын
Thanks for an amazing video as always. Unfortunately the cost of the course is really expensive for me. But thanks for all the free content
@djtomasuk4 ай бұрын
gotta love the creativity of how to make even a tutorial fun to watch and learn!
@LeilaGharani4 ай бұрын
Thank you! Cheers!
@enlighten925 ай бұрын
I have enrolled in the course. Loving it. Taking it all in slowly. There is so much content..
@VancouverVortex5 ай бұрын
Nice to see this on your. I hate to say it but this is how I used to set up automated Gantt charts using an invisible character and conditional format colours and I did that in the 1990s!
@mrknighttheitguy84345 ай бұрын
Always enjoy these videos. Thanks.
@gabrielenicolini59885 ай бұрын
Brava Leila - this is an excellent clip and I look forward to the end on the month report to try to include that chart. Grazie mille!
@LeilaGharani5 ай бұрын
Glad you enjoyed it!
@humansizedaperture5 ай бұрын
Your videos are as lovely as your solutions.
@mike424415 ай бұрын
Excellent tutorial !! Love the sipping & savoring of good coffee, always part of the full Excel experience : )
@DeniseVajdak5 ай бұрын
You always have the coolest uses of Excel functions!! ❤
@timwood1015 ай бұрын
You’re a very clever trainer.
@moniquemassen41813 ай бұрын
Hey Leila, LOVE your tips! In your video you mention that you can change the maximum length of the bars in a field, how do you add that to the formula?
@beebop43335 ай бұрын
QUESTION- hi. I luv your channel. Is there a way to slow down your explanation and keystrokes on the video? I am a bit slower and want to learn.
@AJ-nm9gb5 ай бұрын
beautiful function....!
@Tkourtog5 ай бұрын
Once more another great video Leila! I can use this technique in one of my projects. Great 90" idea (with a coffee).. Thanks for sharing!
@טלקרן-ט7ב5 ай бұрын
Simply as usual. Thank you Leila!!
@LeilaGharani5 ай бұрын
Glad you like it!
@michaeldebellis42025 ай бұрын
I can do it in a lot less than 90 seconds. Select the data. Go to search field at the top and type "create chart". Select the clustered bar chart (3rd option from the top). Done.
@rkalle665 ай бұрын
Now you can just add 99-x% repeats after the dot to the right side. Deduct additional 4 when placing the percentage number. ───●─── ─────●─ And you may even format the right bar part in grey or not in bold. It's all included in the extended ascii (IBM) character set to draw frames only with characters. But ... Don't forget to check it on printed paper.
@LeilaGharani5 ай бұрын
Thanks for sharing your tips!
@StepByStepExcelTutorials5 ай бұрын
Love this, so important for those in the finance field!
@AjayKumarYadav-dv1xs5 ай бұрын
Leila, your all video are awesome, short crisp and to the point, please also include MySQL
@emmaeIIe5 ай бұрын
Oddly I am also interested in how you bring up the emoji picker. This chart is amazing too lol
@howardhautville42085 ай бұрын
Hold windows key and tap .
@fabianerouille98395 ай бұрын
Didn’t work for me
@JustinWeis5 ай бұрын
didn't work for me either. what did work was inserting a symbol in another cell and copy/pasting it where she inserted the emoji.
@Lanykos5 ай бұрын
Hi Leila, you are a great Excel expert, thank you for this videos. McK is working with add-ins to create charts, 90 seconds is to slow in this business, time is money 😂
@LeilaGharani5 ай бұрын
I know, they're selling it too and it's great. But it's expensive 💸
@RogerStocker5 ай бұрын
Fully agreed, the course is a gold mine even for advanced users. all these nice things behind the scenes, are captivating. I can't get away from the screen. "Only the next one..." is my repetitive statement to myself once I start taking a look to the videos in the course.
@LeilaGharani5 ай бұрын
That's awesome to hear Roger! I love that you're finding so much value in the course and can't peel yourself away from the screen ❤🙂
@Erni7608033 ай бұрын
Thanks
@LeilaGharani3 ай бұрын
Thank you! Glad the video was helpful.
@ganpatkumhar16345 ай бұрын
Hey Leila, make a video on how to Vstack Spilled Ranges in Excel. For example, I have spilled ranges in cells A1,A2,A3 all the way to cell A50 having 5 columns, however i want all the ranges to be stacked one below the another. How to go about it ?
@asiminatsamou5 ай бұрын
very informative! please though note that even I have used the fonts for monospace when I am adding comments in the example, it does not work properly. thank you in advance for the tip!
@andrearadaelli7035 ай бұрын
Great video and explanation!
@rolanddes4 ай бұрын
Hi Leila, I love your channel and appreciate your content. Would you mind getting into how we can incorporate ChatGPT into our data analysis and presentation?
@PSModelling5 ай бұрын
Clever solution, nice job.
@Healingforyou힐링음악영4 ай бұрын
Hello Leila, do you have a plan on launching new course particularly on power bi advanced visualization techniques with modern design? I am sure you'd agree that design is also as important as Power Query, Data Modelling or DAX when it comes to reporting especially for end users.
@orthopaedicmd5 ай бұрын
Super pro tip!! I love this hack! Will be using for sure!
@LeilaGharani5 ай бұрын
Wonderful!
@brazilbeyondtheheadlines5 ай бұрын
You are great! Thanks for this
@LeilaGharani5 ай бұрын
You're very welcome!
@barneshudson5 ай бұрын
this was a great start
@chrism90375 ай бұрын
Awesome Leila!!!
@yossiea5 ай бұрын
Is it just my version or do I have to do something for the image search bars to popup? When I put in REPT, I have to manually input an image or text. -edit- for those interested, it's not an Excel issue. You can get the Windows Emoji Picker by pressing Windows. at the same time (windows + period)
@edlsantosmz4 ай бұрын
Thanks!
@MarkLogue5 ай бұрын
Leila, Thank you. I have been watching your videos for over a year now and I am actually getting my arms around this thing called Excel. Keep the comedy coming with your little coffee jokes. Here is one for YOU - What’s the opposite of coffee? Sneezy. LOL
@LeilaGharani5 ай бұрын
😅 Love that.
@sultanwot71525 ай бұрын
Thank you
@saanjhrochlani12284 ай бұрын
How to fix the size of largest bar, please share formula as this was missed in the video.
@smguy29455 ай бұрын
Great video! But unless I missed it, there was no explanation of what you did in the part about scaling numbers back when you are presenting large numbers? Was it just to divide the larger number by a large number to get the rept function to show less? And how did the bars accommodate the text added like "VIP campaign" and "announcement"?
@IsMirDochLattens5 ай бұрын
I didn't buy the course but i'd imagine that she used a monotype font (all characters have the same width) and then she just subtracted the length of the text from the repetition multiplicator. For the scaling you would divide the value of the row by the max of the data column and multiply it by the chosen length. So the largest number is divided by itself (=1) which results in 1* chosen length. So a bar that has half of the max value would result in 0.5 * chosen length. Edit: Font it probably "Hack" Edit2: No it's not, the dot at the end doesn't align. But it is close.
@vinimaysingh77135 ай бұрын
I used “Consolas” font and the same approach and it worked. Dumb question though, how I go about the conditional formatting to highlight the row with highest value. Thanks. Figured the conditional formatting part too.
@Hamromerochannel5 ай бұрын
I see it differently. I figure out we always limited only by imagination. Now she gave me an idea, I will go figure it myself. Excellent idea about scaling. In fact excellent way of visualisation I had never thought of.
@abbybia31134 ай бұрын
Can you have a bar comparison? (2 column w data, instead of one?
@unnikrishnansanthosh5 ай бұрын
as always, majestic
@MrSupernova1115 ай бұрын
Very cool! Thanks!!
@kisa6605 ай бұрын
great video, just a small comment. why not use the chart function? it is way more faster, and easier.
@TheDigitalOne5 ай бұрын
👏👏👏 Pretty fast, good timing, ehehehe. I guess is all the function formulas knowledge, I know a little bit more complicated that, excellent informative video, tho! 😺⭐️💎
@BillyG1755 ай бұрын
Loved this ❤ thank you
@ExcelTemplatesSolutions5 ай бұрын
very useful thank you
@nicolebrown2305 ай бұрын
Thank you for this presentation. Couldn’t you have selected a graph in the ribbon that would have automatically converted the data into bar chart?
@arghyadutta90913 ай бұрын
Awesome
@AW990175 ай бұрын
Great video as usual, what's the hexidecimal code for the solid box symbol in A25? I can't find it anywhere!
@steveparish11034 ай бұрын
I found it in Excel's Insert > Symbol menu: Unicode name = Full Block, Character Code = 2588, from Unicode (hex)
@steveparish11034 ай бұрын
Font = Times New Roman and Subset = Block Elements I hope this helps.
@fabianerouille98395 ай бұрын
Loved it, but I can’t make the symbol window appear. I held Windows and tapped . As suggested but didn’t work
@thagmets5 ай бұрын
Please, what is the best slide size for data show presentation? I have a presentation in 18 days 😬😬, thank you.
@RayPayette5 ай бұрын
Excellent!
@benosborne4134 ай бұрын
Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks
@MrGaryg200475 ай бұрын
I'm currently an online student with City College of San Francisco and do you have uploaded videos on working with queries and reports using access 365 for year. 2024?
@robertooliveira94245 ай бұрын
Hi there! I'm struggling with a print layout in Excel. I have 5/10 centimeter cards where I have to print icons in specific positions. but I can not. any tips on custom printing in excel?
@ScruffR705 ай бұрын
6:00 this will only work with (some) non-proportional font types as the width of all the comment characters *_must_* be the same as the width of the "bar" character - I didn't hear that pointed out.
@mushtaq20084 ай бұрын
Hi Leila, I came across this video today, any possibility of getting an extension to the 20% discount
@zarnigarmacnunova85335 ай бұрын
In one words: WONDERFUL TEACHING and SUPER RESULTS❤
@ohtheresheis85425 ай бұрын
The coffee at the beginning was such a power move, I am still recovering! ❤
@LeilaGharani5 ай бұрын
😊
@hansangb5 ай бұрын
Thanks!
@LeilaGharani5 ай бұрын
Thank you!
@irajchaiiasletabrizi57375 ай бұрын
Hello how are you. Can I give you an interesting suggestion about a topic?
@SyedMuzammilMahasanShahi5 ай бұрын
Thanks for the share.
@LeilaGharani5 ай бұрын
Thanks for watching!
@AmritAssi5 ай бұрын
Do you have an Excel course on Udemy ?
@flipinfin5 ай бұрын
Great video. How would you change a color of series when you clicked on it?
@moorabinda5 ай бұрын
Will any coffee do? Or does it need to be a specific brew? Asking for a friend
@abbybia31134 ай бұрын
What is the scale function?
@rahulvishwakarma21195 ай бұрын
Hi I want connection my Power query to cloud tally plz. Help
@saneshkp98103 ай бұрын
can we use the chart to ppt
@arne.munther5 ай бұрын
How did you get that pop-up at 1:17 ?
@lisaalso78755 ай бұрын
Hi. I had to google that. To get the emoji picker, press the windows button plus the period, OR the windows button and the semicolon. ✌
@cadelly5 ай бұрын
I am soooooooo amazed!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@ereinaud5 ай бұрын
Thank you. You're awesome Leila!
@SuperVandy293 ай бұрын
How did you open the symbols window
@rthsw5 ай бұрын
How smart... Cool!
@user-yo7fx2xn8m5 ай бұрын
Thank u
@snehlatasingh73035 ай бұрын
I can not find the symbols/shapes by doing right click. How to find it? Can anyone help
@chakralamurali5 ай бұрын
Excellent madam
@spongebobby1884 ай бұрын
"First I'm taking a sip of coffee" ...dayam the arrogance....I love it!
@LeilaGharani4 ай бұрын
😁
@benjamincastro64235 ай бұрын
@LeilaGharani Do you offer a monthly subscription tp xelplus?
@LeilaGharani5 ай бұрын
Sorry no. Our courses are one-time payments with lifetime access.
@brunoca55315 ай бұрын
how can we get coffe break today at 10:30?
@hernancovarrubias91395 ай бұрын
Great Leila. Thanks a lot for this video. A question: how did you get the menu when you are inserting a symbol? I open my Excel635 I can not find this menu. Any hep is welcome
@LeilaGharani5 ай бұрын
You get to the emoji picker with Windows key + period (.)
@tastyw0rm5 ай бұрын
For decimal values, for the chart, couldn't you just multiply the values by 100 (for .xx) example?
@noellongwe75745 ай бұрын
Cool stuff
@jojohnes58633 ай бұрын
how can this multipicker be activated
@theoblanca10625 ай бұрын
Godspeed✅
@TheTimaios5 ай бұрын
Hello Leila! Im from Brazil and 179 USD for me is so expensive.... :(
@ansar3115 ай бұрын
Hi would like to learn vba from beginning. Which videos to start with