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.
"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.
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! 👍
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!
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.
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.)
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
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
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!
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.
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!!
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!
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
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.
Dear Laila, I often follow your excellent posts. I have a question: is there a formula in excel that returns the selected (positioned) row or column? Thank you for your reply.
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.
ua-cam.com/video/DpnfXypG7Ls/v-deo.html
"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!
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
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’ 😂
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!
You are the first channel i go to for Excel advice! Another excellent video, thank you.
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.
Whoa! I've been doing this manually for years on the vertical line piece. Paste as linked picture. You're such a genius!
Loved this video Leila. The conflict of having to get something done quickly helps raise the stakes of the video!
Glad you enjoyed it!
You are a Magician. Today I found your channel and am already blown away. Currently watching the Noob vs Pro playlist. Crazy Good!!
Great job, Leila, as always. Not only educational, but funny as well.
Fantastic! I’ll use this next week!!
👍
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!!!
Thank you Leila. The bar chart trick is very impressive.
that was a lot of fun, loved the idea of copying the column and turning it round.
Glad you enjoyed 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!
This was amazing Leila. You are amazing. I love you.
Paste as linked picture: great trick I didn't know yet. Thank you Leila!
My pleasure, Michael!
Love your videos! I have become the go-to person at work in all things Excel thanks to you.
WOW this was awesome. I knew there had to be a way to do this - thanks for sharing!
U dont disappoint us u alway come some thing new to learn us this is great thanks alot.
Thank you and appreciation from the bottom of my heart
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
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!
With you, I can never finish learning. Thank you so much!
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
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!
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.
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
That was Awesome, a scenario in the real situation
You're so smart... That's a masterpiece!
Great idea for the chart, I will take this idea to draw an average. Thank you,
Real pro. Loved the linked picture trick!
I recently had this issue: target on the Y axis. I did my best to find solutions. However, your solution is great Leila. Thanks!
What a great way to show how to do this. Please do more like these 👍
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.
Excellent, this was a great help as I wanted to get my work correct. many thanks
Glad it helped
Thank you for the excellent explanation!
Great Tip for sales and marketing reports.
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!
Excellent stuff. Thank you!
Bar chart as rotated linked picture?!! That's brilliant!!!!!!!
Glad you like it 😊
Brilliant as usual. A "simple trick" but I've never thought about it
Nice trick for converting column to bar chart.
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!!
Linked picture as bar chart! I never imagined it this way Leila. Thanks for it.
My pleasure!
Always great tutorials. You have taught me so much. Thank you
That bar chart is so cool 😎. Thanks for sharing. 🙂
Great teaching and that voice 😊👍❤️
Thank 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!
Great way to show a chart is made! :)
Brilliant hack to make it a bar chart! Thank you so much!
You are so welcome!
That was cool. Loved the way this was presented.
Awesome, thank you!
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!
This channel should have 100M subscribers .. at least!!
YOU definetely are my Excel Goddess. no special clue, I didn't get from you. WOW!!
I KNEW THIS! You finally showed a solution in Excel that I already knew. YES! 😀
Great linked picture hack! I do very few charts so the easier the better for me!!
Explained very well... thanks!
Our pleasure!
learned something new, thanks Leila
Some greats tips as usual! Thanks for sharing Leila :)
Thank u. Great video
This series are so great Leila. 😃
Glad you enjoy it!
Thanks Leila! I didn't know how to do this
this tip is perfect for my control chart! thanks!
Bless you, lady!
Great series!
This was an awesome trick!
Absolutely Loved it
good to know new things ! everey time we improve
OMG, thank you! You just help me to save A LOT of time!! Wow
brilliant..never knew this before..
"Let me just draw it" is going to be the header of my excel tips for new associates on my team...
😁
Thank God for the ThinkCell add-in. I hate making graphs in Excel with the buildin tools.
👍
This is very smart. thank you.
I love your lessons!!!!
Excelent. Thank you Leila.
Pretty useful again. Besides, "subscribe to rewind" is huge.
Thanks for your video.❤❤❤
Thanks Leila for this video. Please how to plot the taget when we have different targets values . Thanks
Love this series, good solution.
Best thing of corona lock down was me finding this channel:)
Damn that’s was fun and humorous and informative. Wow thanks Leila.
Great video! 😀
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?
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
Great video!
Love this format, funny and super informative (as usual). Does sheets have this level of functionality ?
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.
So many thanks Leila
Im just a college students but never got so excited to use excel help to do a lot of stuff
Dear Laila, I often follow your excellent posts.
I have a question: is there a formula in excel that returns the selected (positioned) row or column?
Thank you for your reply.
These sketches will start cutting into my Netflix time!😄
😁
I love it ! Thank you and this style of videos is very fun and riveting can you do one on monthly / weekly cashflow forecast ? 😀
For some reason or another I like Noob Leila.She is so cute! :)
Combo charts are great
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.🥰
Wow! That was genius
Glad you liked it, Rodrigo!
this is just great!