4 Hidden Excel Dashboard Design Tips for Beautiful Reports

Поделиться
HTML-код
  • Опубликовано: 16 янв 2025

Комментарии • 458

  • @LeilaGharani
    @LeilaGharani  11 месяцев назад

    Grab the file I used in the video from here 👉 pages.xelplus.com/dashboard-tips-file

  • @csarmurillo
    @csarmurillo 3 года назад +35

    I've purchased many of Leila's courses in Udemy, subscribed to her RUclips channel and her newsletter, and even though I've been working with Excel daily for the last 5 years at least, there's not one subject I haven't learned at least a useful tip from her. I really recommend her content for anyone who wishes to get better at their job.

  • @PeggyStinson
    @PeggyStinson 3 года назад +4

    omgosh - watching this video sends me into a tailspin, diving very lowwwww! I only realize how much I don't know about using Excel when I watch stuff like this. So happy that you share your information with us.

  • @excelisfun
    @excelisfun 4 года назад +48

    Without a doubt, the linking elements to cells is THE best dynamic dashboard trick : )

    • @LeilaGharani
      @LeilaGharani  4 года назад +4

      True! That's a great functionality. By the way, I'm looking forward to your new book next year!

  • @cor351
    @cor351 4 года назад +1

    Lots to learn from you. clear video with very good explanation, thanks.

  • @SheilaMills-lu5ju
    @SheilaMills-lu5ju 3 месяца назад

    Like a lot of people I have used Excel on a daily basis during my working life. I have learned a lot from Leila's video's on RUclips and on Udemy. There is so much more to excel than just calculating rows and columns. The potential is huge.

  • @aytviewer2421
    @aytviewer2421 2 года назад +1

    I've used Excel for 30+ years and I learned a couple new tips today. I had no idea Excel had evolved so much. I've been using it much the same way as I have since the late 1980s (no joke)! Thank you Leila! Much appreciated and Subbed.

    • @LeilaGharani
      @LeilaGharani  2 года назад

      Glad to have you aboard, Kelsey!

  • @NK__NK__NK
    @NK__NK__NK 2 года назад

    This is the best channel on Excel in RUclips! Thank you Leila!

  • @mannyjrdelacruz5398
    @mannyjrdelacruz5398 4 года назад

    SmartArt to Shapes, Selection Pane, and the Sparklines... didn't know about those before this video. Thanks Leila!

    • @LeilaGharani
      @LeilaGharani  4 года назад

      Glad it was helpful!

    • @mannyjrdelacruz5398
      @mannyjrdelacruz5398 4 года назад

      @@LeilaGharani yup, greatly helpful particularly the "sparklines". I've seen those in some reports in the company i worked for and never really knew how to do it. I thought 'twas just a normal line graph that they resized to fit in a cell. hahahaha!

  • @bharatmomaya
    @bharatmomaya 2 года назад

    You are amazingly passionate about Office and Windows. We learn a lot of new things from your videos. God bless you!!
    🌷

  • @jeanong9693
    @jeanong9693 3 года назад

    I learned about Sparkline through this video. This tip will help improve my excel presentations at work. Thanks Leila for sharing !

  • @emilycestari
    @emilycestari 2 года назад +2

    Incredible video-I absolutely love your content. Thank you for helping me be more efficient!

  • @exceljunction4420
    @exceljunction4420 4 года назад

    Beauty with brain. Simply love ur excel courses & tips.. .

  • @shreyg91
    @shreyg91 4 года назад

    All of these are new to me. Thanks Leila for these tricks

  • @aloktripathi7433
    @aloktripathi7433 4 года назад +14

    i'm very thankful to you, i'm a huge fan of your excel tips, every Thursday i wait for your new video eagerly...

  • @frijoli9579
    @frijoli9579 3 года назад

    I enjoyed all of this tutorial, but tip four was completely off my radar. THANK YOU! Too simple.

  • @BertvanderMeer-t7r
    @BertvanderMeer-t7r Год назад

    Thank you Leila! I just saw this video, only now. Really helpful and cool tips!
    I usually regard myself as proficient in Excel, yet I didn't master any of your tips yet.
    Funny: your link to two months of Skillshare is still working!

  • @Roger-mg8zh
    @Roger-mg8zh 3 года назад

    Vielen Dank ! ja coole tipps ...hilft mir gerade mein Optischen Aufbau des Dashboards ...schönes weekend !

  • @carmenzal7214
    @carmenzal7214 4 года назад

    Dear Leila. Thank you for your time and knowledge.

  • @JCLEACHIANALITICS
    @JCLEACHIANALITICS 2 года назад

    Hi Leila. Excelent tutorial. Thanks for your job.

  • @imranmushtaq7445
    @imranmushtaq7445 3 года назад

    Very informative ma'am for your continuous support of years.

  • @TitoChinitoPH
    @TitoChinitoPH 4 года назад

    What a lovely set, Ms. Leila...

  • @imr4nkhan
    @imr4nkhan 2 года назад

    Way too cool Leila! ... great content and style in your videos

  • @jkornfeld
    @jkornfeld 7 месяцев назад

    Selection pane is very cool! I did not know about that. Love your content!

  • @iawwad
    @iawwad 4 года назад +1

    Wonderful Leila, never thought of using a linked picture as a graph before, sometimes we oversee the easy stuff. Thanks for the real tip

  • @NareshKumar-tk5gp
    @NareshKumar-tk5gp 4 года назад

    Superb....Thank you for educating.
    Lots of love from India.

  • @nomorel7884
    @nomorel7884 4 года назад

    Best Excel video tutorials out there. Thanks

  • @IvanCortinas_ES
    @IvanCortinas_ES 4 года назад

    Excellent summary of tips, which usually go unnoticed. Excel is not just about making gigantic formulas, but about making good data presentations. Thank you for your video Leila!

  • @RamakrishnanRukmini
    @RamakrishnanRukmini 3 года назад

    Excellent short sweet and specific stuff in Excel. Unknown to me and many I am sure.
    Many a time, no, every time, you make me realise, I am only a novice still in excel. I learn a lot and know I need to know a lot many. Cheers.

  • @hiDhaval
    @hiDhaval 4 года назад

    Super Tips! .. especially about SmartArt to Shapes, and Sparkle lines as dynamic image!

  • @neldopardoyuvero5181
    @neldopardoyuvero5181 4 года назад

    Good Morning! Absolutely you have made me love Excel!!!

  • @WilliamCase
    @WilliamCase 4 года назад

    Best channel on RUclips. Thanks so much.

  • @jeroenpostma908
    @jeroenpostma908 4 года назад

    Hi Leila,
    Watched several of your video's and they are great and helped me a lot.

  • @Chubbienog
    @Chubbienog 4 года назад

    nice video....learn so much from this video thanks..

  • @missasmita
    @missasmita 4 года назад

    I am learning so much from you. Thanks Leila. I also struggle with data visualisation from time to time.

  • @chadmace3355
    @chadmace3355 4 года назад

    old school chair is a nice look... good stuff... always learning... I use all of that except the last tip... thanks for the enjoyable presentation...

  • @landonchurch1
    @landonchurch1 4 года назад

    I greatly appreciate all your videos! The linked picture for the sparkline was awesome!

    • @LeilaGharani
      @LeilaGharani  4 года назад

      Glad you like it. It can really spice up your reports :)

  • @nickvalera1017
    @nickvalera1017 Год назад

    Leila - I love your work

  • @dvpe
    @dvpe 4 года назад

    Leila, you're awesome teacher and presenter, thumbs up for you! cheers!

  • @BalrogsHaveWings
    @BalrogsHaveWings Год назад

    Awesome tios as always!
    I have a macro for "design mode" which shows/ hides the formula bar, grid, headers and even the ribbon.
    Makes a nice clean UI.

  • @nicolaspettini3143
    @nicolaspettini3143 3 года назад

    Thanks a lot for these tips and tricks! Your pristine videos are so pleasant to watch and informative 😀

  • @aroundthehousewithcarlosan21
    @aroundthehousewithcarlosan21 4 года назад

    Loved the spark line, very useful tip. Very useful videos in your channel. Thanks!

  • @rakeshbabu5043
    @rakeshbabu5043 2 года назад

    very useful tips, thanks very much!

  • @23Boarder10
    @23Boarder10 4 года назад +9

    Leila - I love your work. You should do a video on how to create an interactive, dynamic excel dashboard for horizontal data! I'm trying to create this for data in a binomial tree and it's extremely frustrating.

  • @nikolaykarakashov6324
    @nikolaykarakashov6324 4 года назад

    The linked picture tip is extremely useful for more complex printable forms and reports, where shifting columns can mess up the layout and it can be used to display a set of cell contents, not just graphs. Thanks so much!!

  • @jobygeorgev06
    @jobygeorgev06 4 года назад

    Simply wonderful

  • @francisgilounet6016
    @francisgilounet6016 2 года назад

    you are just wonderful ..thanks for the tips

  • @alzour29
    @alzour29 3 года назад

    Its so helpful in simple professional explanation , thank you .

  • @usefullguide8634
    @usefullguide8634 2 года назад

    Very Usefull Leila Gharani Thanks

  • @AshokKumar-sy2qt
    @AshokKumar-sy2qt 4 года назад

    Hey Liela is quite a good amount of knowledge which you used to share i am following you on since long time and have also improvise my knowledge.

  • @joshuamanampiu6489
    @joshuamanampiu6489 4 года назад

    Learning so much. Thanks

  • @praveenk1672
    @praveenk1672 4 года назад

    Thanks, all the tips were useful

  • @mcd22630
    @mcd22630 4 года назад

    Great tips, especially how to use the selection pane and using a linked picture.
    Ms Gharani, I have the utmost respect for you as a person and as a professional. So it pains me to say I you to be a little less than honest. After viewing this video, its obvious you have a keen sense of design, creativity and taste.
    My thanks to you and Skillshare for the wonderful offer.

    • @LeilaGharani
      @LeilaGharani  4 года назад +1

      Haha, I definitely would not call it keen but thank you for the kind words 😘

  • @elisagonzales4262
    @elisagonzales4262 4 года назад +1

    Great video! This is going to help me with my work projects so much!

  • @susanmcgraw8290
    @susanmcgraw8290 4 года назад

    My favorite tip was the Hide rows and columns! Thanks!

  • @ca.lokenderchauhan2605
    @ca.lokenderchauhan2605 4 года назад

    I love your videos. I improved my excel a lot. God bless you

    • @LeilaGharani
      @LeilaGharani  4 года назад

      I'm glad to hear that. Keep learning :)

  • @UcanHdz
    @UcanHdz 3 года назад +1

    Maravillosos tips para excel, y la forma tranquila y didáctica en que los platican hace que sin importar el idioma se entiendan muy bien. Gracias

  • @mattschoular8844
    @mattschoular8844 4 года назад

    Thanks for sharing, Leila. Things that seem complicated at first glance become more simple with your tutorials...

  • @sushantapaul4910
    @sushantapaul4910 4 года назад

    Excellent Presentation with excellent tips. Thanks.

  • @philmingo
    @philmingo 4 года назад

    Sparkline -> linked as picture is a new one for me. Thanks!!

  • @hassanalianees5530
    @hassanalianees5530 2 года назад

    Sparkline was great. Thanks

  • @zahratorabi7638
    @zahratorabi7638 4 года назад

    She is the ecxel- goddess and yet so kind and down-to-earth. I am so grateful for having found her, i learn a lot from her :)

  • @bluephoenix624
    @bluephoenix624 4 года назад

    I really like the linked pictures concept. thanks a lot :)

  • @BuntriGuyTech
    @BuntriGuyTech 4 года назад

    I love your contents Leila.

  • @johng5295
    @johng5295 4 года назад

    Thanks in a million. Great referral Nicholas!

  • @gugamatiussi
    @gugamatiussi 4 года назад

    Thank you! I love your videos!

  • @danfeliciano570
    @danfeliciano570 3 года назад

    Thank you for this video.

  • @nipunkavinda8254
    @nipunkavinda8254 4 года назад

    Wow. Those tricks are amazing...!!!

  • @syedshah9411
    @syedshah9411 4 года назад

    Dear Leila, your videos should get at least a million views. Amazing

  • @ShemaOneGod
    @ShemaOneGod 3 года назад

    Amazing! Love these videos!

  • @felipescherer2131
    @felipescherer2131 4 года назад

    Incredible film set!

  • @MrBrewsk
    @MrBrewsk 2 года назад

    Excellent information in this video. Using the Spark Lines and the Selection Pane will definitely come in handy with some additional reporting responsibilities that I have been assigned to me. Great video.

  • @MrCheongkl33
    @MrCheongkl33 4 года назад

    best excel teacher.

  • @miantgv
    @miantgv 3 года назад

    Outstanding content!!

  • @africazanella6963
    @africazanella6963 4 года назад

    life learners gathering .Love it Leila

  • @TheAjju008
    @TheAjju008 4 года назад

    Very useful info.... Thanks

  • @apamwamba
    @apamwamba 4 года назад

    Tip 4 is super!!

  • @wayneedmondson1065
    @wayneedmondson1065 4 года назад

    Hi Leila.. great tips.. thanks for sharing them. I was not aware of #1.. that's a great one and I'll begin using it right away. I was aware of #2, 3 and 4.. likely from watching some of your other videos. Thanks again for all the good learning at your channel. Thumbs up!!

    • @LeilaGharani
      @LeilaGharani  4 года назад +1

      Hi Wayne. That's wonderful! Glad there was one new : )

  • @nour-eddineoumakhlouf5296
    @nour-eddineoumakhlouf5296 3 года назад

    Amazing!Thanks a lot.

  • @shakiraasfoor7599
    @shakiraasfoor7599 4 года назад

    All i can say is Thank You Leila
    Using Selection pane and Past as picture being dynamic Are New For me

    • @LeilaGharani
      @LeilaGharani  4 года назад +1

      Glad you found something useful.

  • @inxanadu8576
    @inxanadu8576 4 года назад

    Awesome! Subscribed ! thank you!!

  • @brendandavid2691
    @brendandavid2691 4 года назад +1

    I just wanted to say you're videos are extremely helpful! I'm an accounting student and am currently working on an assignment which involves creating a dashboard. Luckily I stumbled across this, I'll definitely be using these tips, thank you!

  • @farookjabbar3978
    @farookjabbar3978 4 года назад

    Useful Tips 👍

  • @stanislavnichta152
    @stanislavnichta152 4 года назад

    It is so nice to listen to you, You should think of voicing over something else as well! And props for the video quality. Keep up the great work. I don't need the tips, but I am big fan of how you approach the topic!

  • @mohammedhassan2808
    @mohammedhassan2808 4 года назад +6

    Thank you Leila ma'am for sharing knowledge with all (as usual) excellent tips, May God bless you

  • @IainMace
    @IainMace 4 года назад

    Didn't know about sparklines. Cool. Thanks

  • @banukani
    @banukani 4 года назад +4

    This is amazing! Love all your tips. keep them coming 👏👏 these tips help me a lot in my day-to-day work.

  • @yourbutlerza
    @yourbutlerza 4 года назад

    Hi Leila, me having not had any formal Excel training, are really enjoying your channel and especially the way in which you present your information. Well done and a huge thank you!! :)

  • @DRawlins100
    @DRawlins100 4 года назад

    That was awesone Leila. Thank you!

  • @dashrathpanchal8393
    @dashrathpanchal8393 4 года назад

    Hey Leila..again you came with unique techniques..love all the suggested techniques. Thanks for sharing.

  • @easonchen1209
    @easonchen1209 4 года назад

    Thank you a lots! I learned much today!

  • @georgemathew8494
    @georgemathew8494 4 года назад

    Super helpful as always !!

  • @lisat7850
    @lisat7850 4 года назад

    Thanks Leila ! good tips - practical and easy to use :)

  • @cristianomasciulli6472
    @cristianomasciulli6472 4 года назад

    I was just searching few days ago for the hide tip!!! Thanks a lot for your help!!

  • @edwinjonah
    @edwinjonah 4 года назад

    Thanks! These were really cool

  • @ronitgupta4070
    @ronitgupta4070 4 года назад

    Really great tips 💯

  • @keep_digging
    @keep_digging 4 года назад

    nice tips i particularly like the image spark line

  • @monte4955
    @monte4955 4 года назад

    Great Video Leila, thanks. Love the chair and backdrop.

  • @chrism9037
    @chrism9037 4 года назад

    Good tips, thanks Leila!

  • @teoxengineer
    @teoxengineer 4 года назад

    The forth one is EXCELent!!
    Tnajk you Leila