4 Hidden Excel Dashboard Design Tips for Beautiful Reports

[@LeilaGharani]

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

[@csarmurillo]

I've purchased many of Leila's courses in Udemy, subscribed to her KZbin 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.

[@LeilaGharani]

Wow, thank you, César!

[@excelisfun]

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

[@LeilaGharani]

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

[@PeggyStinson]

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.

[@LeilaGharani]

You're so welcome, Peggy!

[@aytviewer2421]

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]

Glad to have you aboard, Kelsey!

[@SheilaMills-lu5ju]

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 KZbin and on Udemy. There is so much more to excel than just calculating rows and columns. The potential is huge.

[@cor351]

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

[@bharatmomaya]

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

[@NK__NK__NK]

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

[@aloktripathi7433]

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

[@mannyjrdelacruz5398]

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

[@LeilaGharani]

Glad it was helpful!

[@mannyjrdelacruz5398]

@@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!

[@emilycestari]

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

[@usefullguide8634]

yes she explain very well always

[@IvanCortinas_ES]

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!

[@LeilaGharani]

Glad it was helpful, Iván!

[@jeanong9693]

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

[@LeilaGharani]

You're very welcome, Jean!

[@iawwad]

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

[@LeilaGharani]

You're very welcome!

[@23Boarder10]

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.

[@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!

[@shreyg91]

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

[@carmenzal7214]

Dear Leila. Thank you for your time and knowledge.

[@exceljunction4420]

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

[@frijoli9579]

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

[@LeilaGharani]

You are so welcome!

[@nikolaykarakashov6324]

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!!

[@LeilaGharani]

Glad it's helpful Nikolay.

[@mattschoular8844]

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

[@LeilaGharani]

Glad you think so Matt!

[@Roger-mg8zh]

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

[@hiDhaval]

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

[@LeilaGharani]

Glad it was helpful!

[@zahratorabi7638]

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 :)

[@LeilaGharani]

😘

[@imranmushtaq7445]

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

[@missasmita]

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

[@LeilaGharani]

Glad it's helpful!

[@MrTuanHoangAnh]

I m still watch and learn from this video in Nov. 2024 😊❤

[@RamakrishnanRukmini]

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.

[@UcanHdz]

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

[@mohammedhassan2808]

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

[@LeilaGharani]

So nice of you!

[@nicolaspettini3143]

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

[@LeilaGharani]

Glad you like them, Nicolas!

[@mcd22630]

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]

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

[@brendandavid2691]

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!

[@LeilaGharani]

Happy to help!

[@finmatrixparadigm7904]

How I will get to equipped with xl for accounting report

[@imr4nkhan]

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

[@dvpe]

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

[@LeilaGharani]

Thank you! 😃

[@landonchurch1]

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

[@LeilaGharani]

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

[@nomorel7884]

Best Excel video tutorials out there. Thanks

[@LeilaGharani]

Wow, thanks!

[@JCLEACHIANALITICS]

Hi Leila. Excelent tutorial. Thanks for your job.

[@neldopardoyuvero5181]

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

[@chadmace3355]

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...

[@LeilaGharani]

Thanks for watching!

[@NareshKumar-tk5gp]

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

[@LeilaGharani]

Our pleasure!

[@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.

[@syedshah9411]

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

[@cassandra2037]

I felt very satisfied with myself that I knew most of these haha! Your tip on the linked picture chart is an absolute game changer for me though! Please don't ever stop making content.

[@LeilaGharani]

That's great Cassandra! Thanks for sharing your tip. I love it!

[@WilliamCase]

Best channel on KZbin. Thanks so much.

[@LeilaGharani]

Wow, thanks William!

[@yourbutlerza]

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!! :)

[@LeilaGharani]

Great to hear!

[@shakiraasfoor7599]

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

[@LeilaGharani]

Glad you found something useful.

[@MrBrewsk]

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.

[@susanmcgraw8290]

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

[@LeilaGharani]

Glad you liked it Susan.

[@elisagonzales4262]

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

[@LeilaGharani]

Great to hear, Elisa!

[@philmingo]

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

[@jeroenpostma908]

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

[@LeilaGharani]

Happy to hear that Jeroen!

[@jkornfeld]

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

[@LeilaGharani]

Thanks for watching!

[@TitoChinitoPH]

What a lovely set, Ms. Leila...

[@LeilaGharani]

Thank you! 🤗

[@AshokKumar-sy2qt]

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.

[@LeilaGharani]

Happy to hear that!

[@wayneedmondson1065]

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]

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

[@banukani]

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

[@LeilaGharani]

Thank you! Will do!

[@NaftuliSinger]

