As someone who is typically in the role of the Excel "pro" on my team, I can say these scenarios do happen. Thanks for the laughs and informative videos, Leila.
This Noob & Pro pair is hilarious! 😂 and sure to be a 'hit'! Turning the column into bar chart hack is cool Leila! Never imagined that, so thank you for sharing! 👍
"You picked the wrong thing to be good at". Whoa....that line just shook my brain! Kind of reformatted the way I think about things! Lovely video as always! Great information and very easy to understand.
Love the creativity in creating the bar chart! That’s a great use of Excel out-of-the-box without having to find or purchase charting plug-ins! Leila saving us time and money!
For the column chart, you could also do a trendline for the target column bars, and hide the columns. This way, you can stretch the trendline through the entire plot area. And, the trendline method works on a bar chart too. I was impressed with the fake bar chart method though.
@@steffenwei9926 When you do the trendline, you have to right-click on it, format trendline, and set the Forward and Backward values to .5. This way, the trendline goes from end-to-end. Maybe, we will put it on the Techronology site.
I don't disagree but have personal cases where we want to see both especially when comparing to other periods years prior... pretty pictures for people less data inclined
Thanks for the video. It's very rare when a boss has sufficient Excel advanced skills and also has got enough time and patience for explaining 🙂 The lesson is nice and funny
I try to be that boss whenever I can. As a result I have 4 people working under me who are far better at Excel now than they were when I hired them. So it's also paying dividends in total productivity. If you have competent people, it always pays to teach them skills.
@@j.ballsdeep420 basically I stop and show them whenever they’re doing something I know how to do faster/better/more efficiently. Sometimes that means teaching a new formula and other times it could be using something they already know in a different way like conditional formatting etc
Hi, Leila. You are so lucky to have a helper who doesn't know exactly what you want to teach us. She must be psychogenic or something! Thanks for sharing! Stay Healthy!
This is super easy if you use table, Great tip! I do want to add something since you have videos on dynamic charts using filter function... If you need it to be within a filter query, you can use HSTACK to combine your filter array with your static "Target" number in the last column (which can also reference a cell you update). That way the chart stays dynamic as all the data is within the same array. I've been fiddling around with dynamic charts that can switch between different measures, products, varying number of columns based on a user selection. It can get pretty complex! I'd love to see a video on tips to help avoid "breaking" the dynamic chart when a formula error occurs by using an IFERROR array to keep the array the chart references intact so to speak.
I feel such a fool for not thinking of that way to produce a target line myself. And the way to turn the chart around was really helpful too - opens up all sorts of possibilities. Thanks for another great video!!
OK, the first bit I've been doing for years, but the dynamic picture made my head explode. Whoa. (And I've seen plenty of charts with the target line just drawn in. This happened so many times that I added it to the team's Excel training mini challenges.)
You are the best teacher I could have regarding excel basics and advance but unfortunately I dont have money to buy your courses but to watch here in your channel. Greetings from Philippines, you inspire me to be Data Analyst ☺️❤️
Microsoft has a plethora of knowledge including free certifications for certain things but they have training and knowledge on all of their products available for free as a 365 subscriber.
To be fair, her initial solution would have not only been acceptable to me, I would also have been impressed by her accuracy in estimating where 280 was. I would have paid for her to be taking your courses, of course.. but her method wasn't terrible in the meantime.
So you are okay with continuing to waste labor re-creating basic visuals for your reporting? Sheesh, must be nice to not be a publicly traded company constantly driving lean operations as much as possible, bleeding your company of needless and frankly frivolous over spending when a more accurate and dynamic option exists that, once implemented or even more useful trained to your data analytics team if they're unaware, would continue immediately providing you a ROI on the said implementation by reducing said OPEX.
@@Cra3ier -- it isn't the fastest once this method is implemented because you can set any chart to be dynamic and refresh upon opening, so should anyone add to the source data location or refrence it would immediately change and adapt to said new data being added because you aren't having to recreate it ever again. Would it be faster the first time? Probably, but your ROI would be short and once you break even from the manually method it simply becomes a net positive return on creating such automation.
@@j.ballsdeep420 Man you clearly haven't worked a day in your life, talking like that. Publicly traded companies are FULL of people doing dumb stuff because they don't have appropriate skills. If it works it works, no one cares, you'll know when you grow up.
Interesting way to 'ad-lib' a bar chart (although I thought the first chart was perfectly fine ... 😁). Informative as always ... 😍 PS - At the 1:18 mark " ... I don't like the table design ... let's go and remove that design ... ". Really??? ... that's a shocking surprise! ... 🤭
I greatful to Leila Gharani as i learnt enough from her channel, serving as account analyst, her tips and tricks have given me a new life, Shahab Ali Pakistan
Common approach I've been using except for the vertical chart. I really like that approach. I knew I was going to learn something new on a technique I use often. Thanks!
There are three basic solutions fot these tasks: A) Line Chart (and second axis) B) Linear Trendline C) Error Bars and Caps + D) Leila's linked image :-)
Pro Leila is getting better every time. Just that initial gesture waving Noob to the side is not very positive. You could try a different style, more positive and inviting to help. On the content: super great as usual. PS: introducing the ruler is so old school - didn’t expect to see that anymore. LOL! :-)
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
As someone who is typically in the role of the Excel "pro" on my team, I can say these scenarios do happen.
Thanks for the laughs and informative videos, Leila.
ruclips.net/video/DpnfXypG7Ls/видео.html
This Noob & Pro pair is hilarious! 😂 and sure to be a 'hit'! Turning the column into bar chart hack is cool Leila! Never imagined that, so thank you for sharing! 👍
Thanks Vijay! Always a pleasure seeing your comments!
@@LeilaGharani WOW Mam you keep an eye on your subscribers comment I just love it
I liked the phrase ‘Step aside, let me show you’ 😂
"You picked the wrong thing to be good at".
Whoa....that line just shook my brain! Kind of reformatted the way I think about things!
Lovely video as always! Great information and very easy to understand.
Thanks for watching!
Love the creativity in creating the bar chart! That’s a great use of Excel out-of-the-box without having to find or purchase charting plug-ins! Leila saving us time and money!
What a great idea of making a link picture, really i love it
Thank you! Cheers!
never thought about it. I never use it. Such a hack
For the column chart, you could also do a trendline for the target column bars, and hide the columns. This way, you can stretch the trendline through the entire plot area. And, the trendline method works on a bar chart too. I was impressed with the fake bar chart method though.
This. The trend line stopping in the middle of the bar is ugly. ( And I don't even speak about those arrows)
@@steffenwei9926 When you do the trendline, you have to right-click on it, format trendline, and set the Forward and Backward values to .5. This way, the trendline goes from end-to-end. Maybe, we will put it on the Techronology site.
I don't disagree but have personal cases where we want to see both especially when comparing to other periods years prior... pretty pictures for people less data inclined
Thanks for the video.
It's very rare when a boss has sufficient Excel advanced skills and also has got enough time and patience for explaining 🙂 The lesson is nice and funny
I try to be that boss whenever I can. As a result I have 4 people working under me who are far better at Excel now than they were when I hired them. So it's also paying dividends in total productivity. If you have competent people, it always pays to teach them skills.
@@BEM684 -- How do you personally teach them the skills?
@@j.ballsdeep420 basically I stop and show them whenever they’re doing something I know how to do faster/better/more efficiently. Sometimes that means teaching a new formula and other times it could be using something they already know in a different way like conditional formatting etc
You are the first channel i go to for Excel advice! Another excellent video, thank you.
You are a Magician. Today I found your channel and am already blown away. Currently watching the Noob vs Pro playlist. Crazy Good!!
Hi, Leila. You are so lucky to have a helper who doesn't know exactly what you want to teach us. She must be psychogenic or something! Thanks for sharing! Stay Healthy!
Loved this video Leila. The conflict of having to get something done quickly helps raise the stakes of the video!
Glad you enjoyed it!
Great job, Leila, as always. Not only educational, but funny as well.
Whoa! I've been doing this manually for years on the vertical line piece. Paste as linked picture. You're such a genius!
OMG another funny entertaining video and very educational. I never did target line vertically so that is a new trick I'm intending to use.
that was a lot of fun, loved the idea of copying the column and turning it round.
Glad you enjoyed it!
This is super easy if you use table, Great tip!
I do want to add something since you have videos on dynamic charts using filter function... If you need it to be within a filter query, you can use HSTACK to combine your filter array with your static "Target" number in the last column (which can also reference a cell you update). That way the chart stays dynamic as all the data is within the same array.
I've been fiddling around with dynamic charts that can switch between different measures, products, varying number of columns based on a user selection. It can get pretty complex! I'd love to see a video on tips to help avoid "breaking" the dynamic chart when a formula error occurs by using an IFERROR array to keep the array the chart references intact so to speak.
I feel such a fool for not thinking of that way to produce a target line myself.
And the way to turn the chart around was really helpful too - opens up all sorts of possibilities.
Thanks for another great video!!
This video is hilarious! I learned something new and I will certainly not forget it easily. Thanks Leila for another incredible video!
Haha, could be. Smart Noob!
Love your videos! I have become the go-to person at work in all things Excel thanks to you.
Loving the new sassy role playing! Of course, it wouldn't be anything without your proficient and very detailed tutorials. Keep it up!
Yay, thank you!
Thank u. Great video
Great teaching and that voice 😊👍❤️
Thank you! 😃
It has been a long time since I don't learn something new regarding charts... Massive hack is the second solution... It was fun to know it!
OK, the first bit I've been doing for years, but the dynamic picture made my head explode. Whoa. (And I've seen plenty of charts with the target line just drawn in. This happened so many times that I added it to the team's Excel training mini challenges.)
Glad it was helpful!
WOW this was awesome. I knew there had to be a way to do this - thanks for sharing!
Real pro. Loved the linked picture trick!
With you, I can never finish learning. Thank you so much!
Las Vegas, Nevada, USA: Leila's so friggin' awesome! I have 4 graphs I'm working on right now and will use both these features! THANK YOU!!!
Great way to show a chart is made! :)
You are the best teacher I could have regarding excel basics and advance but unfortunately I dont have money to buy your courses but to watch here in your channel. Greetings from Philippines, you inspire me to be Data Analyst ☺️❤️
Microsoft has a plethora of knowledge including free certifications for certain things but they have training and knowledge on all of their products available for free as a 365 subscriber.
To be fair, her initial solution would have not only been acceptable to me, I would also have been impressed by her accuracy in estimating where 280 was. I would have paid for her to be taking your courses, of course.. but her method wasn't terrible in the meantime.
Ikr? The first method is the fastest though not the most accurate, suitable if you need to draw it in seconds in front of everyone during presentation
Stop larping dude, you're a nobody without any employees
So you are okay with continuing to waste labor re-creating basic visuals for your reporting? Sheesh, must be nice to not be a publicly traded company constantly driving lean operations as much as possible, bleeding your company of needless and frankly frivolous over spending when a more accurate and dynamic option exists that, once implemented or even more useful trained to your data analytics team if they're unaware, would continue immediately providing you a ROI on the said implementation by reducing said OPEX.
@@Cra3ier -- it isn't the fastest once this method is implemented because you can set any chart to be dynamic and refresh upon opening, so should anyone add to the source data location or refrence it would immediately change and adapt to said new data being added because you aren't having to recreate it ever again. Would it be faster the first time? Probably, but your ROI would be short and once you break even from the manually method it simply becomes a net positive return on creating such automation.
@@j.ballsdeep420 Man you clearly haven't worked a day in your life, talking like that. Publicly traded companies are FULL of people doing dumb stuff because they don't have appropriate skills. If it works it works, no one cares, you'll know when you grow up.
U dont disappoint us u alway come some thing new to learn us this is great thanks alot.
You're so smart... That's a masterpiece!
This series are so great Leila. 😃
Glad you enjoy it!
Bar chart as rotated linked picture?!! That's brilliant!!!!!!!
Glad you like it 😊
I KNEW THIS! You finally showed a solution in Excel that I already knew. YES! 😀
Brilliant, I was trying to add a vertical target line a few weeks ago and gave up in the end. will be adding this to my dashboard in the morning.
O
YOU definetely are my Excel Goddess. no special clue, I didn't get from you. WOW!!
Thank you Leila. The bar chart trick is very impressive.
Brilliant as usual. A "simple trick" but I've never thought about it
That was Awesome, a scenario in the real situation
Thank you and appreciation from the bottom of my heart
I like the ideas but also the voices! 🤣
I think, we all have moments when we are noobs, that's why we watch your videos.🥰
Interesting way to 'ad-lib' a bar chart (although I thought the first chart was perfectly fine ... 😁).
Informative as always ... 😍
PS - At the 1:18 mark " ... I don't like the table design ... let's go and remove that design ... ".
Really??? ... that's a shocking surprise! ... 🤭
Haha, what can I say. It just bothers me 😁
That was cool. Loved the way this was presented.
Awesome, thank you!
😂😂😂 like the solution of the noob 😂😂😂😂😂 so funny. You're talented Liela 🤩🤩🤩
Bless you, lady!
I recently had this issue: target on the Y axis. I did my best to find solutions. However, your solution is great Leila. Thanks!
Fantastic! I’ll use this next week!!
👍
Linked picture as bar chart! I never imagined it this way Leila. Thanks for it.
My pleasure!
Paste as linked picture: great trick I didn't know yet. Thank you Leila!
My pleasure, Michael!
What a great way to show how to do this. Please do more like these 👍
Great Tip for sales and marketing reports.
Nice trick for converting column to bar chart.
These sketches will start cutting into my Netflix time!😄
😁
For some reason or another I like Noob Leila.She is so cute! :)
This was amazing Leila. You are amazing. I love you.
This channel should have 100M subscribers .. at least!!
Best thing of corona lock down was me finding this channel:)
learned something new, thanks Leila
I greatful to Leila Gharani as i learnt enough from her channel, serving as account analyst, her tips and tricks have given me a new life, Shahab Ali Pakistan
Pretty useful again. Besides, "subscribe to rewind" is huge.
Great series!
brilliant..never knew this before..
Thank you for the excellent explanation!
Excellent, this was a great help as I wanted to get my work correct. many thanks
Glad it helped
Im just a college students but never got so excited to use excel help to do a lot of stuff
Common approach I've been using except for the vertical chart. I really like that approach. I knew I was going to learn something new on a technique I use often. Thanks!
Glad you found something new, David!
Great idea for the chart, I will take this idea to draw an average. Thank you,
Absolutely Loved it
That bar chart is so cool 😎. Thanks for sharing. 🙂
Thank God for the ThinkCell add-in. I hate making graphs in Excel with the buildin tools.
👍
There are three basic solutions fot these tasks: A) Line Chart (and second axis) B) Linear Trendline C) Error Bars and Caps + D) Leila's linked image :-)
😁
Pro Leila is getting better every time. Just that initial gesture waving Noob to the side is not very positive. You could try a different style, more positive and inviting to help.
On the content: super great as usual.
PS: introducing the ruler is so old school - didn’t expect to see that anymore. LOL! :-)
Thanks for the feedback, Geert!
This was an awesome trick!
good to know new things ! everey time we improve
Explained very well... thanks!
Our pleasure!
"Let me just draw it" is going to be the header of my excel tips for new associates on my team...
😁
Wow! That was genius
Glad you liked it, Rodrigo!
Great video! 😀
Always great tutorials. You have taught me so much. Thank you
Great video!
So many thanks Leila
Great linked picture hack! I do very few charts so the easier the better for me!!
Always such helpful tips, thank you. Always trust the ruler🤣
Always! 😁
Very nice acknowledgement of Nichelle Nichols recent passing by including her character's name in your sample data, Leila. Are you a Star Trek fan?
This is very smart. thank you.
She’s so good . Damn 🤩🤩
OMG, thank you! You just help me to save A LOT of time!! Wow
I love it👍
04:22 - That's most accurate thing in Noobs approach to work! LOL!
Brilliant hack to make it a bar chart! Thank you so much!
You are so welcome!
Thanks for your video.❤❤❤
Brilliant!!!
Excellent stuff. Thank you!
Excel should come up with a target line to be honest. So many times I need this.
You're so funny 😂😂😂 Thank you very much.
Some greats tips as usual! Thanks for sharing Leila :)
this tip is perfect for my control chart! thanks!