First 1000 people who use the link will get 2 free months of Skillshare premium: https://skl.sh/xelplus11
Creating Excel Dashboards can be very time consuming. You need to define the most important key performance indicators and find a reliable data source for your dashboard. But the visual representation of the data is just as important.
Don’t just plaster the report with numbers! Keep enough white space and use shapes to create emphasis. Of course, finding the right balance and implementing it in your Excel Dashboard can take a LOT of time.
In this Excel tutorial, I show you 4 hidden Excel tips that can help you to create a clean, well-designed and informative dashboard without wasting a lot of time.
Leila’s Hidden Dashboard 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
Many thanks to Skillshare for sponsoring this video!
⯆ Read the full article & download workbook: https://www.xelplus.com/excel-hidden-dashboard-tips
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel