First 1000 people who use the link will get 2 free months of Skillshare premium: skl.sh/xelplus11
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.
⬇️ Download the workbook here: pages.xelplus.com/dashboard-t...
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.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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
23 июн 2024