Part 1: Is there a way to make any other formulas in a shape (other than just cell referencing?) Part 2: When you hide all the columns and all the rows and realise that you need to unhide each one separately... Part 3: Also very important that you can double click and set names for each object so you don't get mixed up when you have a bunch of objects. Part 4: No comment... Thanks again so much for all your videos, it really does help me a lot, I appreciate your time!

[@alzour29]

Its so helpful in simple professional explanation , thank you .

[@ca.lokenderchauhan2605]

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

[@LeilaGharani]

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

[@phillipgregory8476]

You have been transforming my Excel skills for a while now, thank you so much!

[@LeilaGharani]

Great to hear Phillip!

[@JudeBarak]

Thanks Leila, as always - great tips. Every time I think I know the subject and then you show some angle I had never thought about. You are a great source of knowledge to both beginners as well as experts.

[@LeilaGharani]

Wow, thank you!

[@dashrathpanchal8393]

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

[@jerichojon007]

Thanks a lot, apart from index and match, everything was new for me. Keep it up!

[@olipeeeeee]

Sparkline as Linked Picture - wow that magic! Thx. 🙏

[@diannedrechsler4792]

Thanks Leila, I never thought to show as a linked picture, I've been using the camera tool or watch window. Good idea to ungroup the Smartart too, I normally find them quite inflexible

[@aroundthehousewithcarlosan21]

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

[@LeilaGharani]

Awesome, thank you!

[@SothearithKONGMrMuyKhmer]

It’s beautiful. Thanks Leila for sharing this useful tips. 🙏😍

[@LeilaGharani]

My pleasure 😊

[@stanislavnichta152]

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!

[@LeilaGharani]

Thank you so much, Stanislav!

[@sushantapaul4910]

Excellent Presentation with excellent tips. Thanks.

[@LeilaGharani]

My pleasure!

[@bluephoenix624]

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

[@LeilaGharani]

Happy to hear that!

[@irfanabbassi9202]

Outstanding Tips ... Thanks for improving our Excel ... 🌼🎖️

[@LeilaGharani]

My pleasure

[@ScottAnders62]

I always learn something from Leila. Thank you!

[@ryanmiguelsantiago]

Linked pictures are a revelation! Thank you 😁

[@LeilaGharani]

Glad you like them, Ryan!

[@teoxengineer]

The forth one is EXCELent!! Tnajk you Leila

[@LeilaGharani]

Glad you like it Emre.

[@shironmania]

It has been always a very authentic way of explaining /describing /teaching new tips and tricks for excel development... Adorable learning them @leila, as excel has an oceanic usage of datas and information to explore and learn from...thanks again

[@cristianomasciulli6472]

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

[@LeilaGharani]

Glad I could help Cristiano!

[@qiaorongchang8605]

Leila, you are just a goddess of Excel! Love your voice and videos! It s short clip but informative. 👍

[@LeilaGharani]

Wow, thank you!

[@darrylmorgan]

Hi Leila!Wow Love The LINKED PICTURE Tip, Defineitley One To Try.I Use Hide Unused Rows And Columns Quite Often In Work..All Really Great Tips Thank You :)

[@LeilaGharani]

Linked picture is often overlooked but can be quite powerful. Glad you liked the tips.

[@hassanalianees5530]

Sparkline was great. Thanks

[@monte4955]

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

[@LeilaGharani]

Thank you 😊

[@nickvalera1017]

Leila - I love your work

[@johng5295]

Thanks in a million. Great referral Nicholas!

[@francisgilounet6016]

you are just wonderful ..thanks for the tips

[@jobygeorgev06]

Simply wonderful

[@lisat7850]

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

[@LeilaGharani]

Glad you think so Lisa!

[@MrCheongkl33]

best excel teacher.

[@17aig]

Dear Leila what can I say and not being said already thank you so much for a great tutorial AGAIN!!!

[@LeilaGharani]

You are so welcome!

[@DRawlins100]

That was awesone Leila. Thank you!

[@LeilaGharani]

Glad you liked it!

[@praveenk1672]

Thanks, all the tips were useful

[@Chubbienog]

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

[@LeilaGharani]

Glad to hear that

[@DougHExcel]

Smart Art always bring back fond memories first learning excel...thanks for the video

[@LeilaGharani]

My pleasure Doug!

[@rakeshbabu5043]

very useful tips, thanks very much!

[@nipunkavinda8254]

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

[@LeilaGharani]

Glad you like them!

[@usefullguide8634]

Very Usefull Leila Gharani Thanks

[@ShemaOneGod]

Amazing! Love these videos!

[@LeilaGharani]

Thanks so much!

[@rksudera]

Superb as usual!🌹

[@africazanella6963]

life learners gathering .Love it Leila