Excel Dynamic Chart with Drop down List (column graph with average line)

  Рет қаралды 432,704

Leila Gharani

Leila Gharani

Күн бұрын

Пікірлер: 345
@LeilaGharani
@LeilaGharani 9 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/dynamic-chart-file
@gecemetrosu9734
@gecemetrosu9734 4 жыл бұрын
I want to thank you 1.000.000 times for your teaching method and share the workbook , I appreciate and grateful for your channel
@noexpert1481
@noexpert1481 7 жыл бұрын
you are by far the best excel instructor on youtube
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thank you very much for the kind words - there are great Excel channels on KZbin - the fact that you think mine is good does mean a lot. Thank you for your support.
@indradevdubey
@indradevdubey 4 жыл бұрын
Hey Leila, there are many channels on you tube for excel but the way you explains is very simple and understanding, I am learning a lot from your videos. This really help me a lot to upscale my excel skills. Thank you for all your efforts to make people learn excel in easier and interesting way. Keep up the Good Work. Thanks 😘
@stevenng8556
@stevenng8556 4 жыл бұрын
@@LeilaGharani You are the best Excel instructor in KZbin
@fayi85
@fayi85 3 жыл бұрын
As usual, Leila makes it easier. No complex explanation, no jargons. Simple presentation that anyone can understand
@juangregory
@juangregory 2 жыл бұрын
Leila: I've watched half a dozen of these index/match videos, and I just wasn't getting it. And I had to watch yours several times, but then the light went ON and now I've saved HOURS of work. Thank you so much.
@tun-tunninc.6492
@tun-tunninc.6492 9 күн бұрын
Data validation and source. Gasp!!!! You're incredible. Thank you!!
@Sman201
@Sman201 7 ай бұрын
Worked like a charm, thank you greatly!
@mikepike7063
@mikepike7063 4 ай бұрын
I love this lady - and her tutorials are so concise and clear.
@elactecnology
@elactecnology Жыл бұрын
I call her the Queen of Excel. Thank you Leila🥰
@luisolivaresferre3600
@luisolivaresferre3600 4 жыл бұрын
Best excel teacher in youtube, I will be definetely enrolling in one of your courses!
@federicomassimo3898
@federicomassimo3898 4 жыл бұрын
Can't believe the things that you do with Excel... It's music listening to you, with peace, breaking de world!!!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Wow, thank you Federico.
@ms.najneenislam9553
@ms.najneenislam9553 6 жыл бұрын
You are the best instructor indeed!! cause you let us show about the most necessary practical examples which are really helpful for corporate life that makes you different fron others. God bless you :)
@AdiCristea
@AdiCristea 7 жыл бұрын
What I love is that after watching your videos and taking your courses for a week now, I knew straight away the answer is going to be Data Preparation and Index/Match. Thank you for making my mind work this way!
@LeilaGharani
@LeilaGharani 7 жыл бұрын
This made me smile :) Thank you Adi for your comment. I'm glad to hear you enjoy the courses.
@mohant664
@mohant664 6 жыл бұрын
You are one of the best Excel tutor in the KZbin especially teaching complex things in simple steps......Thanks a lot..
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you for the kind words!
@michaelb1785
@michaelb1785 4 жыл бұрын
Definitely the best excel instructor on you tube. Very professional!
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Wow, thanks Michael!
@mathieudager4234
@mathieudager4234 2 жыл бұрын
Wow, your vids are State of the Art. Thanks ever so much for these. Can’t believe these are available for free 🤩
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you like them!
@RaviKumar-gz9my
@RaviKumar-gz9my 4 жыл бұрын
Excellent. It helped Again. Leila has given all the Solutions for all the Practical Issues. Thanks again.
@vusalzeynalov1692
@vusalzeynalov1692 5 жыл бұрын
So easy to follow up. Absolutely not boring. You are smart and also beautiful. Keep it up. Greetings from Azerbaijan.
@1gopalakrishnarao
@1gopalakrishnarao 7 жыл бұрын
Every video is helping a lot to the Excel learners/users/addicts. As usual A BIG SALUTE, FROM THE BOTTOM OF MY HEART TO MY BELOVED EXCEL TEACHER, With a sincere request to start the series of VBA, A prayer to the almighty to bless her good health, as she is doing a great and noble job. MAKING THINGS EASIER with Excel tricks/tips/Graphs and what not in the days to come.
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thank you very much Gopala. I am thankful for your support! I will start VBA in the new year. I am already putting together the topics and will start filming once I get a few projects out of the way for this year.
@1gopalakrishnarao
@1gopalakrishnarao 7 жыл бұрын
My Beloved Teacher, You are a great person, I appreciate your interest, zeal, enthusiasm, vigour, grit, dexterity and tenacity in publishing videos in Excel, and making things very easy. Waiting eagerly for your new videos.
@sanjeevmishra106
@sanjeevmishra106 6 жыл бұрын
Simplicity at its best!!!!. I really appreciate the way you explain things. Great work.. keep it the way it is...
@LeilaGharani
@LeilaGharani 6 жыл бұрын
Thanks a lot! Glad you like it :)
@davidjsaul
@davidjsaul 3 жыл бұрын
Thank you so much for this. I was trying to read how to do this on various websites but getting really confused. Followed your video to the letter and it worked fine (even though I still have no clue what half the formulas mean!).
@whatsupdown4181
@whatsupdown4181 5 жыл бұрын
I like your simplicity in explaining
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Glad you like it!
@mpurintun
@mpurintun 2 жыл бұрын
This was exactly what I was looking for. AND - you made it sound so easy. Can't thank you enough....
@anish_k
@anish_k 5 жыл бұрын
Thanks a lot mam, your teaching methodology is outstanding and thanks again for not including any advertisement, and you just earned yourself a satisfied student (subscriber).
@ThePimpLoving
@ThePimpLoving 5 жыл бұрын
Definitely 1 of the best excel Instructors...Learned and still learning a lot from your videos...keep the good Work up.. God Bless
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thank you for the kind words. I'm glad you find the tutorials helpful.
@aek3945
@aek3945 6 жыл бұрын
Leila, thank you so very much for taking your time to prepare Excel videos.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
You're very welcome. Thank you for watching, commenting & supporting.
@aek3945
@aek3945 6 жыл бұрын
My pleasure...Also, do you have videos on preparing a budget? Kind regards,
@mikemmmuema5270
@mikemmmuema5270 7 жыл бұрын
You cant understand how you help people leila but all in all you do a great job thanks for the good lessons you give us
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Ohhh thank you Mike for your kind words & thank you for your support.
@lenava68
@lenava68 3 жыл бұрын
You really explain things in a very easy manner. Cool !! Good call!. Please put more videos like this ..Thank you
@wenj2011
@wenj2011 6 жыл бұрын
Great video, you use simple words and make things so clear and easy.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
I'm very glad to hear that. Thanks for your support.
@s.anandanatarajan650
@s.anandanatarajan650 3 жыл бұрын
Always your video will help to improve my skill in excel
@subratadutta4562
@subratadutta4562 5 жыл бұрын
Very crisp and clear
@t3geek
@t3geek 7 жыл бұрын
Your videos have helped me become much better at my job.....thanks!
@LeilaGharani
@LeilaGharani 7 жыл бұрын
You're welcome Josh! I'm very happy to hear that. Thanks for your comment.
@davidbond70
@davidbond70 7 жыл бұрын
Hi Leila, Your videos are really helping me to understand excel, I truly appreciate the work you have put in.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
Thank you David for your comment & support! I'm glad you find the videos useful :)
@charlie5116
@charlie5116 Жыл бұрын
Once again, goddess of excel helped me out.
@youtugal
@youtugal 5 жыл бұрын
Very good instruction. short and to the point!! thank you. Also you gave many tips for issues which I struggled with!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
You're very welcome. I'm glad the tutorial is helpful.
@fritsieboiker8449
@fritsieboiker8449 Жыл бұрын
Thanks a lot for this video. Alleviated my frustrations quite a bit
@jayavelanhari197
@jayavelanhari197 2 жыл бұрын
Dear ma'am Excellent information.i am one of your regular learner of your video Thanks
@iwonasajdak2893
@iwonasajdak2893 4 жыл бұрын
Thank you for all your videos. They are very helpful and you really are a great teacher
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Glad you like them Iwona!
@margaritochacon840
@margaritochacon840 3 жыл бұрын
Great explanation and easy to follow, thank you so much.
@deveshkumar2736
@deveshkumar2736 6 жыл бұрын
Really Nice I'm an excel freak and I love the way you explain
@PankajSharma-gi6qj
@PankajSharma-gi6qj 4 жыл бұрын
Thanks Leila Gharani. very well explained!!
@parichaybhatt46
@parichaybhatt46 3 жыл бұрын
Great vdo, great explanation for the concept. Your way of teaching makes it easier to understand the concepts in one go. Love ur vdos. Greetings from India❤️
@mro3un663
@mro3un663 4 жыл бұрын
Thank you for sharing. Please do more tutorials with financial charts and graphs.
@knk1451
@knk1451 3 жыл бұрын
Exact video I looking for me & clear all doubt in One watch only... Great
@Dhanesh87
@Dhanesh87 2 жыл бұрын
Thank you for your helpful video lessons.
@mistofstars
@mistofstars 5 жыл бұрын
I didnt know index could be with two match formulas, so learned again something. Cool! And the chart is simply but super impressive!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Yes, it can be really handy. Glad you like the tutorial.
@szymondybowski7868
@szymondybowski7868 5 жыл бұрын
You are doing a very good job by showing us all these tricks to make our excel skills godlike.... :) keep it up, fantastic explanations and easy to understand.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I will do my best :) Glad you like the tutorials.
@fernandopaiva8979
@fernandopaiva8979 6 жыл бұрын
Hi Leila, I speak from Brazil, your videos are amazing! very well learn skills other cultures of the world! to continue with the work! very good
@LeilaGharani
@LeilaGharani 6 жыл бұрын
Thank you Fernando for your very nice comment. I am glad to hear you like the videos : )
@felipemendes7408
@felipemendes7408 6 жыл бұрын
Dear Leila, hope you're having a great day. Firstly, thank you for sharing your Excel knowledge with us.This technic is highly usable and your channel is great. Secondly I want to ask you, if I may: why not to use the dynamic chart resource derived from an pivot table and which one do you prefer? Thanks!
@siujiawong2607
@siujiawong2607 2 жыл бұрын
Thank you so much! This video is very clear and useful!
@goutamtiwari2334
@goutamtiwari2334 3 жыл бұрын
Great explanation, Thanks.
@edithmona5433
@edithmona5433 6 жыл бұрын
You help a lot in my computer course!!!!! Great video!!!
@LeilaGharani
@LeilaGharani 6 жыл бұрын
I'm very happy to hear that Edith :)
@bayarsaikhanbaljinnyam6635
@bayarsaikhanbaljinnyam6635 7 ай бұрын
Thank you, I am from Mongolia.
@osham5206
@osham5206 4 жыл бұрын
It's awesome, simple & organized Leila. Great Job :)
@inesmariz6507
@inesmariz6507 5 жыл бұрын
this saved my statistics group project
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Glad to help Inês.
@johnalexisfranco8265
@johnalexisfranco8265 4 жыл бұрын
Thanks for the index match tutorial. I'm learning this other one too!
@siddharthsaini9972
@siddharthsaini9972 6 жыл бұрын
Hi Leila, Very simple and well explained. I am specializing in excel after seeing your excel video. Thanks a Lot
@shockhopful
@shockhopful 6 жыл бұрын
I've watching your videos for the past month! THANK YOU SO MUCH!!! YOU'VE SAVED ME SO MANY TIMESS!
@ich_bin_vishal
@ich_bin_vishal 3 жыл бұрын
I got that in one go with the help of this video, amazing, thank you so much for these quick and easy tutorials :) :)
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Great to hear!
@vijayppt2007
@vijayppt2007 3 жыл бұрын
very useful for the charting.Thanks
@AbhishekTripathidce
@AbhishekTripathidce 4 жыл бұрын
This is really fantastic. thank you for this video and million of thanks for your effort for making and uploading .
@ShoaibAhmed-bc3sb
@ShoaibAhmed-bc3sb 5 жыл бұрын
Thank you so much. I am not good in charts and i was looking for this and finally i learned it.
@LeilaGharani
@LeilaGharani 5 жыл бұрын
That's great to hear. I'm glad the tutorial is helpful.
@CoachMattDoming
@CoachMattDoming 2 жыл бұрын
I love you Leila, you saved my day
@deepakjames52
@deepakjames52 4 жыл бұрын
You are the art of mastering..
@ibraheemmshezad400
@ibraheemmshezad400 4 жыл бұрын
wl mam ur teaching level is very god i am satisfied about ur lecture
@richardgordon
@richardgordon Жыл бұрын
Pretty awesome video! Many thanks!
@COLA888
@COLA888 4 жыл бұрын
Excellent! You are so smart! Thank you!
@ManjuSharmaksa123
@ManjuSharmaksa123 5 жыл бұрын
EXCELLENT, Your are the best excel teacher. wonderful Leila, Thanks
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Thanks for the kind words!
@AshokKumarYadav-qx4jq
@AshokKumarYadav-qx4jq 4 жыл бұрын
Very Good chart. Can be change the colour of the chart dynamically while selecting the another value from drop down list
@ruchigupta6520
@ruchigupta6520 5 жыл бұрын
Lovely work Leila. Thank u so much. Being a beginner trying to work around. Great help !!!
@LeilaGharani
@LeilaGharani 5 жыл бұрын
I'm glad it's helpful!
@shruthit3104
@shruthit3104 2 жыл бұрын
Thank youuuuuuuuuu. I was looking for this
@hariradhu
@hariradhu 6 жыл бұрын
Hi Leila Gharani, I become your fan for the lovely vedios and your extrem knowledge in Excel. Hat's of to you.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
Thank you for your comment & support. I'm glad you like the videos you see here. I don't have extreme knowledge though.... I'm still learning everyday....
@rslive2k
@rslive2k 4 жыл бұрын
You're god sent.. Love from INDIA
@sunjaytube
@sunjaytube 5 жыл бұрын
Nice explanation and presentation. Thank you so much for your guidance
@LeilaGharani
@LeilaGharani 5 жыл бұрын
You're very welcome. Glad you like the video.
@OzduSoleilDATA
@OzduSoleilDATA 7 жыл бұрын
Good video! I agree. Having a prep area is easier to manage and troubleshoot than a named range.
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thanks Oz :)
@abhishekkedia9859
@abhishekkedia9859 4 жыл бұрын
Great Content.Loved It.Keep this coming.
@jacobmnisi
@jacobmnisi 4 жыл бұрын
Hi I really watching your videos, they are so educational
@LeilaGharani
@LeilaGharani 4 жыл бұрын
Happy to hear that!
@wangpaul1924
@wangpaul1924 Жыл бұрын
well explained, thanks!
@shyamalpal6937
@shyamalpal6937 6 жыл бұрын
Hi!Leila, I am very much impressed by the way you teach excel. Now let me know whether I can insert table for the array so that I may keep on updating data bring into the dropdown list.
@michaeldiamond2726
@michaeldiamond2726 7 жыл бұрын
HI Leila Great idea about leaving the raw data untouched by using a calculation table to provide the chart data. Kinda reminds me how you set up a dashboard - raw data, calculation, summary sheet. You've essentially created a mini dashboard on one sheet! Michael
@LeilaGharani
@LeilaGharani 7 жыл бұрын
You're right Michael! I like that. A mini dashboard in one sheet :) Sorry haven't got back to you on the other stuff yet. Will be catching up later today.
@michaeldiamond2726
@michaeldiamond2726 7 жыл бұрын
:)
@theengineonfire
@theengineonfire 2 жыл бұрын
You are a genius!! Thanks
@satyasrinivas480
@satyasrinivas480 6 жыл бұрын
Leila, Excellent video on Dynamic Chart. So kind of you. Thanks a lot for your tutorial. :)
@LeilaGharani
@LeilaGharani 6 жыл бұрын
You're very welcome Satya. Gald you like it.
@raghuv7114
@raghuv7114 4 жыл бұрын
Hi Madam, As per your earlier lectures We can use offset with match function directly in name manager to make it dynamic chart. Syntax as below Offset = ($A$4,0,match(A12,C4:N4,0),5,1) Please correct and suggest me if I am wrong.
@victorcox3227
@victorcox3227 4 жыл бұрын
Just Brilliant!! you amaze me
@flightforge30
@flightforge30 6 жыл бұрын
perfect teacher for excel!!!
@sanawarali4727
@sanawarali4727 5 жыл бұрын
Thanks, excellent work, you got a new subscriber
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Great! Glad to have you here.
@johnborg6005
@johnborg6005 7 жыл бұрын
Thanks Leila. I am a new comer to your sight. I just got to know about it a while ago. I will start following all yr videos in the future. They are interesting and informative. :)
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thank you John for your support! I'm very glad to hear you find the videos informative :)
@johnborg6005
@johnborg6005 7 жыл бұрын
God Bless you and Mike :)
@ViktorNikolov93
@ViktorNikolov93 4 жыл бұрын
Thank you so much for the added value. :)
@LokeshSharma-vw7ku
@LokeshSharma-vw7ku 4 жыл бұрын
its easy and you are the best ever
@ghazalkz4540
@ghazalkz4540 4 жыл бұрын
خیلی خیلی ممنون. واقعا مفید بود
@PraveenDamarla
@PraveenDamarla 5 жыл бұрын
good one and easy to learn. thanks for the Video
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Glad you like the tutorial.
@afzauddin7634
@afzauddin7634 5 жыл бұрын
Hi Leila Gharani I'm always watching your video and practice in my Laptop, thanks for explanation, I don't know influence English but I understood very well. few days before I was send comment but that is still no answer, but I like your videos thumps up 👍
@LeilaGharani
@LeilaGharani 5 жыл бұрын
Glad you like the videos!
@aftabhussain6428
@aftabhussain6428 4 жыл бұрын
A very informative and helpful
@AlvinRyellPrada
@AlvinRyellPrada 7 жыл бұрын
This is super awesome. Love how you make it simple for me to understand lol Ps :my boss was impressed when i did the custom formatting magic happened on my NPS report..the one with the smileys lol big fan of your data visualisation techniques :)
@LeilaGharani
@LeilaGharani 7 жыл бұрын
Thanks Alvin for your comment - That's great about your boss! simple tricks go a long way :)
@rienthongw
@rienthongw 7 жыл бұрын
You are my angle. This VDO can help me to make a great presentation. Thank you so much. :)
@LeilaGharani
@LeilaGharani 7 жыл бұрын
You're very welcome & I'm very happy to hear you find it useful for your work :)
@SamvadSoul
@SamvadSoul 6 жыл бұрын
Very nicely explained
@LeilaGharani
@LeilaGharani 6 жыл бұрын
Thank you Sanjay. Glad you like it.
@joealexander2181
@joealexander2181 3 жыл бұрын
Thank you Leila.
@eng.hafizhabibhabib1268
@eng.hafizhabibhabib1268 5 жыл бұрын
EXCELlent presentation
@kabootty
@kabootty 6 жыл бұрын
Excellent idea. Thanks for sharing knowledge.
@LeilaGharani
@LeilaGharani 6 жыл бұрын
You're very welcome.
@wilfortdanielpenafernandez373
@wilfortdanielpenafernandez373 5 жыл бұрын
THANK YOU FOR ALL YOU ARE THE BEST
3 REALLY Useful Excel Chart Tips You May Have Missed
5:53
Leila Gharani
Рет қаралды 88 М.
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,6 МЛН
这是自救的好办法 #路飞#海贼王
00:43
路飞与唐舞桐
Рет қаралды 103 МЛН
Players vs Pitch 🤯
00:26
LE FOOT EN VIDÉO
Рет қаралды 39 МЛН
Yay, My Dad Is a Vending Machine! 🛍️😆 #funny #prank #comedy
00:17
Perfect Pitch Challenge? Easy! 🎤😎| Free Fire Official
00:13
Garena Free Fire Global
Рет қаралды 58 МЛН
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 466 М.
Searchable Drop Down List in Excel (Very Easy with FILTER Function)
11:00
I don't use OFFSET Anymore! I Use Another Function Instead.
20:32
MyOnlineTrainingHub
Рет қаралды 67 М.
Dependent Drop Down List in Excel Tutorial
11:10
Kevin Stratvert
Рет қаралды 640 М.
这是自救的好办法 #路飞#海贼王
00:43
路飞与唐舞桐
Рет қаралды 103 МЛН