4 Hidden Excel Dashboard Design Tips for Beautiful Reports

Discover four amazing hidden tips and tricks to create stunning Excel dashboards or reports quickly and easily. This video is perfect for anyone looking to enhance their Excel skills, especially in dashboard design. Learn about transforming SmartArt into shapes, hiding unused rows and columns, selecting objects from the Selection Pane, and using linked pictures to overcome cell boundaries.

What You'll Learn:
▪️ Convert SmartArt to Shapes: How to use SmartArt for sophisticated shapes and connect them to cell values.
▪️ Hide Unused Rows and Columns: Tips on restricting the user's view to focus on the essential parts of the dashboard.
▪️ Select Objects from the Selection Pane: A clever way to manage multiple objects on your dashboard efficiently.
▪️ Use Linked Pictures for Flexibility: Learn to use sparklines and linked pictures to display dynamic data without cell size limitations.

00:00 Excel Dashboard Design Tips
00:55 Convert SmartArt to Shapes
03:32 Hide Unused Rows and Columns
04:20 Select Objects from the Selection Pane
05:15 Use Linked Pictures

🚩Let’s connect on social:

Many thanks to Skillshare for sponsoring this video!

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[csarmurillo]

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

[excelisfun]

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

[aytviewer]

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.

[aloktripathi]

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

[PeggyStinson]

omgosh - watching this video sends me into a tailspin, diving very 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.

[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

[dashrathpanchal]

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

[bharatmomaya]

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

🌷

[Boarder]

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.

[cor]

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

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

[zftskkn]

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!

[NK__NK__NK]

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

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

[mattschoular]

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

[diannedrechsler]

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

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

[ScottAnders]

I always learn something from Leila. Thank you!

[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

[banukani]

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